php和mysql应用相关

来源：动视网责编：小采时间：2020-11-09 16:34:35

php和mysql应用相关

php和mysql应用相关:mysqlphp // 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./

推荐度：

点击下载本文 文档为doc格式

导读php和mysql应用相关:mysqlphp // 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./

mysqlphp

// 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 '';// Fetch and print all the records:while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC)) { echo '';}echo 'Name Date Registered
' . $row['name'] . ' ' . $row['dr'] . '
'; // Close the table.mysqli_free_result ($r); // Free up the resources.

} else { // If it did not run OK.

// Public message:echo 'The current users could not be retrieved. We apologize for any inconvenience.
';// Debugging message:echo '' . mysqli_error($dbc) . '
Query: ' . $q . '
';

} // End of if ($r) IF.

mysqli_close($dbc); // Close the database connection.

include ('includes/footer.html');
?>

larry Ullman（php 和MySQL）的书上的，调了2小时，都没搞明白，连接不上数据库啊，万能的CSDN 救救我吧；

View the Current Users