Monday 3 September 2018

php delete sql query does not work

     <?php
      include('session.php');
         ?>

       <?php
       $conn = new mysqli("127.0.0.1","root","","foo");
    if ($conn->connect_errno) {
       echo "Failed to connect to MySQL: (" . $conn->connect_errno . ") " .           $conn->connect_error;
    }
  $sew = $_SESSION['login_user'];
  $a=$_GET["en"];
  $l=1;
  $d= -1;

   if($a==1)
  {
     $sqlw = " INSERT into dlkeuser VALUES('$a','$sew')" ;

   if ($conn->query($sqlw) === FALSE)
   {
 echo "you have already disliked the song";

  }
 else
  {
 //query1
   $sql  = " DELETE FROM lkeuser WHERE userid = '$sew' AND songid = '$a' " ;

 //query2
       $sql = "UPDATE liking
       SET count = count - 1 ";

       if ($conn->query($sql) === TRUE) {

        echo "you disliked the song";

       }
   else {
          echo "Error: " . $sql . "<br>" . $conn->error;
  }

    }

In this php code snippet , query1 is not working whereas query 2 is fine . I am trying to insert (songid,userid) in dlkeuser(dislike) table against user i/p($_GET["en"]) and delete the record(songid,userid) from lkeuser(like) table if it exists. (songid,userid) pair is the composite primary key here. "count" is the net like/dislike of a song. I am new to php . Thanks for any help you can provide.

let's try this,
it will work
<?php
      include('session.php');
         ?>

       <?php
       $conn = new mysqli("127.0.0.1","root","","foo");
    if ($conn->connect_errno) {
       echo "Failed to connect to MySQL: (" . $conn->connect_errno . ") " .           $conn->connect_error;
    }
  $sew = $_SESSION['login_user'];
  $a=$_GET["en"];
  $l=1;
  $d= -1;

   if($a==1)
  {
     $sqlw = " INSERT into dlkeuser VALUES('$a','$sew')" ;

   if ($conn->query($sqlw) === FALSE)
   {
 echo "you have already disliked the song";

  }
 else
  {
 //query1
   $sql  = " DELETE FROM lkeuser WHERE userid = '$sew' AND songid = '$a' " ;

 //query2
       $sql1 = "UPDATE liking
       SET count = count - 1 ";

      if ($conn->query($sql) === TRUE) {

        echo "deleted the song";

       } 

       if ($conn->query($sql1) === TRUE) {

        echo "you disliked the song";

       }
   else {
          echo "Error: " . $sql . "<br>" . $conn->error;
  }

    }

0 comments:

Post a Comment