|
![]() |
名片设计 CorelDRAW Illustrator AuotoCAD Painter 其他软件 Photoshop Fireworks Flash |
|
<? function style(){ echo"<style>"; echo"<!--"; echo"a{font-size:9pt;color:blue}"; echo"-->"; echo"</style>"; } function GetMessages($msgStart,$number,$type){ $conn=mysql_connect("localhost","207",""); mysql_select_db("test"); $sql="select*from message where fatheird=-1 and type="; $sql=$sql.$type; $sql=$sql."order by time desc LIMIT "; $sql=$sql.$msgStart; $sql=$sql.","; $sql=$sql.$number; $result= mysql_query($sql,$conn); if(!$result){ mysql_close($conn); $msgs[0]=0; return $msgs; } $count=0; while ($obj=mysql_fetch_object($result)){ $count++; $msgs[$count]=$obj; } $msgs[0]=$count; mysql_close($conn); return $msgs; } function InsertMessage($msg){ if(!(($msg["title"])&&($msg["author"])&&($msg["time"]))){ return 0; exit; } $conn=mysql_connect("localhost","207",""); mysql_select_db("test"); $sql="insert into message(title,body,author,fatherid,time,type)values(\\'"; $sql=$sql.getsafestring($msg["title"]); $sql=$sql."\\',\\'"; $sql=$sql.getsafestring($msg["body"]); $sql=$sql."\\',\\'"; $sql=$sql.$msg["author"]; $sql=$sql."\\',"; $sql=$sql.$msg["fatherid"]; $sql=$sql.",\\'"; $sql=$sql.$msg["time"]; $sql=$sql."\\',"; $sql=$sql.$msg["type"]; $sql=$sql.")"; $result=mysql_query($sql,$conn); mysql_close($conn); return $result; } function getmessagebyfather($fatherid){ $conn=mysql_connect("localhost","207",""); mysql_select_db("test"); $sql="select*from message where fatherid="; $sql=$sql.$fatherid; $sql=$sql."order by time desc"; $result=mysql_query($sql,$conn); if(!$result){ mysql_close($conn); $msgs[0]=0; return $msgs; } $count=0; while($obj=mysql_fetch_object($result)){ $count++; $msgs[$count]=$obj; $msgs[$count]->child=getmessagebyfather($obj->id); } $msgs[0]=$count; return $msgs; } $count=0; while ($obj=mysql_fetch_object($result)){ $count++; $msgs[$count]=$obj; $msgs[$count]->child=getmessagebyfather($obj->id); } $msgs[0]=$count; return $msgs; } function getmsgcount($type){ $conn=mysql_connect("localhost","207",""); mysql_select_db("test"); $sql="select count(*)from message where fatherid=-1 and type="; $sql=$sql.$type; $result=mysql_query($sql,$conn); $count=mysql_result($result,0); mysql_colse($conn); return $count; } function getmessagebyid($id){ $conn=mysql_connect("localhost","207",""); mysql_select_db("test"); $sql="select*from messgae where id=".$id; $result=mysql_query($sql,$conn); if(!$result) return 0; } $obj=mysql_fetch_object($result); mysql_colse($conn); return $obj; } function getsafestring($string){ $string=str_replace("<","<",$string); $string=str_replace(">",">",$string); $string=str_replace("\\'","",$string); $string=str_replace("/n","<br>",$string); $string=str_replace(" ","",$string); return $string } 返回类别: 教程 上一教程: 用PHP实现WEB动态网页静态 下一教程: 扩展你的PHP之入门篇 您可以阅读与"用PHP3作树型目录(1)"相关的教程: · 用PHP3作树型目录(4) · 用PHP3作树型目录(3) · 用PHP3作树型目录(2) · 树型结构列出指定目录里所有文件的PHP类 · 如何删除多级目录 |
![]() ![]() |
快精灵印艺坊 版权所有 |
首页![]() ![]() ![]() ![]() ![]() ![]() ![]() |