学院首页>网络编程>PHP>社区(php&&mysql)五

社区(php&&mysql)五

作者: 来源:不详 添加时间:2006-5-25 20:44:43
  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 "&nbsp;&nbsp;<font color=#836FFF>$banner</font>";
  echo "</a>";

 echo "</td>";
 echo "<td>";
  echo $poster;
 echo "</td>";
 echo "<td
  echo "&nbsp;";
 echo "</td>";
 echo "<td
  echo $views;
 echo "</td>";
 echo "<td
  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
 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
  echo "<INPUT TYPE='Submit'value='琩高'
  
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
  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
  echo $docs;
 echo "</td>";
 echo "<td
  echo $views;
 echo "</td>";
 echo "<td
  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");  
?>

以上前五篇为一个页面  
站内搜索