社区(phpmysql)五

　　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 INTObbs_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);
elseSend_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 "<FORMname=mtabENCTYPE=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=Submitvalue=琩高 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");
?>

以上前五篇为一个页面