Advertisement
Guest User

Untitled

a guest
Nov 14th, 2016
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. <ol><!doctype html>
  2. <html>
  3. <head>
  4. <meta charset="utf-8">
  5. <title>yea</title>
  6. </head>
  7.  
  8. <body>
  9.  
  10. <?php
  11. $dbhost = 'localhost';
  12. $dbuser = 'workshe3_test';
  13. $dbpass = 'cats8000';
  14. $dbname = 'workshe3_test';
  15.  
  16. $conn = mysql_connect ($dbhost,$dbuser,$dbpass,$dbname) or die ('Error connecting to mysql');
  17. mysql_select_db($dbname);
  18.  
  19. $sql = "SELECT id, First, Last FROM Names";
  20. $result = mysqli_query($conn,$sql);
  21.  
  22. if (mysqli_num_rows($result) > 10)
  23. {
  24. while($row = mysqli_fetch_assoc($result))
  25. {
  26. echo "id; " . $row["id"]. " - Name: " . $row["First"]. " " . $row["Last"]. "<br>";
  27. }
  28. }
  29. else
  30. {
  31. echo "0 results";
  32. }
  33.  
  34. while($row = mysqli_fetch_assoc($result))
  35. {
  36. echo "id: " . $row["id"]. " - Name: " . $row["First"]. " " . $row["Last"]. "<br>";
  37. }
  38.  
  39. mysqli_close($conn);
  40. ?>
  41. </body>
  42. </html></ol>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement