Advertisement
Guest User

Untitled

a guest
Dec 6th, 2018
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.20 KB | None | 0 0
  1. <html>
  2. <body>
  3. <?php
  4. $dbhost = 'localhost:3036';
  5. $dbuser = 'andrewwthompson';
  6. $dbpass = 'GtqoM3ke41';
  7. // Create connection
  8. $conn = mysql_connect($dbhost, $dbuser, $dbpass);
  9. if(! $conn ) {
  10. die('Connection failed: ' . mysql_error());
  11. }
  12. // Create database
  13. $sql = 'SELECT * FROM Animal';
  14. mysql_select_db('andrewwthompson');
  15. $retval = mysql_query( $sql, $conn );
  16.  
  17. if(! $retval ) {
  18. die('Could not get data: ' . mysql_error());
  19. }
  20. while($row = mysql_fetch_array($retval, MYSQL_ASSOC)) {
  21. echo "ID :{$row['id']} <br> ".
  22. "Animal ID : {$row['Animal_ID']} <br> ".
  23. "Animal Type : {$row['Anmal_Type']} <br> ".
  24. "Breed : {$row['Breed']} <br> ".
  25. "Name : {$row['Animal_Name']} <br> ".
  26. "Date of Birth : {$row['DOB']} <br> ".
  27. "Age : {$row['Age']} <br> ".
  28. "Date Recieved : {$row['Date_Recieved']} <br> ".
  29. "Cost : {$row['Cost']} <br> ".
  30. "Story : {$row['Story']} <br> ".
  31. "Gender : {$row['Gender']} <br> ".
  32. "Medical ID : {$row['Medical_ID']} <br> ".
  33. "--------------------------------<br>";
  34. }
  35. echo "Fetched data successfully\n";
  36.  
  37. mysql_close($conn);
  38. ?>
  39. </body>
  40. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement