• 欢迎访问搞代码网站，推荐使用最新版火狐浏览器和Chrome浏览器访问本网站！
  • 如果您觉得本站非常有看点，那么赶紧使用Ctrl+D 收藏搞代码吧
> 后端 > php > php实现mysql数据库操作类分享_php实例

php实现mysql数据库操作类分享_php实例

php 搞代码 3年前 (2022-01-26) 24次浏览 已收录 0个评论 
<?php<BR>/*<BR>数据库操作类<BR>*/<BR>class Mysql{<BR> private $LocalHost = 'localhost';<BR> private $LoaclUser = 'root';<BR> private $LocalPass = '123456';<BR> private $LocalBase = 'jiangxibaiyi';<BR> private $LocalCode = 'UTF8';<BR> private $PreFix;<BR> private $Conn;<BR> private $Start     = 0;<BR> private $Error     = false; //数据库连接状态, false表示未连接或连接不正常<BR> public  $Err       = true;  //Sql执行结果<br><br> private $Table;<BR> private $Field     = '*';<BR> private $Where     = '';<BR> private $Order     = '';<br><br> private $PageSize  = 0; //分页显示->每页多少条，0为不分页显示<BR> private $PageCount = 1; //分页显示->总共有多少条<BR> private $PageNum   = 1; //分页显示->总共有多少页<BR> private $PageNo    = 1; //分页显示->当前第几页<BR> private $PageKey   = 'page'; //分页url参数键<BR> private $PageStart = 0; //分页显示->当前从第几条开始返回<br><br> <BR> private $Select;<BR> private $Rest;<br><br> private $Result    = false;//结果集<br><br> public $FormArray = array();<br><br> public $Instr_ID  = 0;<BR> private $j =  0;<br><br> <BR> public function Parameter($Loca, $Root, $Pass, $Base, $Code, $PreFix = ''){<BR>  $this->LoaclUser = $Root;<BR>  $this->LocalBase = $Base;<BR>  $this->LocalCode = $Code;<BR>  $this->LocalHost = $Loca;<BR>  $this->LocalPass = $Pass;<BR>  $this->PreFix    = $PreFix;<BR>  return $this;<BR> }<BR> private function Connection( $Sql ){<BR>  !function_exists(mysqli_connect) ? die('查询失败，无法加载mysqli扩展') : null;<BR>  $this->Conn = @new mysqli( $this->LocalHost, $this->LoaclUser, $this->LocalPass, $this->LocalBase);<BR>  $this->Error = mysqli_connect_errno() == 0 ? true : false;<BR>  !$this->Error ? die('数据库连接错误，请检查数据库连接参数') : null;<BR>  $this->Conn->query('SET NAMES ' . $this->LocalCode);<BR>  $this->Rest = $this->Conn->query($Sql);<BR>  $this->Err  = mysqli_error($this->Conn);<BR>  $this->Instr_ID = mysqli_insert_id($this->Conn);<BR>  $this->Rest->free_result;<BR>  $this->Conn->close;<BR>  $this -> FormArray = '';<BR>  return $this;<BR> }<br><br> public function null(){<BR>  $this->PageSize  = 0;<BR>  //$this->PageCount = 1;<BR>  $this->PageStart = 1;<BR>  $this->Field     = ' * ';<BR>     $this->Select    = '';<BR>  unset($this->Table, $this->Where,$this->Order, $this->Result);<BR> }<br><br> public function Table( $TableName ) {//数据表<BR>   $this -> null();<BR>   $this->Table = '`' . $this->PreFix . $TableName . '`';<BR>   return $this;<BR> }<br><br> public function Field( $Array = '*' ) {//数据字段<BR>   !empty( $this->Field ) ? $this->Field = '' : null;<BR>   $Array = explode(',', $Array);<BR>   foreach ( $Array as $field ) {<BR>   $this->Field .= !$this->Start ? '`' . $field . '`' :  ', `' . $field . '`';<BR>   $this->Start++;<BR>   }<BR>   $this->Start = 0;<BR>   return $this;<BR> }<br><br> public function Where( $Where ) {//条件<BR>       $this->Where = ' where ' .$Where;<BR>    return $this; <BR> }<br><br> public function Order( $Order ) {//排序<BR>   $this->Order = ' order by ' . $Order;<BR>   return $this;<BR> }<br><br> public function pk( $key ) {//分页url参数键<BR>   $this->PageKey = $key;<BR>   return $this;<BR> }<br><br> public function Page( $PageSize ) {//分页<BR>   $this->PageSize = $PageSize;<BR>   $this->PageNo   = $this->get( $this->PageKey );<BR>   $this->PageNo   = empty( $this->PageNo ) || !isset( $this->PageNo ) || !is_numeric( $this->PageNo ) || $this->PageNo PageNo;<BR>   return $this;<BR> }<br><br> public function post( $Key, $Filter = true ){<BR>  return $Filter ? strip_tags($_POST[$Key]) : $_POST[$Key];<BR> }<br><br> public f<em style="color:transparent">本@文来源[email protected]搞@^&代*@码网(</em><q>搞代gaodaima码</q>unction get( $Key, $Filter = true ){<BR>  return $Filter ? strip_tags($_GET[$Key]) : $_GET[$Key];<BR> }<br><br> public function Sel(){<BR>  $this->Select = 'Select ' . $this->Field . ' from ' . $this->Table . $this->Where . $this->Order;<BR>  $this->Connection( $this->Select );<BR>  if ( $this->Rest->num_rows ) {<BR>   while ( $Rs = $this->Rest->fetch_assoc() ) {<BR>     $this->Result[] = $Rs;<BR>    }<BR>  }<BR>    $DataBase = $this->Result;<BR>    return empty($DataBase) ? false : $DataBase;<BR> }<br><br> public function querys( $Sql = '', $Type = 'not', $biao = false ) {<BR>  $this->Select = $Sql;<BR>  $this->Connection( $this->Select );<BR>  if ( $this->Rest->num_rows ) {<BR>     if ( !$biao ) {<BR>   while ( $Rs = $this->Rest->fetch_array() ) {<BR>     $this->Result[] = !preg_match('/^\d+$/i', $Type) ?  $Rs : $Rs[ $Type ];<BR>    }<BR>  } else {<BR>   while ( $Rs = $this->Rest->fetch_assoc() ) {<BR>     $this->Result[] = $Rs;<BR>    }<BR>  }<BR>  }<BR>    $DataBase = $this->Result;<BR>    return empty($DataBase) ? false : $DataBase;<br><br> }<br><br> public function executes( $Sql = '' ){<BR>  $this->Connection( $Sql  );<BR>  return $this->Rest;<BR> }<br><br> <BR> public function exists( $T = '', $F = '', $W = ''){<BR>  if ( empty( $F ) ) { return 0; }<BR>  $cmd = empty( $W ) ? 'Select sum(' . $F . ') as `baiyinum` from `' . $this->PreFix . $T .'`' : 'Select sum(' . $F . ') as `baiyinum` from `' . $this->PreFix . $T .'` Where ' . $W;<BR>        $this->Connection( $cmd );<BR>  unset( $T, $F, $W, $cmd );<BR>  $Rel =  $this->Rest->fetch_array();<BR>  return round( $Rel['baiyinum'], 2 );<BR> }<br><br> <BR> public function ExistsTo( $Bili = 10000, $T = '', $F = '', $W = ''){<BR>  if ( empty( $F ) ) { return 0; }<BR>  $cmd = empty( $W ) ? 'Select sum(' . $F . ') as `baiyinum` from `' . $this->PreFix . $T .'`' : 'Select sum(' . $F . ') as `baiyinum` from `' . $this->PreFix . $T .'` Where ' . $W;<BR>        $this->Connection( $cmd );<BR>  unset( $T, $F, $W, $cmd );<BR>  $Rel =  $this->Rest->fetch_array();<BR>  return round( $Rel['baiyinum'] * $Bili );<BR> }<br><br> <BR> public function Select( $Type = true, $ListNum = 1 ){ //返回记录（数组形式， 返回条数）<BR>   $this->Select = 'Select ' . $this->Field . ' from ' . $this->Table . $this->Where . $this->Order;<BR>   if ( is_numeric( $ListNum ) ) { <BR>  if ( $this->PageSize > 0 ) {<BR>   $this->Connection( $this->Select );//执行查询<BR>   $this->PageCount =  $this->Rest->num_rows;//取得记录总数<BR>   $this->PageNum   =  ceil($this->PageCount / $this->PageSize); //总共有多少页<BR>   $this->PageNo    = $this->PageNo > $this->PageNum ? $this->PageNum : $this->PageNo;<BR>   $this->PageStart = ( $this->PageNo - 1 ) * $this->PageSize;   //当前从第几条开始返回<BR>   $this->Select   .= ' limit ' . $this->PageStart . ', ' .$this->PageSize; //重新构造sql语句<BR>  } else {<BR>   $this->Select   .= ' limit ' . $ListNum; //重新构造sql语句<BR>  }<BR>   } else {<BR>   $this->Select   .= ' limit 1'; //重新构造sql语句<BR>   }<BR>   //echo $this->Select;<BR>   $this->Connection( $this->Select );//再次执行查询<BR>   if ( $this->Rest->num_rows ) {//如果记录存在<BR>  if ( $Type ) {<BR>    while ( $Rs = $this->Rest->fetch_array() ) {<BR>     $this->Result[] = $Rs;<BR>    }<BR>  }else{<BR>    while ( $Rs = $this->Rest->fetch_assoc() ) {<BR>     $this->Result[] = $Rs;<BR>    }<BR>  }<BR>   }<BR>   if ( ( $ListNum == 1 or !is_numeric( $ListNum ) ) && !$this->PageSize) { $this->Result = $this->Result[0]; }<BR>   $DataBase = $this->Result;<BR>   return empty($DataBase) ? false : $DataBase;<BR> }<br><br>   public function Num() { //返回记录总数<BR>     $this->Select = 'Select ' . $this->Field . ' from ' . $this->Table . $this->Where . $this->Order;<BR>  $this->Connection( $this->Select );//执行查询<BR>  return $this->Rest->num_rows;//取得记录总数<BR>   }<br><br>   public function PageNav($NumNav = false ) {  //分页<BR>  $Action = $this -> get('action');<BR>  !empty( $Action ) or $Action =  'index';<BR>  $Module = $this -> get('module');<BR>  !empty( $Module ) or $Module = 'index';<BR>  $NavUrl   = '/' . $Module . '/' . $Action . '/' . $this -> PageKey .'/';<BR>  $NaIndex  = '/' . $Module . '/' . $Action;<BR>  $PageHtml = "\n<div class="pagenav">";<BR>  $PageHtml .= '<span>' . $this->PageCount . '条记录        ' . $this->PageNo . '/' . $this->PageNum . '页</span>            ';<BR>  $this->PageNo 上一页\n";<BR> if ( $NumNav ) { $PageHtml .= $this->NumPage($NavUrl); }<BR> $this->PageNo >= $this->PageNum or $PageHtml .= "PageNo + 1) .  "\">下一页\nPageNum . "\">尾页\n";<BR> $PageHtml .= "

\n”;
return $PageHtml;
}

private function NumPage( $Can = ” ) { //数字分页
$NumHtml = ”;
$First = 1;
$Last = $this->PageNum;
if ( $this->PageNum > 5 ) {
if ( $this->PageNo PageNum ) {
$First = $this->PageNo – 2;
$Last = $this->PageNo + 2;
}else{
$First = $this->PageNo – 4;
$Last = $this->PageNum;
}
}
if ( $First < 1 ) { $First = 1; $Last = $First + 4;}
if ( $Last > $this->PageNum ) { $First = $this->PageNum – 4; $Last = $this->PageNum;}
for( $i = $First; $i <= $Last; $i++) {
$NumHtml .= $this->PageNo != $i ? “\n\t” . ” . $i . ” . “\n\t” : “\n\t” .” . $i . ” . “\n\t”;
}
unset($Can, $First, $i, $Last);
return $NumHtml;
}

public function UserPage($NumNav = false, $PageName = ‘index’, $Mulu = ‘user’ ) { //会员中心分页
$NavUrl = ‘/’ . $Mulu . ‘/’ . $PageName . ‘/’ . $this->PageKey . ‘/’;
$PageHtml = “\n

“;
$PageHtml .= ‘‘ . $this->PageCount . ‘条记录 ‘ . $this->PageNo . ‘/’ . $this->PageNum . ‘页 ‘;
$this->PageNo 上一页\n”;
if ( $NumNav ) { $PageHtml .= $this->NumPage($NavUrl); }
$this->PageNo >= $this->PageNum or $PageHtml .= “PageNo + 1) . “\”>下一页\nPageNum . “\”>尾页\n”;
$PageHtml .= “

\n”;
return $PageHtml;
}


//表单处理开始

//判断表单时候提交
public function FormIs( $Keys = ‘mm’ ) {
return $_POST[ $Keys ] == 1 ? true : false;
}

//post方式获取数据
public function _post( $Keys = ”, $TiHuan = ”) {
$Values = strip_tags( $_POST[ $Keys ] );
$this->FormArray[$Keys] = empty( $Values ) ? $TiHuan : $Values;
return empty( $Values ) ? $TiHuan : $Values;
}

//get方法获取数据
public function _get( $Keys = ”, $TiHuan = ”) {
$Values = strip_tags( $_GET[ $Keys ] );
return empty( $Values ) ? $TiHuan : $Values;
}

//判断是否为数字并且不小于0
public function IsNum( $Num = 0, $Mesg = ‘参数必须为数字’ ) {
if ( is_numeric( $Num ) && !empty( $Num ) && $Num >= 0 ) {
return $Num;
}else{
die( $Mesg );
}
}

//判断是否为数字并且不小于0返回True/False
public function NumBer( $Num = 0) {
return is_numeric( $Num ) && !empty( $Num ) && $Num >= 0 ? true : false;
}

//检测相关数据似乎存在
public function IsData($Types = true, $memg = ‘数据已经存在’ ){
$this->Connection(‘select ‘ . $this->Field . ‘ from ‘ . $this->Table . $this->Where);
if ( $Types ){
$this->Rest->num_rows > 0 ? die( $memg ) : null;
} else {
return $this->Rest->num_rows;
}
}


//写入数据库记录
public function into( $Mesg = ” ){
!is_array( $this->FormArray ) ? die( $Mesg ) : null;
$Sql = ‘insert into ‘ . $this->Table . ‘ (`’;
$I = 0;
foreach ( $this->FormArray as $Key => $Val ){
$Duan .= !$I ? $Key . ‘`’ : ‘, `’ . $Key . ‘`’;
if ( is_numeric( $Val ) ){
$Vals .= !$I ? $Val : ‘, ‘ . $Val;
}else{
$Vals .= !$I ? ‘\” . $Val . ‘\” : ‘, \” . $Val . ‘\”;
}
$I++;
}
$Sql .= $Duan . ‘) values (‘ . $Vals . ‘)’;

//@file_put_contents(‘1.sql’, $Sql, FILE_APPEND);

$this->Connection( $Sql );
return !empty( $this->Err ) ? false : true;
}

//数组形式写入数据
public function MsgBox( $Table = ”, $Filed = array() ) {
$this -> Table($Table);
foreach( $Filed as $Key => $Val ) {
$this -> FormArray[ $Key ] = $Val;
}
return $this -> Into(‘未取得数据’);
}

//修改数据库记录
public function Edit( $Array = array() ) {
if ( empty( $Array ) ) { $Array = $this -> FormArray; }
if ( !is_array( $Array ) || empty( $Array ) ) {
return false;
} else {
$Sql = ‘update ‘ . $this -> Table . ‘ set ‘;
$I = 0;
$Sub = ”;
$Huan = array(‘-‘ => ‘[jian]’, ‘+’ => ‘[jia]’, ‘*’ => ‘[cheng]’, ‘/’ => ‘[chu]’);
$Zhan = array(‘[jian]’ => ‘-‘, ‘[jia]’ => ‘+’, ‘[cheng]’ => ‘*’, ‘[chu]’ => ‘/’);

foreach ( $Array as $Files => $Val ) {
$Val = !is_numeric( $Val ) && !preg_match(‘/\`\w+\`\s*(\+|\-|\*|\/)/i’, $Val) ? ‘\” . $Val . ‘\” : $Val;
foreach ( $Huan as $key => $val ){
$Val = str_replace($key, $val, $Val);
}
$duan = !$I ? ‘`’ . $Files . ‘` = ‘ : ‘, `’ . $Files . ‘` = ‘;
$Sub .= $duan . $Val;
$I++;
}
$Sql .= $Sub . $this -> Where;
foreach ( $Zhan as $Fan => $Hui ) {
$Sql = str_replace($Fan, $Hui, $Sql);
}

//echo $Sql; die;

$this -> Connection( $Sql );
unset( $Array, $duan, $Fan, $Files, $Huan, $Hui, $I, $key, $Sql, $Sub, $Val, $Zhan, $val );
return !empty( $this -> Err ) ? false : true;
}
}

//删除数据库记录
public function del(){
$Sql = ‘delete from ‘ . $this->Table . $this->Where;
$this->Connection( $Sql );
unset($Sql);
return !empty( $this->Err ) ? false : true;
}

//表单处理结束

//页面跳转
public function Msg( $Text = ‘操作成功’ ) {
echo ‘<meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″ />’;
echo ‘<script type=”text/javascript”>
<!—ecms -ecms -ecms
alert(“‘ . $Text . ‘”);
document.location=”‘ . $_SERVER[‘HTTP_REFERER’] . ‘”;
//–>
</script>’;
exit;
}

#取得系统当前时间
public function Times(){
return str_replace(‘-‘, ‘[jian]’, date(‘Y-m-d H:i:s’));
}

#取得用户IP地址
public function GetIP(){
if (getenv(“HTTP_CLIENT_IP”) && strcasecmp(getenv(“HTTP_CLIENT_IP”), “unknown”))
$ip = getenv(“HTTP_CLIENT_IP”);
else if (getenv(“HTTP_X_FORWARDED_FOR”) && strcasecmp(getenv(“HTTP_X_FORWARDED_FOR”), “unknown”))
$ip = getenv(“HTTP_X_FORWARDED_FOR”);
else if (getenv(“REMOTE_ADDR”) && strcasecmp(getenv(“REMOTE_ADDR”), “unknown”))
$ip = getenv(“REMOTE_ADDR”);
else if (isset($_SERVER[‘REMOTE_ADDR’]) && $_SERVER[‘REMOTE_ADDR’] && strcasecmp($_SERVER[‘REMOTE_ADDR’], “unknown”))
$ip = $_SERVER[‘REMOTE_ADDR’];
else
$ip = “unknown”;
return($ip);
}


//最后关闭数据库连接
public function Close(){
!is_object( $this -> Conn ) or mysqli_close( $this -> Conn );
}

}

使用方法：
声明数据库对象
$Conn = new Mysql;
加载数据库参数
$Conn->Parameter(数据库服务器, 数据库用户名, 数据库密码, 数据库名称, 数据库编码, 数据库表前缀[可为空]);

上面的代码就已经加载这个类文件进来了，并且初始化了一些数据库连接参数！

下面介绍几个基本是方法函数：
1、 $Conn -> Table();
选择数据表，参数是数据表名称
2、$Conn -> Field();
选择的字段名称，多个用逗号隔开，如不调用这个方法，则返回全部
3、$Conn -> Where();
Sql Where子语句，根据条件筛选
4、$Conn -> Order();
Sql 排序
5、$Conn -> Page(int);
参数是一个正整数数字，如调用这个方法，记录将分页显示
6、$Conn -> Select(布尔值);
执行查询，返回查询结果，如果有，则是一个二维数组，如果无，则返回假，参数可省略，如省略，默认为真，返回的数组包含数字元素
7、$Conn -> Del();
删除记录
8、 $Conn -> Edit(array());
修改记录，参数是一个一维数组，数组键是字段名称，数组值是字段值
9、$Conn -> Into(array());
添加记录，参数是一个一维数组，数组键是字段名称，数组值是字段值。

以上方法可连续调用，比如：

$Rult = $Conn -> Table('user') -> Select(); //查询返回user表的所有记录<BR>$Rult = $Conn -> Table('user') -> Page(20) -> Select();//查询返回user表的所有记录，并分页显示，每页20条；<BR>
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]‍，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：php实现mysql数据库操作类分享_php实例

喜欢 (0)赏
[搞代码]
分享 (0)
发表我的评论
取消评论

表情 贴图 加粗 删除线 居中 斜体 签到

Hi，您需要填写昵称和邮箱！

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址