unable to delete data in table using sql

Question

I am trying to delete row from table. Table name is username of user (which user logged in )

delete page is here

require('db.php');
if(isset($_POST["deletebtn"])){
   $x = $_SESSION['username'];
   $id=$_POST["statusid"];
   $row=$conn->query("select id from $x where id='$id'");
   if ($conn->query($row) === TRUE) {
      $sql = "delete from $x where id ='$id'";
      //  echo 'success';
      header( "Refresh:3; url=admin2.php", true, 303);
   }else{
      echo "not";
   }
 }

and here is my content code

$sql = "SELECT id,date,status FROM $x order by id DESC;";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
   while($row = $result->fetch_assoc()) {
      $id = $row['id'];
      echo "<div class='border'> ";
      echo "";
      echo "<form action='deletepage.php?action=$id'>";
      echo "<input type='hidden' name='statusid' value='$id' >";
      echo  "<p> " . $row["status"] ."</p><br>";
      echo "<input type='submit' value='delete' class='btn1 pull-right' name='deletebtn'> ";
      echo "<a class=' btn1 pull-right' href='#'>edit &nbsp;&nbsp;</a>";
      echo  "<small> " . $row["date"]. "</small><br>";
      echo "</form>";
      echo "</div>";            
    } 
} else {............}

user3526204 · Accepted Answer · 2017-03-04 09:24:34Z

5

You are not executing query on the sql

$sql = "delete from $x where id ='$id'";

Execute it like

$del= $conn->query($sql);

After the query

answered Mar 4, 2017 at 9:24

user3526204

5095 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

B. Desai · Accepted Answer · 2017-03-05 04:14:44Z

2

You forgot to execute query

require'db.php';
if(isset($_POST["deletebtn"])){
$x = $_SESSION['username'];
$id=$_POST["statusid"];
 $row="select id from $x where id='$id'"; //<---remove query execution from here
 if ($conn->query($row) === TRUE) {
   $sql = "delete from $x where id ='$id'";
    $conn->query($sql); //<-------- Add this line
 //  echo 'success';
   header( "Refresh:3; url=admin2.php", true, 303);
  }else{
 echo "not";
 }
 }

edited Mar 5, 2017 at 4:14

answered Mar 4, 2017 at 9:24

B. Desai

16.4k5 gold badges28 silver badges48 bronze badges

1 Comment

kartik Over a year ago

still not work require'db.php'; if(isset($_POST["deletebtn"])){ $x = $_SESSION['username']; $id=$_POST["statusid"]; $row=$conn->query("selet id from $x where id='$id'"); if ($conn->query($row) === TRUE) { $del = "delete from $x where id ='$id'"; $conn->query($del); // echo 'success'; header( "Refresh:3; url=admin2.php", true, 303); }else{ echo "not"; } }

Community · Accepted Answer · 2023-11-17 20:18:02Z

0

There are several problems with your code.

there is no query execute for delete query.(which you may be solved later)
in your while loop you put $conn->query ($row) which is wrong. $row is not a query... It is the result set return from previous query.
and lastly $conn->query does not return true in SELECT, SHOW, DESCRIBE or EXPLAIN query. Check php manual

edited Nov 17, 2023 at 20:18

CommunityBot

11 silver badge

answered Mar 4, 2017 at 11:59

reza

1,5072 gold badges12 silver badges17 bronze badges

Comments

Obodugo Prince · Accepted Answer · 2017-03-04 10:52:38Z

-1

Change this $sql = "delete from $x where id ='$id To$sql = "delete from $table where id ='$sessionid'

answered Mar 4, 2017 at 10:52

Obodugo Prince

1

2 Comments

shaggy Over a year ago

Like he said - table name is username, so using $x variable is ok. There are no $table and $sessdionid variables, your answer is useless.

shaggy Over a year ago

@kartik you have the solution on the top in the answer with most votes.

Collectives™ on Stack Overflow

unable to delete data in table using sql

4 Answers 4

Comments

1 Comment

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related