Guest User

Untitled

a guest
Aug 31st, 2018
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.47 KB | None | 0 0
  1. Is this this mysql/php correct to delete a row?
  2. <?php
  3. $id = $_POST['dr'];
  4. $dbhost = 'star***.***.edu';
  5. $dbuser = '***4123';
  6. $dbpass = '*****';
  7. $conn = mysql_connect($dbhost, $dbuser, $dbpass);
  8. if(! $conn )
  9. {
  10. die('Could not connect: ' . mysql_error());
  11. }
  12. $sql = "DELETE FROM address
  13. WHERE idnum="".$id"";
  14.  
  15. mysql_select_db('***4123');
  16. $retval = mysql_query( $sql, $conn );
  17. if(! $retval )
  18. {
  19. die('Could not delete data: ' . mysql_error());
  20. }
  21. echo "Deleted data successfullyn";
  22. mysql_close($conn);
  23. ?>
  24.  
  25. $sql = "DELETE FROM address WHERE idnum = " . $id;
  26.  
  27. $id = (int) $_POST [ 'dr' ];
  28.  
  29. <?php
  30. try {
  31. $db = new PDO ('mysql:host=star***.***.edu;dbname=***4123', '***4123', '*****');
  32. }
  33.  
  34. catch (Exception $e)
  35. {
  36. die('Could not connect: ' . $e->getMessage());
  37. }
  38.  
  39. $statement = $db->prepare('DELETE FROM address WHERE idnum=?');
  40.  
  41. $statement->bindParam(1, $_POST['dr']);
  42.  
  43. if (false === $statement->execute())
  44. {
  45. die('Could not delete data: ' . print_r($pdo->errorInfo(),true));
  46. }
  47.  
  48. <?php
  49. $id = mysql_real_escape_string($_POST['dr']);
  50. $dbhost = 'star***.***.edu';
  51. $dbuser = '***4123';
  52. $dbpass = '*****';
  53. $conn = mysql_connect($dbhost, $dbuser, $dbpass);
  54. if(! $conn )
  55. {
  56. die('Could not connect: ' . mysql_error());
  57. }
  58. $sql = "DELETE FROM address
  59. WHERE idnum= '$id' ";
  60.  
  61. mysql_select_db('***4123');
  62. $retval = mysql_query( $sql, $conn );
  63. if(! $retval )
  64. {
  65. die('Could not delete data: ' . mysql_error());
  66. }
  67. echo "Deleted data successfullyn";
  68. mysql_close($conn);
  69. ?>
Add Comment
Please, Sign In to add comment