麻烦版主帮我看下,谢谢.

hwztime

UID: 12739
帖子: 29
积分: 57
在线时间: 11小时
注册时间: 2007-02-24
最后登录: 2008-01-05

1^# hwztime 发表于2007-05-09

麻烦版主帮我看下,谢谢.

我弄了个php论坛代码,但是回复显示好像不太正常.麻烦版主帮我看下.谢谢了.

附件

5_1_5.rar (6.43 KB): 2007-5-9 21:10, 下载次数: 1

hwztime

UID: 12739
帖子: 29
积分: 57
在线时间: 11小时
注册时间: 2007-02-24
最后登录: 2008-01-05

2^# hwztime 发表于2007-05-09

这样看可能更直观点.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">

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

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

</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 编辑 ]

hwztime

UID: 12739
帖子: 29
积分: 57
在线时间: 11小时
注册时间: 2007-02-24
最后登录: 2008-01-05

3^# hwztime 发表于2007-05-09

modify.php

<?
      echo $id;

  //------[ 基本设定 ]-------
$mysql_server_name = "localhost";
$mysql_username = "lj";
$mysql_password = "lj";
$mysql_database = "saturn";
//-------

//写入您的SQL语言(选择)
$sql = "SELECT name, , email, info FROM `gbook` WHERE id = '$id'";

$conn=mysql_connect( $mysql_server_name, $mysql_username, $mysql_password );
$result=mysql_db_query( $mysql_database, $sql,$conn );
      $row=mysql_fetch_row($result);

      print_r($row);
?>

<html>

<head>
<meta http-equiv="Content-Language" content="gb2312">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>修改(modify)</title>
<style type="text/css">

</style>
</head>

<body>

<form method="POST" action="modify_ok.php?id=<?=$id?>">
  <p>您的姓名:<input type="text" name="name" size="20" value="<?=$row[0]?>"></p>
<?
      if($row[1]==1)
      {
            echo '<p>您的性别:<input type="radio" value="1" name="" checked>男生  <input type="radio" value="0" name="">女生</p>';
      }
      else
      {
            echo '<p>您的性别:<input type="radio" value="1" name="" >男生 <input type="radio" value="0" name="" checked>女生</p>';

      }


?>
  <p>您的Email:<input type="text" name="email" size="20" value="<?=$row[2]?>"></p>
  <p>您的留言:</p>
  <p><textarea rows="9" name="info" cols="35">回复"<?=$row[0]?>"</textarea></p>
  <p><input type="submit" value="提交" name="B1"><input type="reset" value="重新设定" name="B2"></p>
</form>

</body>

</html>

hwztime

UID: 12739
帖子: 29
积分: 57
在线时间: 11小时
注册时间: 2007-02-24
最后登录: 2008-01-05

4^# hwztime 发表于2007-05-09

modify_ok.php

<?

   echo $name.'<p>';

   echo $.'<p>';

   echo $email.'<p>';

   echo $info.'<p>';


//------[ 基本设定 ]-------
$mysql_server_name = "localhost";
$mysql_username = "lj";
$mysql_password = "lj";
$mysql_database = "saturn";
$ip = getenv('remote_addr');
//-------

//准备好您的SQL语法(新增)
$sql = "INSERT INTO `gbook1` ( `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">

</style>
<p>[<a href="input.htm">回输入板</a>] [<a href="show.php">进入更改删除</a>]</p>