php和 mysql 应用相关

php中文网

发布时间：2016-06-06 09:43:36

1156人浏览过

来源于php中文网

原创

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.

立即学习“PHP免费学习笔记（深入）”；

// 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><div class="aritcle_card flexRow">
                                                        <div class="artcardd flexRow">
                                                                <a class="aritcle_card_img" href="/xiazai/js/7914" title="jquery多功能响应式相册插件Strip"><img
                                                                                src="https://img.php.cn/upload/jscode/000/000/011/170669031860273.jpg" alt="jquery多功能响应式相册插件Strip"  onerror="this.onerror='';this.src='/static/lhimages/moren/morentu.png'" ></a>
                                                                <div class="aritcle_card_info flexColumn">
                                                                        <a href="/xiazai/js/7914" title="jquery多功能响应式相册插件Strip">jquery多功能响应式相册插件Strip</a>
                                                                        <p>jquery多功能响应式相册插件Strip，支持标签属性调用，支持JS事件调用，支持多种扩展方法，能展示单张图片和多图相册，自适应，适用于移动设备。</p>
                                                                </div>
                                                                <a href="/xiazai/js/7914" title="jquery多功能响应式相册插件Strip" class="aritcle_card_btn flexRow flexcenter"><b></b><span>下载</span> </a>
                                                        </div>
                                                </div>';

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