社区(php&&mysql)五

  function post2() {

  global $sid,$aid,$PHP_SELF;

  global $banner,$body,$poster,$email,$type,$CHAR_GB;

  if(strlen($banner)==0 || strlen($body)==0 || strlen($poster)==0 || strlen($email)==0) {

  echo "

  <script language=javascript>

  alert('恶糶ぃЧ俱');

  history.back();

  </script>

  ";

  return;

  }

  //$banner=AddSlashes($banner);

  //$body=AddSlashes($body);

  $rip=getenv('REMOTE_ADDR');

  $DROOT=getenv('DOCUMENT_ROOT');

  include("sql.php3");

  $db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);

  $now=date('Y')."-".date('m')."-".date('d')." ".date('H').":".date('i').":".date('s');

  if($CHAR_GB==1) {

  include("CCharset.php3");

  $code=new CCharset;

  $banner=$code->Gb_Big5($banner);

  $body=$code->Gb_Big5($body);

  $poster=$code->Gb_Big5($poster);

  }

  if($type==1) {

  $qsql="INSERT INTO bbs_docs (aid,sid,banner,body,poster,email,pip,wdate)

  values('$aid','$sid','$banner','$body','$poster','$email','$rip','$now')";

  } else {

  $qsql="INSERT INTO bbs_subj (aid,banner,body,poster,email,pip,wdate)

  values('$aid','$banner','$body','$poster','$email','$rip','$now')";

  }

  $rs=mysql_db_query($sql['db'],$qsql);

  $id=mysql_insert_id();

  if($type==0) { //笆mail_list

  $qsql="INSERT INTO  bbs_sml (sid,email) values('$id','$email')";

  $rs=mysql_db_query($sql['db'],$qsql);

  }

  if($type==0)  Send_the_doc_to_mail_list($aid,$id,$id);

  else           Send_the_doc_to_mail_list($aid,$sid,$id);

  //incdocs($aid);

  if($type==0) { $sid=$rid=$id;}

  else         { $rid=$id;}

  echo "

  <script language=javascript>

  document.location='$PHP_SELF?proc=view&aid=$aid&sid=$sid&rid=$rid'

  </script>

  ";

  }

  //======================================================================

  function search_docs($aid,$skey) {

  $DROOT=getenv('DOCUMENT_ROOT');

  include("sql.php3");

  $db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);

  //$qsql="SELECT * from bbs_docs where sid='$id' and (banner like '$skey' or poster like '$skey' or body like '$skey') order by wdate DESC";

  if($aid) $qsql="SELECT * from bbs_docs where aid='$aid' and (banner like '$skey' or poster like '$skey' or body like '$skey') order by wdate DESC";

  else $qsql="SELECT * from bbs_docs where  (banner like '$skey' or poster like '$skey' or body like '$skey') order by wdate DESC";

  $rs=mysql_db_query($sql['db'],$qsql);

  while($row=mysql_fetch_array($rs)) {

  $id=$row['id'];

  $banner=$row['banner'];

  $poster=$row['poster'];

  $views=$row['views'];

  $wdate=sdatetime($row['wdate']);

  $aid=$row['aid'];

  $sid=$row['sid'];

  echo "<tr bgcolor='#F0F0F0'>";

  echo "<td>";

  echo "<a href=$PHP_SELF?proc=view&aid=$aid&sid=$sid&rid=$id>";

  echo "  <font color=#836FFF>$banner</font>";

  echo "</a>";

  echo "</td>";

  echo "<td>";

  echo $poster;

  echo "</td>";

  echo "<td class='num'>";

  echo " ";

  echo "</td>";

  echo "<td class='num'>";

  echo $views;

  echo "</td>";

  echo "<td class='num'>";

  echo $wdate;

  echo "</td>";

  echo "</tr>";

  }

  }

  //======================================================================

  function search() {

  global $PHP_SELF;

  global $key,$aid;

  if(!strlen($key)) {

  echo "

  <script language=javascript>

  history.back();

  </script>

  ";

  }

  echo "<TABLE width=85% border=0 cellPadding=0 cellSpacing=1 align=center class='tablefont'>";

  echo "<FORM  name=mtab  ENCTYPE=multipart/form-data METHOD=POST ACTION=$PHP_SELF?proc=search>";

  echo "<tr><td>";

  echo "<input type='hidden' name=aid value='$aid'>";

  echo "穓碝ゅ彻:";

  echo "<INPUT TYPE='TEXT' NAME='key' value='$key' size=25 class='tablefont'>";

  echo "<INPUT TYPE='Submit'value='琩高' class='tablefont'>";

  echo "</td></tr>";

  echo "</FORM>";

  echo "</table>";

  $skey="%$key%";

  $DROOT=getenv('DOCUMENT_ROOT');

  include("sql.php3");

  $db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);

  if($aid) $qsql="SELECT * from bbs_subj where aid='$aid' and (banner like '$skey' or poster like '$skey' or body like '$skey') order by wdate DESC";

  else $qsql="SELECT * from bbs_subj where  (banner like '$skey' or poster like '$skey' or body like '$skey') order by wdate DESC";

  //echo $qsql;

  $rs=mysql_db_query($sql['db'],$qsql);

  echo "<TABLE width=85% border=0 cellPadding=0 cellSpacing=1 align=center bgcolor='#6CA6CD'>";

  echo "<tr><td>";

  echo "<TABLE width=100% cellPadding=1 cellSpacing=1 bgcolor=white class='tablefont'>";

  echo "<tr bgcolor=#F1E1FF>";

  echo "<th >夹肈</th>";

  echo "<th>祇癬</th>";

  echo "<th width=30>莱</th>";

  echo "<th width=30></th>";

  echo "<th width=70>ら戳</th>";

  echo "</tr>";

  while($row=mysql_fetch_array($rs)) {

  $id=$row['id'];

  $paid=$row['aid'];

  $banner=$row['banner'];

  $poster=$row['poster'];

  $views=$row['views'];

  $wdate=sdatetime($row['wdate']);

  $docs=reAnum($id);

  echo "<tr bgcolor='#F0F8FF'>";

  echo "<td>";

  echo "<a href=$PHP_SELF?proc=view&aid=$paid&sid=$id&rid=$id>";

  echo $banner;

  echo "</a>";

  echo "</td>";

  echo "<td>";

  echo $poster;

  echo "</td>";

  echo "<td class='num'>";

  echo $docs;

  echo "</td>";

  echo "<td class='num'>";

  echo $views;

  echo "</td>";

  echo "<td class='num'>";

  echo $wdate;

  echo "</td>";

  echo "</tr>";

  }

  search_docs($aid,$skey);

  echo "</td></tr></table>";

  echo"</td></tr></table>";

  }

  //======================================================================

  if($proc=="post2") {

  setcookie("c_poster",$poster,time()+ 31536000);

  setcookie("c_email",$email,time()+ 31536000);

  }

  //if($proc!="do_sel" &&  $proc!="post2" && $proc!="colloff" && $proc!="collon") include("frame_top.php3");

  switch($proc) {

  case search:

  search();

  break;

  case mail_list:

  mail_list();

  break;

  case mail_friend:

  mail_friend();

  break;

  case post2:

  post2();

  break;

  case colloff:

  cook_cooloff();

  break;

  case collon:

  cook_coolon();

  break;

  case view;

  view();

  break;

  default:

  area();

  break;

  }

  //if($proc!="do_sel" && $proc!="post2" && $proc!="colloff" && $proc!="collon") include("frame_bottom.php3");

  ?>

  以上前五篇为一个页面