php和 mysql 应用相关

<?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...




<!-- Start of the page-specific content. -->
<!-- Script 9.1 - header.html -->

Registered Users


上面的HTML 就是运行文件结果，php里关于数据库相关代码全被略掉了；

你这是纯PHP啊，./mysqli_connect.php'这里的内容是啥？
贴出来看对不对

参考一下这个：

 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>用户注册</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
</head>

<body>
<?php
$cnn = mysql_pconnect("localhost","root","");
$sdb = mysql_select_db("数据库名称",$cnn);
if(!$sdb){
    exit("Error:连接数据库失败!");
    }
    $query = "select * from admin Order By ID Asc";
    $rst = mysql_query($query);
    $rows = mysql_num_rows($rst);
    $id = 0;
    for ($i=0; $i<$rows; $i++){
        mysql_data_seek($rst,$i);
        $data = mysql_fetch_array($rst);
        if ($data['ID'] > $id){
            $id = $data['ID'];
        }
echo $data['ID']."||".$data['uid']."||".$data['pwd']."||".$data['tim']."<br>";
    }
    $id += 1;
    $query = "insert into admin (ID,uid,pwd,tim) values(".$id.",'".$uid."','".$pwd."',".date('H').date('i').date('s').")";
    mysql_query($query);
mysql_close($cnn);
echo $id."--恭喜您，注册成功！";
//echo "<script language=javascript>window.location.href='default.htm';</script>";
?>

</body>
</html>

<?php # Script 9.2 - mysqli_connect.php

DEFINE ('DB_USER','username');
DEFINE ('DB_PASSWORD','password');
DEFINE ('DB_HOST','localhost');
DEFINE ('DB_NAME','sitename');

$dbc = @mysqli_connect(DB_HOST,DB_USER,DB_PASSWORD,DB_NAME)OR die('Could not connect to
MySQL: '.mysqli_connect_error());

mysqli_set_charset($dbc,'utf8');

以上为我的connect 代码