Advertisement
Guest User

Untitled

a guest
Oct 1st, 2018
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.05 KB | None | 0 0
  1. <?php
  2.  
  3. $host = '127.0.0.1';
  4. $port = '3306';
  5. $server = $host . ':' . $port;
  6. $user = 'root';
  7. $password = '';
  8.  
  9. $link = mysql_connect ($server, $user, $password);
  10. if (!$link)
  11. {
  12. die('Error: Could not connect: ' . mysql_error());
  13. }
  14.  
  15. $database = 'employees';
  16.  
  17. mysql_select_db($database);
  18.  
  19. $query = 'select * from Employees';
  20.  
  21. $result = mysql_query($query);
  22.  
  23. if (!$result)
  24. {
  25. $message = 'ERROR:' . mysql_error();
  26. return $message;
  27. }
  28. else
  29. {
  30. $i = 0;
  31. echo '<html><head><meta charset="UTF-8"></head><body><table><tr>';
  32. while ($i < mysql_num_fields($result))
  33. {
  34. $meta = mysql_fetch_field($result, $i);
  35. echo '<td>' . $meta->name . '</td>';
  36. $i = $i + 1;
  37. }
  38. echo '</tr>';
  39.  
  40. $i = 0;
  41. while ($row = mysql_fetch_row($result))
  42. {
  43. echo '<tr>';
  44. $count = count($row);
  45. $y = 0;
  46. while ($y < $count)
  47. {
  48. $c_row = current($row);
  49. echo '<td>' . $c_row . '</td>';
  50. next($row);
  51. $y = $y + 1;
  52. }
  53. echo '</tr>';
  54. $i = $i + 1;
  55. }
  56. echo '</table></body></html>';
  57. mysql_free_result($result);
  58. }
  59.  
  60. mysql_close ($link);
  61. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement