这样看可能更直观点.index.php
<?
//------[ 基本设定 ]-------
$mysql_server_name = "localhost";
$mysql_username = "lj";
$mysql_password = "lj";
$mysql_database = "saturn";
$ip = getenv('remote_addr');
//-------
//准备好您的SQL语法(新增)
$sql = "INSERT INTO `gbook` ( `id` , `name` , `` , `email` , `info` , `ip` , `time_at` ) VALUES ('', '$name', '$', '$email', '$info', '127.0.0.1', NOW( ) );";
$conn=mysql_connect( $mysql_server_name, $mysql_username, $mysql_password);
mysql_select_db($mysql_database,$conn);
$result = mysql_query($sql);
$id = mysql_insert_id();
mysql_close($conn);
?>
<style type="text/css">
<!--
*{
font-family: "宋体";
font-size: 12px;
}
-->
</style>
<?
//准备好您的SQL语法(查询)
$sql = "SELECT id, name, , email, info, ip,DATE_FORMAT(time_at,'%Y年 %m月 %d日 %T') FROM `gbook` ORDER BY `id` DESC";
$conn=mysql_connect( $mysql_server_name, $mysql_username, $mysql_password );
$result=mysql_db_query( $mysql_database, $sql,$conn );
$row=mysql_fetch_row($result)
?>
<style type="text/css">
<!--
*{
font-family: "宋体";
font-size: 12px;
}
-->
</style>
<p align="center"><strong>留言显示</strong></p>
<table width="80%" border="1" align="center" cellPadding="6" cellSpacing="0">
<tbody>
<tr>
<td bgColor="#ccffff">
<font color="#FF0000">(<?=$row[0]?>) <?=$row[6]?></font>
<font color="#008000"><b>(<?=$row[5]?>)</b></font>
<br>
<font color="#FF6600"><b><?=$row[1]?></b></font>
<font color="blue"> <?php
if($row[2]==1)
{
echo "男";
}
else
{
echo "女";
}
?> < <a href="<?=$row[3]?>"><?=$row[3]?></a>> 写道:?</font></td>
</tr>
<tr>
<td bgColor="#ffffdf"><font color="#000000"><?=nl2br($row[4])?></font>
<p>[<a href="del.php?id=<?=$row[0]?>">删除</a>] [<a href="modify.php?id=<?=$row[0]?>">回复</a>]</p></td>
</tr>
</tbody>
</table>
<?
//------[ 基本设定 ]-------
$mysql_server_name = "localhost";
$mysql_username = "lj";
$mysql_password = "lj";
$mysql_database = "saturn";
//-------
//准备好您的SQL语法(查询)
$sql = "SELECT id, name, , email, info, ip,DATE_FORMAT(time_at,'%Y年 %m月 %d日 %T') FROM `gbook1` ORDER BY `id` DESC";
$conn=mysql_connect( $mysql_server_name, $mysql_username, $mysql_password );
$result=mysql_db_query( $mysql_database, $sql,$conn );
while($row=mysql_fetch_row($result))
{
//print_r($row);
if($row[2]==1)
{
$gender = '男';
}
else
{
$gender = '女';
}
?>
<style type="text/css">
<!--
*{
font-family: "宋体";
font-size: 12px;
}
-->
</style>
<table width="80%" border="1" align="center" cellPadding="6" cellSpacing="0">
<tbody>
<tr>
<td bgColor="#ccffff">
<font color="#FF0000">(<?=$row[0]?>) <?=$row[6]?></font>
<font color="#008000"><b>(<?=$row[5]?>)</b></font>
<br>
<font color="#FF6600"><b><?=$row[1]?></b></font>
<font color="blue"> <?=$gender?> < <a href="<?=$row[3]?>"><?=$row[3]?></a>> 写道:?</font></td>
</tr>
<tr>
<td bgColor="#ffffdf"><font color="#000000"><?=nl2br($row[4])?></font><p>[<a href="del.php?id=<?=$row[0]?>">删除</a>] [<a href="modify.php?id=<?=$row[0]?>">回复</a>]</p></td>
</tr>
</tbody>
</table>
<br>
<?
}
mysql_free_result($result);
?>
<p>[<a href="input.htm">留言</a>] [<a href="show.php">查看更多</a>] </p>
[ 本帖最后由 hwztime 于 2007-5-9 21:13 编辑 ]