BBS(php & mysql)完整版(一)

  //此页面为say.php

  <?

  include "signup/mysql.inc";

  if($id1){

  $sql="select * from $table where id='$id1'";    //显示回复题目

  $result=mysql_query($sql)or die(mysql_error());

  $row=mysql_fetch_array($result);

  $title="RE:".$row["title"];

  }

  $ip=$REMOTE_ADDR;

  $sql="select * from user_stus where ip='$ip'";    //查询当前用户名

  $result=mysql_query($sql)or die(mysql_error());

  $row=mysql_fetch_array($result);

  if(!$row)                                         //判断用户是否登陆

  {

  echo "<html><div id=Layer2  align=center z-index:1><BR><BR><BR><BR>";

  echo" <div id=Layer3  align=center z-index:2><img src=pic/3.gif width=15 height=15></div>";

  echo"  <div align=center>";

  echo" <p><font size=2 color=#FF33CC>嘻嘻!! 请先登陆</font></p>";

  echo"<p><font size=2 color=#FF33CC><a href='".$PHP_SELF."?p=1&&table=$table'>返回</a></font></p> </div> </html>";

  exit();

  }

  else $userid=$row["userid"];

  if($ok)

  {

  if($title==""||$content=="")

  {

  echo "<BR>      请您添完整后提交";

  }

  else{

  $id=time();                                 //提交文章

  $date1=date("Y/m/d");

  $title=htmlspecialchars($title);

  $content=htmlspecialchars($content);

  $sql="select * from ".$table;

  $result=mysql_query($sql)or die(mysql_error());

  $row1=mysql_num_rows($result);

  $row1++;

  if($id1){

  $sql="insert into bbs_re (id,userid,date1,title,content)values('$id','$userid','$date1','$title','$content')";

  mysql_query($sql)or die(mysql_error());

  $sql="select * from ".$table." where id='$id1'";

  $result=mysql_query($sql)or die(mysql_error());

  $lin=mysql_fetch_array($result);

  for($i=1;$i<6;$i++)

  {

  $re="r".$i;

  if(!$lin["$re"])

  break;

  }

  $sql="update ".$table." set ".$re."='$id' where id='$id1'";

  }

  else

  $sql="insert into ".$table." (id,userid,date1,title,content,row)values('$id','$userid','$date1','$title','$content','$row1')";

  $result=mysql_query($sql)or die(mysql_error());

  if($result)

  {

  header("Location:php3.php?p=1&&table=$table");

  exit ;

  }

  }

  }

  ?>

  <html>

  <head>

  <title>xiaoyang</title>

  <meta http-equiv="Content-Type" content="text/html; charset=gb2312">

  <script language="JavaScript1.2" src="js/menu_comment.js"></script>

  <script language="JavaScript1.2" src="js/fw_menu.js"></script>

  <script language="JavaScript">

  <!--

  function MM_reloadPage(init) {  //reloads the window if Nav4 resized

  if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {

  document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}

  else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();

  }

  MM_reloadPage(true);

  // -->

  </script>

  </head>

  <body bgcolor="#FFFFFF" text="#000000">

  <div id="Layer1" style="position:absolute; left:31px; top:1px; width:560px; height:46px; z-index:10">

  <script language="JavaScript1.2">fwLoadMenus();</script></div>

  <div id="Layer6" style="position:absolute; left:409px; top:29px; width:118px; height:17px; z-index:6"></div>

  <div id="Layer5" style="position:absolute; left:86px; top:63px; width:464px; height:303px; z-index:7">

  <form name="form1" method="post" action="<? echo $PHP_SELF ?>">

  <table width="98%" border="1" cellspacing="0" cellpadding="0" bordercolor="#FF99FF">

  <tr>

  <td width="26%" height="42">

  <div align="center"><font size="2" color="#FF33FF">题目</font></div>

  </td>

  <td width="74%" height="42">

  <input type="text" name="title" size="40" value="<?echo $title ;?>" onMouseover="this.document.form1.title.focus();return true">

  <input type="hidden" name="table" value="<?echo $table ;?>">

  <input type="hidden" name="id1" value="<? echo $id1 ;?>">

  <br>

  </td>

  </tr>

  <tr>

  <td width="26%" height="172">

  <div align="center"><font size="2" color="#FF33FF">内容</font></div>

  </td>

  <td width="74%" height="172">

  <textarea name="content" cols="40" rows="10" wrap="physical" value="<?echo $content ;?>" onMouseOver="this.document.form1.content.focus()"></textarea>

  </td>

  </tr>

  <tr>

  <td width="26%">

  <div align="center">

  <input type="reset" name="Submit2" value="重写">

  </div>

  </td>

  <td width="74%">

  <div align="center">

  <input type="submit" name="ok" value="发表">

  </div>

  </td>

  </tr>

  </table>

  <p> </p>

  </form>

  </div>

  <div id="back" style="position:absolute; left:455px; top:30px; width:85px; height:3px; z-index:8">

  <hr color="#ff9999" noshade>

  </div>

  <div id="goback" style="position:absolute; left:461px; top:23px; width:120px; height:16px; z-index:9">

  <div align="center"><a href="php3.php?p=1&&table=<?echo $table ;?>" target="_self" onMouseover="window.status='' ;return true"><font size="2" color="#FF33FF">返回</font></a></div>

  </div>

  <p> </p>

  <p> </p>

  </body>

  </html>