Guest User

Untitled

a guest
Jul 28th, 2018
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.86 KB | None | 0 0
  1. PHP not displaying MYSQL result
  2. $dbhost = 'localhost';
  3. $dbuser = 'root';
  4. $dbpass = 'root';
  5.  
  6. $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
  7.  
  8. $dbname = 'test';
  9.  
  10. mysql_select_db($dbname);
  11.  
  12. mysql_select_db("test", $conn);
  13.  
  14. $result = mysql_query("SELECT * FROM new_table");
  15.  
  16. while($row = mysql_fetch_array($result))
  17. {
  18. echo $row['test1'] . " " . $row['test2'] . " " . $row['test3'];
  19. echo "<br />";
  20. }
  21.  
  22. mysql_close($con);
  23.  
  24. $result = mysql_query("SELECT * FROM new_table");
  25.  
  26. $result = mysql_query("SELECT * FROM new_table") or die(mysql_error());
  27.  
  28. mysql_close($con);
  29.  
  30. mysql_close($conn);
  31.  
  32. ini_set('display_errors','On');
  33. ini_set('error_reporting',E_ALL);
  34.  
  35. mysql_select_db("test", $conn) or die(mysql_error());
  36. mysql_select_db($dbname) or die(mysql_error());
  37. $result = mysql_query("SELECT * FROM new_table") or die(mysql_error());
  38.  
  39. <?php
  40. $result = mysql_query("SELECT * FROM new_table");
  41. if(!$result)
  42. die('SQL query failed: ' . mysql_error());
  43.  
  44. $result = mysql_query("SELECT * FROM new_table") or die("error:".mysql_error());
  45.  
  46. try
  47. {
  48.  
  49. $db = new mysqli("localhost","root","root","test");
  50.  
  51. if ($db->connect_errno) {
  52. throw new Exception($db->connect_error);
  53. }
  54.  
  55. if ($result = $db->query("SELECT * FROM new_table")) {
  56. printf("Select returned %d rows.n", $result->num_rows);
  57.  
  58.  
  59. while($row = $result->fetchAssoc())
  60. {
  61. echo $row['test1'] . " " . $row['test2'] . " " . $row['test3'];
  62. echo "<br />";
  63. }
  64.  
  65.  
  66. /* free result set */
  67. $result->close();
  68. }
  69.  
  70.  
  71. $db->close();
  72. }
  73. catch(Exception $e)
  74. {
  75. printf("Database Error: %sn", $e->getMessage());
  76. exit();
  77.  
  78. }
Add Comment
Please, Sign In to add comment