how to delete single row using php

Question

Dear please help me
i am getting some error in my code

this is my view.php page

<html>
   <body>
      <table  style="border:#333 solid"  border="2">
         <tr>
            <td>ID:</td>
            <td>NAME:</td>
            <td>EMAIL:</td>
            <td>MOBILE:</td>
            <td>EDIT:</td>
            <td>DELETE:</td>
         </tr>
<?php
include_once('connect.php');
$query="select * from emp";
$conn=mysqli_query($con,$query);
if(isset($conn))
{
  echo"This is all data of table.";
}
else
{
  die("query is not execute". mysqli_error());  
}   

 while($row=mysqli_fetch_array($conn))
 {
?>
  <tr>
    <td><?php echo $row['emp_id']; ?></td>
    <td><?php echo $row['emp_name']; ?></td>
    <td><?php echo $row['emp_address'] ?></td>
    <td><?php echo $row['emp_salary'] ?></td>
    <td><a href="edit.php?id=<?php echo $row['emp_id'];?>"><font   color="#FF0000">EDIT</font></a></td>
    <td><a href="delete.php?id=<?php echo $row['emp_id'];?>"><font   color="#FF0000">DELETE</font></a></td>
  </tr>
 <?PHP
 }
 ?>
       </table>
    </body>
 </html>

and this is my delete.php file:

  <?php 
  include_once('connect.php');
  $id=$_GET['emp_id'];
  $query="delete from emp where emp_id='$id'";
  $del=mysqli_query($con,$query);
  if($del)
  {
    echo"record has been deleted";  
  }
  else
  {
    die("Record is not deleted it is query error.".mysqli_error()); 
  }
  ?>

How can I access the ID of the view.php in the delete.php file and how to delete a single row in my db table. I don't understand how to access the id of view.php. In this program I don't delete the selected row. Please tell me how to delele data. please anyone help me.

score 3 · Accepted Answer · answered Aug 12 '14 at 09:45

3

You are sending edit.php?id= so need to get id from query string using GET['id']

$id = $_GET['id'];

answered Aug 12 '14 at 09:45

Rakesh Sharma

13,680
5
37
44

can you explain which id we can use here $_GET['ID'] – furkanali89 Aug 12 '14 at 09:50
it is database column name ? – furkanali89 Aug 12 '14 at 09:50
delete.php?id= so id= youremp_id which you are sending. No it's not db column name it's a query string variable – Rakesh Sharma Aug 12 '14 at 09:57
i understand. we can access using $_POST['id'] ? if no why? – furkanali89 Aug 12 '14 at 10:05
cause you are not posting any data you are sending as query string which will get using GET – Rakesh Sharma Aug 12 '14 at 10:08

score 1 · Answer 2 · answered Aug 12 '14 at 09:48

change the code in delete.php as follow

 <?php 
 include_once('connect.php');
 $id=$_GET['id'];
 $query="delete from emp where emp_id='$id'";
 $del=mysqli_query($con,$query);
 if($del)
 {
     echo"record has been deleted";   
 }
 else
 {
     die("Record is not deleted it is query error.".mysqli_error());  
 }
 ?>

score 0 · Answer 3 · edited May 23 '17 at 11:46

Please also realize that using $_GET data within your queries is only asking for trouble, especially when it's not escaped properly. You're opening your self up to SQL injection attacks.

Make use of mysql_real_escape_string if you're going to be using mysql_* functions, just realize that it has been deprecated in PHP 5.5.

You also have the option of using MySQLi or PDO would be preferable since they both make use of prepared statements as mentioned in this previous question How can I prevent SQL-injection in PHP?

how to delete single row using php

3 Answers3