建站极客
网络编程 PHP编程 正文
社区(php&&mysql)五
所属分类:
网络编程 / PHP编程
阅读数:
1353
收藏 0
赞 0
分享
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 " <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 "穓碝ゅ彻:"; 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"); ?> 以上前五篇为一个页面
CI框架实现创建自定义类库的方法 这篇文章主要介绍了CI框架实现创建自定义类库的方法,结合实例形式分析了CI框架创建自定义类库的相关原理、步骤、实现方法与操作注意事项,需要的朋友可以参考下
评论 0
收藏 0
赞 0
分享
CI框架附属类用法分析 这篇文章主要介绍了CI框架附属类用法,结合实例形式分析了CI框架附属类相关资源访问操作技巧,需要的朋友可以参考下
评论 0
收藏 0
赞 0
分享
CI框架网页缓存简单用法分析 这篇文章主要介绍了CI框架网页缓存简单用法,结合实例形式分析了CI框架网页缓存的原理,以及开启缓存、删除缓存等操作技巧,需要的朋友可以参考下
评论 0
收藏 0
赞 0
分享
php实现的PDO异常处理操作分析 这篇文章主要介绍了php实现的PDO异常处理操作,结合实例形式分析了pdo异常处理的相关原理、用法及操作注意事项,需要的朋友可以参考下
评论 0
收藏 0
赞 0
分享
php PDO属性设置与操作方法分析 这篇文章主要介绍了php PDO属性设置与操作方法,结合实例形式分析了php pdo常见属性功能及相关的设置、获取操作技巧,需要的朋友可以参考下
评论 0
收藏 0
赞 0
分享
PHP抽象类基本用法示例 这篇文章主要介绍了PHP抽象类基本用法,结合实例形式分析了php抽象类的概念、原理、定义、使用方法及相关操作注意事项,代码注释包含较为详尽的说明信息,需要的朋友可以参考下
评论 0
收藏 0
赞 0
分享
PHP面向对象程序设计继承用法简单示例 这篇文章主要介绍了PHP面向对象程序设计继承用法,结合具体实例形式分析了php面向对象程序设计中继承的相关概念、原理、使用技巧与相关操作注意事项,需要的朋友可以参考下
评论 0
收藏 0
赞 0
分享
PHP实现函数内修改外部变量值的方法示例 这篇文章主要介绍了PHP实现函数内修改外部变量值的方法,涉及php全局变量、传值调用、引用等相关操作技巧,需要的朋友可以参考下
评论 0
收藏 0
赞 0
分享
PHP命名空间简单用法示例 这篇文章主要介绍了PHP命名空间简单用法,结合具体实例形式分析了php命名空间的简单定义与使用相关操作技巧,需要的朋友可以参考下
评论 0
收藏 0
赞 0
分享
查看更多