Edmhar Edmhar - 2 years ago 88
PHP Question

Delete Script PHP MySQL

I'm beginner in PHP MySQL, all I want to know how to create a DELETE function for this each specific records.

enter image description here

Here is my code when I SELECT the records. I don't know how I will insert the DELETE function and how code structure be like.

$res=mysql_query("SELECT * FROM accounts WHERE user_id=".$_SESSION['user']);

$sql = "SELECT * FROM accounts ORDER BY agentFname ASC";

if($result = mysql_query($sql)){
if (mysql_num_rows($result) > 0 ) {

<table id="example" class="table table-striped responsive-utilities jambo_table">


<tr class="headings">


echo "<th>ID</th>"; // Primary Key
echo "<th>Agent Code</th>"; // Unique Key
echo "<th>First Name</th>";
echo "<th>Middle Name</th>";
echo "<th>Last Name</th>";
echo "<th>Contact Number</th>";
echo "<th>Address</th>";
echo "<th>Gender</th>";
echo "<th>User Type</th>";
echo "<th>Action</th>";
echo "</tr>";
echo "</thead>";

} while($row = mysql_fetch_array($result)) {

echo " <tr class=\"even pointer\">";

echo "<td>" .$row['user_id']. "</td>"; // Primary Key
echo "<td>" .$row['agentCode']. "</td>"; // Unique Key
echo "<td>" .$row['agentFname']. "</td>";
echo "<td>" .$row['agentMname']. "</td>";
echo "<td>" .$row['agentLname']. "</td>";
echo "<td>" .$row['agentContact']. "</td>";
echo "<td>" .$row['agentAddress']. "</td>";
echo "<td>" .$row['agentGender']. "</td>";
echo "<td>" .$row['user_type']. "</td>";
echo "<td> <a href=\"#.php\"> Delete</a></td>"; // DELETE Function
echo "</tr>";


Answer Source

just pass the user id in href with file name.

echo "<td> <a href="yourfile.php?id=<?php echo $row['user_id'];?>"> Delete</a></td>";

then create your file. example your filename.php



$sql=mysql_query("DELETE FROM tablename where user_id='$id'");

if($sql > 0)
  echo "record successfully deleted";
 echo "errore in deleting";

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download