本文通过实例代码给大家介绍了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 <<php爱好者留言簿 提示信息
{$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);
}
?>
好了，本文到此结束，希望对大家有所帮助！
原创声明
本站部分文章基于互联网的整理，我们会把真正“有用/优质”的文章整理提供给各位开发者。本文来自互联网用户投稿，该文观点仅代表作者本人，不代表本站立场。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。
本文链接：http://www.jiecseo.com/news/show_54906.html
本站采用系统自动发货方式，付款后即出现下载入口，如有疑问请咨询在线客服！
售后时间：早10点 - 晚11:30点
咨询售后客服
