社区(php&&mysql)五

function post2() {

global $sid,$aid,$php_lf;

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[‘ur’] , $sql[‘passwd’]);

$now=date(‘y’).”-“.date(‘m’).”-“.date(‘d’).” “.date(‘h’).”:”.date(‘i’).”:”.date(‘s’);

if($char_gb==1) {

include(“cchart.php3”);

$code=new cchart;

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

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

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

}

if($type==1) {

$qsql=”inrt into bbs_docs (aid,sid,banner,body,poster,email,pip,wdate)

values(‘$aid’,’$sid’,’$banner’,’$body’,’$poster’,’$email’,’$rip’,’$now’)”;

} el {

$qsql=”inrt 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_inrt_id();

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

$qsql=”inrt intobbs_sml (sid,email) values(‘$id’,’$email’)”;

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

}

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

elnd_the_doc_to_mail_list($aid,$sid,$id);

//incdocs($aid);

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

el{ $rid=$id;}

echo ”

<script language=javascript>

document.location=’$php_lf?proc=view&aid=$aid&sid=$sid&rid=$rid’

</script>

“;

}

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

function arch_docs($aid,$skey) {

$droot=getenv(‘document_root’);

include(“sql.php3”);

$db=mysql_connect($sql[‘host’], $sql[‘ur’] , $sql[‘passwd’]);

//$qsql=”lect * 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=”lect * from bbs_docs where aid=’$aid’ and (banner like ‘$skey’ or poster like ‘$skey’ or body like ‘$skey’) orde部队加薪r by wdate desc”;

el $qsql=”lect * 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_lf?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’>”;

echavg anti spywareo $views;

echo “</td>”;

echo “<td class=’num’>”;

echo $wdate;

echo “</td>”;

echo “</tr>”;

}

}

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

function arch() {

global $php_lf;

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_lf?proc=arch>”;

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[‘ur’] , $sql[‘passwd’]);

if($aid) $qsql=”lect * from bbs_subj where aid=’$aid’ and (banner like ‘$skey’ or poster like ‘$skey’ or body like ‘$skey’) order by wdate desc”;

el $qsql=”lect * 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>”;win7一键激活

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_lf?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>”;

}

arch_docs($aid,$skey);

echo “</td></tr></table>”;

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

}

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

if($proc==”post2″) {

tcookie(“c_poster”,$poster,time()+ 31536000);

tcookie(“c_email”,$email,time()+ 31536000);

}

//if($proc!=”do_l” &&$proc!=”post2″ && $proc!=”colloff” && $proc!=”collon”) include(“frame_top.php3”);

switch($proc) {

ca arch:

arch();

break;

ca mail_list:

mail_list();

break;

ca mail_friend:

mail_friend();

break;

ca post2:

post2();

break;

ca colloff:

cook_cooloff();

break;

ca collon:

cook_coolon();

break;

ca view;

view();

break;

default:

area();

break;

}

//if($proc!=”do_l” && $proc!=”post2″ && $proc!=”colloff” && $proc!=”collon”) include(“frame_bottom.php3”海地人口);

?>

以上前五篇为一个页面