<?php # Script 9.4 - view_users.php
// This script retrieves all the records from the users table.
$page_title = 'View the Current Users';
include ('includes/header.html');
// Page header:
echo '
Registered Users
';require ('./mysqli_connect.php'); // Connect to the db.
// Make the query:
$q = "SELECT CONCAT(last_name, ', ', first_name) AS name, DATE_FORMAT(registration_data, '%M %d, %Y') AS dr FROM users ORDER BY registration_data ASC";
$r = @mysqli_query ($dbc, $q); // Run the query.
if ($r) { // If it ran OK, display the records.
// Table header.
echo '<table align="center" cellspacing="3" cellpadding="3" width="75%">
<tr><td align="left"><b>Name</b></td><td align="left"><b>Date Registered</b></td></tr>';
// Fetch and print all the records:
while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC)) {
echo '<tr><td align="left">' . $row['name'] . '</td><td align="left">' . $row['dr'] . '</td></tr>';
}
echo '</table>'; // Close the table.
mysqli_free_result ($r); // Free up the resources.
} else { // If it did not run OK.
// Public message:
echo '<p class="error">The current users could not be retrieved. We apologize for any inconvenience.</p>';
// Debugging message:
echo '<p>' . mysqli_error($dbc) . '<br /><br />Query: ' . $q . '</p>';
} // End of if ($r) IF.
mysqli_close($dbc); // Close the database connection.
include ('includes/footer.html');
?>
larry Ullman(php 和MySQL)的书上的,调了2小时,都没搞明白,连接不上数据库啊,万能的CSDN 救救我吧;
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
View the Current Users
Your Website
catchy slogan...
<!-- Script 9.1 - header.html -->
Registered Users
上面的HTML 就是运行文件结果,php里关于数据库相关代码全被略掉了;