php和 mysql 应用相关

WBOY
Lepaskan: 2016-06-06 09:43:36
asal
952 orang telah melayarinya

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.

<code>// 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.  </code>
Salin selepas log masuk

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

<code>// 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>';</code>
Salin selepas log masuk

} // 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






Your Website


catchy slogan...





  • Home Page

  • Register

  • View Users

  • Change Password

  • link five




Registered Users


上面的HTML 就是运行文件结果,php里关于数据库相关代码全被略掉了;
Label berkaitan:
sumber:php.cn
Kenyataan Laman Web ini
Kandungan artikel ini disumbangkan secara sukarela oleh netizen, dan hak cipta adalah milik pengarang asal. Laman web ini tidak memikul tanggungjawab undang-undang yang sepadan. Jika anda menemui sebarang kandungan yang disyaki plagiarisme atau pelanggaran, sila hubungi admin@php.cn
Tutorial Popular
Lagi>
Muat turun terkini
Lagi>
kesan web
Kod sumber laman web
Bahan laman web
Templat hujung hadapan