从一个不错的留言本弄的mysql数据库操作类

发布时间：2020-05-25 21:54:57 所属栏目：PHP 来源：互联网

导读：本文通过实例代码给大家介绍了mysql数据库操作类的相关知识，感兴趣的朋友跟随脚本之家小编一起看看吧

从一个不错的留言本弄的mysql数据库操作类，初学php的朋友可以参考下

show('Can not connect to MySQL server'); return false; } if($dbname) { $this->select_db($dbname); } if($this->version() > '4.1' && $dbcharset) { $this->query("SET NAMES '".$dbcharset."'"); } return true; } function select_db($dbname) { return mysql_select_db($dbname); } function fetch_array($query,$result_type = MYSQL_ASSOC) { return @mysql_fetch_array($query,$result_type); } function query($sql,$type = '') { if(!($query = mysql_query($sql))) $this->show('MySQL Query Error',$sql); $this->querynum++; return $query; } function affected_rows() { return mysql_affected_rows(); } function result($query,$row) { return mysql_result($query,$row); } function num_rows($query) { return @mysql_num_rows($query); } function num_fields($query) { return mysql_num_fields($query); } function free_result($query) { return mysql_free_result($query); } function insert_id() { return mysql_insert_id(); } function fetch_row($query) { return mysql_fetch_row($query); } function version() { return mysql_get_server_info(); } function close() { return mysql_close(); } function error() { return mysql_error(); } function show($message = '',$sql = '') { if(!$sql) echo $message; else echo $message.'
'.$sql.'
'.$this->error(); } } class page extends mysql{ function pagination($sql,$maxnum,$page,$maxpages,$pagepre,$ext=''){ global $sum,$stail,$link,$lmid,$ltail,$curpage;//$ext='&class=3' $SELF = $_SERVER['PHP_SELF']; $query = $this->query($sql); $rows = $this->fetch_array($query,MYSQL_NUM); $totalrows = $rows[0]; $totalpages = ceil($totalrows/$maxnum); $startnum = ($page - 1)*$maxnum; $string = $sum.$totalrows.$stail.$sum.$page."/".$totalpages.$stail; if($page != 1){ $string .= $link.$SELF."?page=1".$ext.$lmid."|‹".$ltail; $string .= $link.$SELF.'?page='.($page - 1).$ext.$lmid."‹‹".$ltail; } if($maxpages>=$totalpages){ $pgstart = 1;$pgend = $totalpages; } elseif(($page-$pagepre-1+$maxpages)>$totalpages){ $pgstart = $totalpages - $maxpages + 1; $pgend = $totalpages; } else{ $pgstart=(($page<=$pagepre)?1:($page-$pagepre)); $pgend=(($pgstart==1)?$maxpages:($pgstart+$maxpages-1)); } for($pg=$pgstart;$pg<=$pgend;$pg++){ if($pg == $page){ $string .= $curpage.$SELF."?page=".$pg.$ext.$lmid.$pg.$ltail; } else $string .= $link.$SELF."?page=".$pg.$ext.$lmid.$pg.$ltail; } if($page != $totalpages){ $string .= $link.$SELF.'?page='.($page + 1).$ext.$lmid."››".$ltail; $string .= $link.$SELF.'?page='.$totalpages.$ext.$lmid."›|".$ltail; } return $string; } } function html($str,$allowhtml=0){ $str = get_magic_quotes_gpc()?$str:addslashes($str); if(!$allowhtml){$str = htmlspecialchars($str);} return $str; } function dehtml($str,$allowhtml=0){ $str = stripslashes($str); if(!$allowhtml){$str = nl2br($str);} return $str; } function deip($str){ $arr = explode('.',$str); $str = $arr[0].'.'.$arr[1].'.'.$arr[2].'.*'; return $str; } function setting($login=false){ global $db,$mydbpre; if($login) $sql = "select * from {$mydbpre}setting"; else $sql = "select * from {$mydbpre}setting where keyword != 'username' and keyword != 'password'"; $query = $db->query($sql); while($row = $db->fetch_array($query)){ $arr[$row['keyword']] = $row['val']; if($row['keyword'] == 'name') $arr['title'] = $row['val'].' - Powered by PHPfans'; } return $arr; } function checkcontent($content){ global $db,$mydbpre,$mearr; $arrword = $arrip = array(); $sql = "select * from {$mydbpre}ban where b_type != 0"; $query = $db->query($sql); while($row = $db->fetch_array($query)){ if($row['b_type'] == 1) $arrword[] = $row['b_val']; elseif($row['b_type'] == 2) $arrip[] = $row['b_reval']; } foreach($arrip as $value){ $value = preg_quote($value,'/'); $value = str_replace('*','d{1,3}',$value); if(preg_match('/^('.$value.')$/',$_SERVER['REMOTE_ADDR'])){ showmessage($mearr[8],'index.php'); } } foreach($arrword as $val){ $val = preg_quote($val,'/'); if(preg_match('/'.$val.'/',$content)){ showmessage($mearr[7],'index.php'); } } } function replaceword($content){ global $db,$mydbpre; $sql = "select * from {$mydbpre}ban where b_type = 0"; $query = $db->query($sql); while($row = $db->fetch_array($query)){ $content = str_replace($row['b_val'],$row['b_reval'],$content); } return $content; } function showadmin($message,$referer=''){ $str = ''; if($referer != '') $str .= ''; $str .= ' php爱好者留言簿_提示信息'; echo << EOT; require_once('header.html'); echo << {$message} EOT; if($referer != ''){ echo << EOT; } require_once('footer.html'); echo << EOT; exit; } function gettime() { $t = explode(" ",microtime()); return $t[1] + $t[0]; } function checklogin($exit=true){ if(!isset($_COOKIE['islogin']) || $_COOKIE['islogin'] != 1){ if($exit) { echo "请先登陆，谢谢。"; exit; } } else setcookie('islogin',1,time()+60*20); } ?>

好了，本文到此结束，希望对大家有所帮助！

（编辑：安卓应用网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!