when i refresh will delete all records

by

try this code

 <?php 
$sql="SELECT * FROM administrators";
$record=mysql_query($sql);


function drop($id,$email){
$q="DELETE FROM administrators WHERE id='$id' AND email="$email"";
mysql_query($q);
header("Refresh:0");
}
if (isset($_GET['drop'])) {
  $id=$_GET['id'];$email=$_GET['email'];
drop($id,$email);
}
?>
<title>Admins Table</title>
<style>
table, th, td {
border: 2px solid black;
border-collapse: collapse;
}  
#creating {
font:bold;
font-size:1.6em;
}
</style>
<a href="https://stackoverflow.com/questions/35550971/cadmin.php"  id='creating'>Create New Admin</a><br/><br/>
<table width="920" border="1" cellpadding="1" cellspacing="1">
<tr>
<th>Number</th>
<th>First Name</th>       
<th>Last Name</th>
<th>Phone Number</th>
<th>Gender</th>
<th>Email</th>
<th>Address</th>
<th>Update</th>


   <th>Delete</th>
  </tr>
 <?php

  while($row=mysql_fetch_assoc($record)){
   echo'<tr>';
   echo'<td>'.$row['id'].'</td>';
   echo'<td>'.$row['first_name'].'</td>';
   echo'<td>'.$row['last_name'].'</td>';
   echo'<td>'.$row['phone'].'</td>';
   echo'<td>'.$row['gender'].'</td>';
   echo'<td>'.$row['email'].'</td>';
   echo'<td>'.$row['address'].'</td>';
   echo'<td>'."<a href="" onclick=''>Edit</a>".'</td>';
    echo'<td>'."<a href="?     drop=ss&id=".$row["id'].'&email=".$row["email']."'>              Drop</a>".'</td>';
 echo'</tr>';
 }

?>

More Related Contents:

  1. Pass PHP variable value into HTML label [closed]
  2. Submit a form using Shift + Enter [duplicate]
  3. Date format using dd/mm/yyyy using HTML
  4. Php condition doesn't work for html [closed]
  5. php variable changes when clicked on html link [closed]
  6. Upvote / Downvote
  7. Thank you for helping [closed]
  8. Auto responder mail reverts fill all fields when i have filled them
  9. Login form using HTML
  10. HTML input arrays
  11. Print string with a php variable in it
  12. How to create a HTML Table from a PHP array?
  13. Sending HTML email from PHP
  14. How to insert HTML to PHP DOMNode?
  15. PHP header() redirect with POST variables [duplicate]
  16. Using PHP substr() and strip_tags() while retaining formatting and without breaking HTML
  17. Convert PDF to HTML [closed]
  18. PHP keep checkbox checked after submitting form
  19. PHP Upload, extract and progressbar
  20. How can I parse JSON into a html table using PHP?
  21. How to embed images in a single HTML / PHP file?
  22. Hiding a Div using php
  23. onbeforeprint() and onafterprint() equivalent for non IE browsers
  24. HTML PHP Progress Bar
  25. Setting POST variable without using form
  26. How to post multiple as array in PHP?
  27. HTML 5 multi file upload with PHP
  28. HTML form PHP post to self to validate or submit to new page
  29. multiple buttons on a form
  30. mysql_fetch_array skipping first row

Leave a Comment