From a good message of the MySQL database operation class, beginners PHP friends can refer to the
Copy Code code as follows:
<?php
Class mysql{
var $querynum = 0;
Function Connect ($dbhost, $dbuser, $DBPW, $dbname = ', $dbcharset = ') {
if (! @mysql_connect ($dbhost, $dbuser, $DBPW)) {
$this->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. ' <br> '. $sql. ' <br> $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 '!= '";
$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. = ' <meta http-equiv= ' refresh ' content= ' 2; Url= '. $referer. '/> ';
$str. = '
<table width= "45%" align= "center" style= "border:1px solid #eeeeee; margin-top:50px; " >
<tr bgcolor= "#CCCCCC" >
<TD height= > Information Tips </td>
</tr>
<TR align= "center" >
<TD style= "padding:10px 0 10px 0" > ". $message;
if ($referer!= ') $str. = ' <br/>
<br/>
<a href= "'. $referer. '" > If your page does not jump, please click here </a> ';
$str. = '
</td>
</tr>
</table> ';
Echo $str;
Exit
}
function ShowMessage ($message, $referer = ' ") {
Global $setting, $db;
$start = GetTime ();
Echo <<<eot
<! DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 transitional//en" >
<meta http-equiv= "Content-type" content= "text/html; CHARSET=GBK "/>
<title>php Fan Guestbook _ Tips </title>
<link type= "Text/css" href= "Guest.css" rel= "stylesheet" >
EOT;
if ($referer!= ') echo ' <meta http-equiv= "Refresh" content= "2; Url= '. $referer. '/> ';
Echo <<<eot
<body>
<center>
EOT;
Require_once (' header.html ');
Echo <<<eot
<div class= "Message" >
{$message}
EOT;
if ($referer!= ') {
Echo <<<eot
<br/>
<a href= "{$referer}" > If your browser does not automatically jump, please click here </a>
</div>
EOT;
}
Require_once (' footer.html ');
Echo <<<eot
</center>
</body>
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 "Please log in first, thank you." ";
Exit
}
}
else Setcookie (' IsLogin ', 1,time () +60*20);
}
?>