[Template] PHP显示MySQL数据

只需要修改数据库的信息。
<html>
<head>
<title>View Database</title>
<body>

<?php 
//connect database
$db_host = 'localhost';
$db_user = 'username';
$db_pwd = 'password';
$database = 'database';
$table = 'table';

if (!mysql_connect($db_host, $db_user, $db_pwd))
        die("Can't connect to database");
if (!mysql_select_db($database))   
        die("Can't select database");   
// sending query
$result = mysql_query("SELECT * FROM {$table}");
if (!$result) 
{
        die("Query to show fields from table failed");
}
$fields_num = mysql_num_fields($result);
echo "<h1>Table: {$table}</h1>";
echo "<table border='1'><tr>";
// printing table headers
for($i=0; $i<$fields_num; $i++)
{
        $field = mysql_fetch_field($result);
        echo "<td>{$field->name}</td>";
}
echo "</tr>\n";// printing table rows
while($row = mysql_fetch_row($result))
{
        echo "<tr>";
        // $row is array... foreach( .. ) puts every element
        // of $row to $cell variable
        foreach($row as $cell)    
                echo "<td>$cell</td>";
        echo "</tr>\n";
}
mysql_free_result($result);
echo"<p><a href=test.php>Back Home</a></p>";
?>
</body>
</html>

LU WEI's BLOG

Search This Blog

[Template] PHP显示MySQL数据

Labels

Comments

Popular posts from this blog

关于构建快速的WEB站点的建议

在 Ubuntu 中配置 J2ME 开发环境

苹果电脑读写NTFS格式的移动硬盘