rhoula

Untitled

Nov 14th, 2012
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. ############### Code
  2.  
  3. <?php
  4.  
  5. $host="localhost"; // Host name
  6. $username="emma01_sitetos"; // Mysql username
  7. $password="SWTKJqb0pgc1"; // Mysql password
  8. $db_name="emma01_sitetoss"; // Database name
  9. $tbl_name="domains1"; // Table name
  10.  
  11. // Connect to server and select database.
  12. mysql_connect("$host", "$username", "$password")or die("cannot connect");
  13. mysql_select_db("$db_name")or die("cannot select DB");
  14.  
  15. // get value of id that sent from address bar
  16. $id=$_GET['id'];
  17.  
  18. // Delete data in mysql from row that has this id
  19. $sql="DELETE FROM $tbl_name WHERE id='$id'";
  20. $result=mysql_query($sql);
  21.  
  22. // if successfully deleted
  23. if($result){
  24. echo "Deleted Successfully";
  25. echo "<BR>";
  26. echo "<a href='abdu_delete.php'>Back to main page</a>";
  27. }
  28.  
  29. else {
  30. echo "ERROR";
  31. }
  32. ?>
  33.  
  34. <?php
  35. // close connection
  36. mysql_close();
  37. ?>
Advertisement
Add Comment
Please, Sign In to add comment