Skip to main content

[Template] PHP显示MySQL数据



只需要修改数据库的信息。
  1. <html>
  2. <head>
  3. <title>View Database</title>
  4. <body>

  6. <?php
  7. //connect database
  8. $db_host = 'localhost';
  9. $db_user = 'username';
  10. $db_pwd = 'password';
  11. $database = 'database';
  12. $table = 'table';

  14. if (!mysql_connect($db_host, $db_user, $db_pwd))
  15. die("Can't connect to database");
  16. if (!mysql_select_db($database))
  17. die("Can't select database");
  18. // sending query
  19. $result = mysql_query("SELECT * FROM {$table}");
  20. if (!$result)
  21. {
  22. die("Query to show fields from table failed");
  23. }
  24. $fields_num = mysql_num_fields($result);
  25. echo "<h1>Table: {$table}</h1>";
  26. echo "<table border='1'><tr>";
  27. // printing table headers
  28. for($i=0; $i<$fields_num; $i++)
  29. {
  30. $field = mysql_fetch_field($result);
  31. echo "<td>{$field->name}</td>";
  32. }
  33. echo "</tr>\n";// printing table rows
  34. while($row = mysql_fetch_row($result))
  35. {
  36. echo "<tr>";
  37. // $row is array... foreach( .. ) puts every element
  38. // of $row to $cell variable
  39. foreach($row as $cell)
  40. echo "<td>$cell</td>";
  41. echo "</tr>\n";
  42. }
  43. mysql_free_result($result);
  44. echo"<p><a href=test.php>Back Home</a></p>";
  45. ?>
  46. </body>
  47. </html>
Labels:

Comments

Post a Comment