社区(php&&mysql)五
2015-01-24信息快讯网
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('恶gぃЧ俱');
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) { //郯圣[Jmail_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 "jMゅ彻:";
echo "<INPUT TYPE='TEXT' NAME='key' value='$key' size=25 class='tablefont'>";
echo "<INPUT TYPE='Submit'value='d高' 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 >夹D</th>";
echo "<th>o_H</th>";
echo "<th width=30>^莱</th>";
echo "<th width=30>H</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");
?>
以上前五篇为一个页面
WINDOWS下php5.2.4+mysql6.0+apache2.2.4+ZendOptimizer-3.3.0配置
Mysql的GROUP_CONCAT()函数使用方法
php中文字符截取防乱码
php5中类的学习
php一些公用函数的集合
PHP之变量、常量学习笔记
PHP与MySQL开发中页面乱码的产生与解决
一家之言的经验之谈php+mysql扎实个人基本功
php+mysql分页代码详解
判“新”函数:得到今天与明天的秒数
社区(php&&mysql)四
社区(php&&mysql)三
利用php来自动调用不同服务器上的flash
社区(php&&mysql)二
社区(php&&mysql)一
BBS(php & mysql)完整版(八)