PHP学习（13）留言板(二)

conn.php

<?php

$conn = @ mysql_connect("localhost", "root", "") or die("数据库链接错误");

mysql_select_db("liuyanban", $conn);

mysql_query("set names 'GBK'"); //使用GBK中文编码;

?>



list.php

<?php

include("conn.php");

?>

<table width=500 border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#add3ef">
<?php

$sql="select * from `message`";

$query=mysql_query($sql);

while($row=mysql_fetch_array($query))
{
echo "<tr bgcolor='#eff3ff'>";
echo "<td>标题：".$row[title]." 用户：".$row[user]."</td>";
echo "</tr>";
echo "<tr bgColor='#ffffff'>";
echo "<td>内容：".$row[content]."</td>";
echo "</tr>";
}
?>

</table>