Guest User

Untitled

a guest
Aug 10th, 2018
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.31 KB | None | 0 0
  1. mysql php error - quote system
  2. <?php
  3.  
  4. $DB_SERVER = "localhost";
  5. $DB_USER = "root";
  6. $DB_PASS = "";
  7. $DB_NAME = "test";
  8. $con = mysql_connect($DB_SERVER, $DB_USER, $DB_PASS);
  9. mysql_select_db($DB_NAME);
  10.  
  11. $sql = mysql_query("SELECT * FROM quotes WHERE id = ".$_GET['id'], $con);
  12. $row = mysql_fetch_row($sql);
  13.  
  14. $sql = mysql_query("SELECT * FROM author where aid = " . $row[1], $con);
  15. $row = mysql_fetch_row($sql);
  16.  
  17.  
  18. var_dump($row);
  19.  
  20. Array
  21. (
  22. [0] => id
  23. [1] => quote
  24. [2] => aid
  25. )
  26.  
  27. $sql = mysql_query("SELECT * FROM author where aid = " . $row[1], $con);
  28.  
  29. <?php
  30. $_GET['id'] = 1;
  31. $DB_SERVER = "localhost";
  32. $DB_USER = "root";
  33. $DB_PASS = "";
  34. $DB_NAME = "test";
  35. $con = mysql_connect($DB_SERVER, $DB_USER, $DB_PASS);
  36. mysql_select_db($DB_NAME);
  37. $sql = mysql_query("SELECT * FROM quotes WHERE id = " . (int)$_GET['id'], $con); // or you can use the mysql_real_escape_string
  38. if(!$sql) {
  39. echo mysql_error($con);
  40. }
  41. $row = mysql_fetch_assoc($sql);
  42. mysql_free_result($sql);
  43.  
  44. $sql = mysql_query("SELECT * FROM author where id = " . (int)$row['aid'], $con);
  45. if(!$sql) {
  46. echo mysql_error($con);
  47. }
  48. $row = mysql_fetch_assoc($sql);
  49. mysql_free_result($sql);
  50.  
  51. print_r($row);
  52. mysql_close($con);
  53.  
  54. $sql = mysql_query("SELECT * FROM author where aid = " . $row[1], $con);
  55. if ( $sql ) {
  56. $row = mysql_fetch_row($sql);
  57. }
  58. else {
  59. //error
  60. }
Add Comment
Please, Sign In to add comment