电脑技术学习

社区(php&&mysql)五

dn001
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 class='num'>"
;;;;echo "&nbsp;"
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");;;;;;
?>

以上前五篇为一个页面;

标签: