PHP单用户微博程序源码整理

1、 单用户微博程序源码数据库结构（共三张表：w_comment、w_log、w_online）主页index.php源码$v)$s$k=rs($v);else$s=stripslashes($s);return $s; $_GET=rs($_GET);$_POST=rs($_POST);$_COOKIE=rs($_COOKIE);/*=系统配置开始=*/$db_host=localhost;/MYSQL数据库服务器$db_user=root;/MYSQL数据库用户$db_password=;/MYSQL数据库用户密码$db_name=miniblog;/MYSQL数据库名称$db_prefix=

2、w_;/MYSQL数据表前缀$rewrite=false;/是否开启路径重写规则$rewrite_ext=html;/重写文件名后缀$password=admin;/管理登录密码$online_overtime=30;/在线记录超时时间间隔(分钟)/*=系统配置结束=*/检查是否非法提交function check_request()if(empty($_SERVERHTTP_REFERER)|(preg_replace(/https?:/(:/+).*/i,1,$_SERVERHTTP_REFERER)!=preg_replace(/(:+).*/, 1,$_SERVERHTTP_HOST)

3、exit(Access Denied!);/过滤非法字符function filter_badwords($content,$badwords)$words=explode(,$badwords);$words_count=count($words);$words_tmep=$content;for($i=0;$i$words_count;$i+)$replace_tmep=explode(=,$words$i);$words_tmep=str_replace($replace_tmep0,$replace_tmep1,$words_tmep);return $words_tmep;/获取当前

4、文件名function get_self()return isset($_SERVERPHP_SELF)?$_SERVERPHP_SELF:$_SERVERSCRIPT_NAME;/获取IPfunction get_ip()if (isset($_SERVERHTTP_X_FORWARDED_FOR)$ip=$_SERVERHTTP_X_FORWARDED_FOR;elseif (isset($_SERVERHTTP_CLIENT_IP)$ip=$_SERVERHTTP_CLIENT_IP;else$ip=$_SERVERREMOTE_ADDR;return $ip;/从IP.CN获取IP物理

5、地址function get_ip_address($ip)if($ip=)return IP：.$ip. 来自：本地;$content=file_get_contents(/getip.php?action=queryip&ip_url=.$ip);return str_replace(您查询的IP是,IP,iconv(GB2312,UTF-8/IGNORE,$content);/格式化日期时间function format_datetime($time)$now=time()-$time;if($now60)return $now. 秒前;e

6、lseif($now3600)return intval($now/60). 分钟前;elseif($now86400)return intval($now/3600). 小时前;elsereturn date(Y-m-d H:i:s,$time);/分页程序function pager($page_name,$page_parameters=,$page_current,$page_size,$log_count)global $config;parse_str($page_parameters);$page_count=ceil($log_count/$page_size);$page_s

7、tart=$page_current-2;$page_end=$page_current+2;if($page_current$page_count-2)$page_start=$page_count-4;$page_end=$page_count;if($page_start$page_count)$page_end=$page_count;$html=;$html.=;/$html.=RecordCount:.$log_count.n;$html.=.$page_current. / .$page_count.;if($page_current!=1)if($GLOBALSrewrite)

8、$html.=«else$html.=«for($i=$page_start;$i=$page_end;$i+)if($i=$page_current)$html.=.$i.;elseif($GLOBALSrewrite)$html.=.$i.;else$html.=.$i.;if($page_current!=$page_count)if($GLOBALSrewrite)$html.=»else$html.=»$html.=;return $html;/获取操作系统function get_os()$AGENT=$_SERVERHTTP_USE

9、R_AGENT;if(strpos($AGENT,Windows NT 5.0)$os=Windows 2000;elseif(strpos($AGENT,Windows NT 5.1)$os=Windows XP;elseif(strpos($AGENT,Windows NT 5.2)$os=Windows 2003;elseif(strpos($AGENT,Windows NT 6.0)$os=Windows Vista;elseif(strpos($AGENT,Windows NT 6.1)$os=Windows 7;elseif(strpos($AGENT,Windows NT)$os

10、=Windows NT;elseif(strpos($AGENT,Windows CE)$os=Windows CE;elseif(strpos($AGENT,ME)$os=Windows ME;elseif(strpos($AGENT,Windows 9)$os=Windows 98;elseif(strpos($AGENT,unix)$os=Unix;elseif(strpos($AGENT,linux)$os=Linux;elseif(strpos($AGENT,SunOS)$os=SunOS;elseif(strpos($AGENT,OpenBSD)$os=OpenBSD;elseif

11、(strpos($AGENT,FreeBSD)$os=FreeBSD;elseif(strpos($AGENT,AIX)$os=AIX;elseif(strpos($AGENT,Mac)$os=Mac;else $os=Other;return $os;/获取浏览器function get_bs()$AGENT=$_SERVERHTTP_USER_AGENT;if(strpos($AGENT,Opera)$bs=Opera;elseif(strpos($AGENT,Firefox)$bs=Firefox;elseif(strpos($AGENT,Chrome)$bs=Chrome;elseif

12、(strpos($AGENT,MSIE 6)$bs=IE6;elseif(strpos($AGENT,MSIE 7)$bs=IE7;elseif(strpos($AGENT,MSIE 8)$bs=IE8;else $bs=Other;return $bs;/获取在线信息function set_online()if($GLOBALSdb-getcount(select * from .$GLOBALSdb_prefix.online where onlineip=.get_ip().)0)$sql=update .$GLOBALSdb_prefix.online set onlinetime=

13、.$_SERVERREQUEST_TIME.,onlineagent=.get_os()./.get_bs(). where onlineip=.get_ip().;else$sql=insert into .$GLOBALSdb_prefix.online(onlinetime,onlineip,onlineagent) values(.$_SERVERREQUEST_TIME.,.get_ip().,.get_os()./.get_bs().);$GLOBALSdb-query($sql);$GLOBALSdb-delete(.$GLOBALSdb_prefix.online,online

14、timedb_link=mysql_connect($db_host, $db_user, $db_password,true) or exit(Cant connect MySQL server($db_host)!); mysql_select_db($db_name,$this-db_link) or exit(Cant select MySQL database($db_name)!); mysql_query(set names utf8,$this-db_link);$this-db_name=$db_name;function _destruct()if($this-db_lin

15、k)mysql_close($this-db_link);function query($sql)return mysql_query($sql,$this-db_link);function insert($table,$values,$debug=false)$ks=;$vs=;foreach($values as $key = $value)$ks.=$ks?,$key:$key;$vs.=$vs?,$value:$value;$sql=insert into $table ($ks) values ($vs);if($debug)return $sql;return $this-que

16、ry($sql);function update($table,$values,$where=,$debug=false)$v=;foreach($values as $key = $value)$v.=$v?,$key=$value:$key=$value;$sql=update $table set $v where $where;if($debug)return $sql;return $this-query($sql);function delete($table,$where=,$debug=false)if(empty($where)|$where=)$sql=delete fro

17、m $table;else$sql=delete from $table where $where;if($debug)return $sql;return $this-query($sql);function getcount($sql)return mysql_num_rows($this-query($sql); function getall($sql)$temp; $result =$this-query($sql); if ($result) $array = array(); while ($row = mysql_fetch_assoc($result) $array = $r

18、ow; $temp=$array;mysql_free_result($result); else $temp=false; return $temp; function getone($sql)$temp;$result=$this-query($sql); if ($result)$temp=mysql_fetch_array($result);mysql_free_result($result);else$temp=false;return $temp;function getdata()$res=mysql_list_tables($this-db_name);while ($row

19、= mysql_fetch_row($res)$table=$row0;$sql=;foreach ($table as $v)$sql.=DROP TABLE IF EXISTS $v;n;$rs=mysql_fetch_row(mysql_query(show create table $v);$sql.=$rs1.;nn;foreach ($table as $v)$res=$this-query(select * from $v);$fild=mysql_num_fields($res);while ($rs=mysql_fetch_array($res)$comma=;$sql.=i

20、nsert into $v values(;for($i=0;$idb_link); function version()return mysql_get_server_info($this-db_link);/检查是否登录function check_login()if(!isset($_SESSIONlogin)|$_SESSIONlogin!=true)session_destroy();exit(alert(您还没有登录，或者登录已超时！);location.href=.get_self().;);function goto($url,$text)page_header();echo(

21、);echo();echo();echo($text);echo();echo();page_footer();exit();function alert($text)page_header();echo(setTimeout(function()history.back(),1500);echo();echo();echo($text);echo();echo();page_footer();exit();/页面头部function page_header()echo();echo();echo();echo();echo();echo();?html,bodymargin:15px 20p

22、x;padding:0;border-left:3px solid #ccc;border-right:3px solid #ccc;font:normal 12px tahoma#wrappermargin:auto;#headerposition:relative;height:40px;background:#C00;border-bottom:3px solid #CCC;border-TOP:3px solid #CCC;color:#fff;#header #navposition:absolute;right:0;top:0;height:40px;#header #nav ad

23、isplay:block;float:left;text-decoration:none;padding:0 10px;font:bold 12px tahoma;line-height:40px;color:#FFF;#header #nav a:hoverbackground:#A00;#header .titleposition:absolute;left:10px;top:0;background:#C00;font:bold 25px tahoma;line-height:40px;color:#FFF;text-decoration:none;#centerpadding:5px;

24、#center .itempadding:5px;font:normal 14px tahoma,宋体;line-height:25px;border-bottom:1px dotted #CCC;color:#000;word-break : break-all; word-wrap: break-word;#center .item:first-letterpadding-left:5px;font:bold 1.5em 楷体,tahoma,宋体;color:#C00#center .item .timefont:normal 12px Arial;color:#999;#center .

25、item .itempadding:2px 5px;text-decoration:none;background:#C00;font:normal 12px Arial;color:#fff;#center #comment_list#center #comment_list divpadding-left:10px;margin-top:5px;font:normal 12px Tahoma;line-height:28px;border:1px solid #CCC;Background-color:#FFFFEC;#center #comment_list div bcolor:#00

26、0;#center #comment_list div .timefont:normal 10px Arial;color:#999;#center #comment_list div .itempadding:2px 5px;text-decoration:none;background:#C00;font:normal 12px Arial;color:#fff;#online_listmargin:5px;padding:0;list-style-type:none#online_list lifont:normal 12px tahoma,宋体;line-height:25px#pag

27、ermargin:10px#pager apadding:4px 10px;text-decoration:none;background:#C00;font:normal 12px Tahoma;color:#fff#pager a:hoverbackground:#C00;color:#fff#pager .hoverbackground:#C00;color:#fff#pager .infopadding:4px 10px;font:normal 12px Tahoma;color:#fff;background:#A00;color:#fff#linkmargin:5px;paddin

28、g:5px;border:1px dotted #C00#link adisplay:block;float:left;background:#fff;text-decoration:none;font:normal 12px Tahoma;line-height:22px;padding:0px 8px;color:#C00#link a:hoverbackground:#C00;color:#fff#footerheight:25px;background:#CCC;border-top:3px solid #EEE;padding-left:20px;font:normal 11px A

29、rial;line-height:25px;color:#FFF;?echo(Sevens Home !);echo();echo();echo();echo();echo(Sevens Home !);echo();if(isset($_SESSIONlogin)&$_SESSIONlogin=true)echo(发布);echo(在线);echo(退出);elseecho(登录);echo();echo();echo();/页面尾部function page_footer()echo();echo(Copyright © 2010 Pcook.Com.Cn .

30、);echo();echo();echo();/选择器$action=isset($_GETaction)?trim($_GETaction):;/首页if($action=)$db=new db($db_host,$db_user,$db_password,$db_name);page_header();echo();$sql=SELECT * FROM .$db_prefix.log WHERE log_state=0 ;$sql.= ORDER BY log_id DESC;$page_size=10;$page_current=isset($_GETpage)&is_numeric($

31、_GETpage)?intval($_GETpage):1;$count=$db-getcount($sql);$res=$db-getall($sql. limit .($page_current-1)*$page_size).,.$page_size);if($count0)foreach($res as $row)echo();echo(htmlspecialchars($rowlog_content);echo( .format_datetime($rowlog_time).);echo( 评论(.$rowlog_comment_count.);if(isset($

32、_SESSIONlogin)&$_SESSIONlogin=true)echo( 编辑);echo( 删除);echo();echo(pager(index,$page_current,$page_size,$count);elseecho(暂无数据！);echo();/echo();/echo(百度);/echo();/echo();page_footer();set_online();/评论页if($action=comment)$db=new db($db_host,$db_user,$db_password,$db_name);if(isset($_GETlog_i

33、d)$log_id=intval($_GETlog_id);elsealert(日志编号丢失无法浏览评论！);$row=$db-getone(SELECT * FROM .$db_prefix.log WHERE log_id=.$log_id.);page_header();echo();echo();echo(htmlspecialchars($rowlog_content);echo( .format_datetime($rowlog_time).);if(isset($_SESSIONlogin)&$_SESSIONlogin=true)echo( 编辑);echo

34、( 删除);echo();$res=$db-getall(SELECT * FROM .$db_ment WHERE log_id=.$log_id.);if($res)echo();foreach($res as $row)echo();echo(.htmlspecialchars($rowcomment_name).:.htmlspecialchars($rowcomment_content). .format_datetime($rowcomment_time).);if(isset($_SESSIONlogin)&$_SESSIONlogin=true)echo( 编辑);echo( 删除);if($rowcomment_reply)echo();echo(   - 管理员回复：.htmlspecialchars($rowcomment_reply).);echo();echo();echo();echo(&n