搜索

首页 >后端开发 >php教程 >分享一个自己写的php操作mysql数据库的类

分享一个自己写的php操作mysql数据库的类

WBOY
WBOY原创
2016-07-25 08:48:56907浏览
这是我自己写的一个类，欢迎大家讨论指导
部分使用方法：
//声明数据库对象
$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表的所有记录
$Rult = $Conn -> Table('user') -> Page(20) -> Select();//查询返回user表的所有记录，并分页显示，每页20条；

还有很多方法调用和诀窍，以后有空再慢慢细说！
  1. /*
  3. 数据库操作类
  4. 操作方式：面对对象
  5. 制作时间：2013-3-10
  6. 当前版本：BqhMysql(mysqli)1.0.1
  7. 软件作者：伤心的歌
  8. 联系QQ ：36975
  9. 联系电话：18907975647
  10. 电子邮件：admin@q128.com
  11. 联系地址：江西省赣州市石城县小松镇
  12. 邮政编码：342706
  14. */
  15. class Mysql{
  16. private $LocalHost = 'localhost';
  17. private $LoaclUser = 'root';
  18. private $LocalPass = '123456';
  19. private $LocalBase = 'jiangxibaiyi';
  20. private $LocalCode = 'UTF8';
  21. private $PreFix;
  22. private $Conn;
  23. private $Start = 0;
  24. private $Error = false; //数据库连接状态, false表示未连接或连接不正常
  25. public $Err = true; //Sql执行结果
  27. private $Table;
  28. private $Field = '*';
  29. private $Where = '';
  30. private $Order = '';
  32. private $PageSize = 0; //分页显示->每页多少条，0为不分页显示
  33. private $PageCount = 1; //分页显示->总共有多少条
  34. private $PageNum = 1; //分页显示->总共有多少页
  35. private $PageNo = 1; //分页显示->当前第几页
  36. private $PageKey = 'page'; //分页url参数键
  37. private $PageStart = 0; //分页显示->当前从第几条开始返回
  40. private $Select;
  41. private $Rest;
  43. private $Result = false;//结果集
  45. public $FormArray = array();
  47. public $Instr_ID = 0;
  48. private $j = 0;
  51. public function Parameter($Loca, $Root, $Pass, $Base, $Code, $PreFix = ''){
  52. $this->LoaclUser = $Root;
  53. $this->LocalBase = $Base;
  54. $this->LocalCode = $Code;
  55. $this->LocalHost = $Loca;
  56. $this->LocalPass = $Pass;
  57. $this->PreFix = $PreFix;
  58. return $this;
  59. }
  60. private function Connection( $Sql ){
  61. !function_exists(mysqli_connect) ? die('查询失败，无法加载mysqli扩展') : null;
  62. $this->Conn = @new mysqli( $this->LocalHost, $this->LoaclUser, $this->LocalPass, $this->LocalBase);
  63. $this->Error = mysqli_connect_errno() == 0 ? true : false;
  64. !$this->Error ? die('数据库连接错误，请检查数据库连接参数') : null;
  65. $this->Conn->query('SET NAMES ' . $this->LocalCode);
  66. $this->Rest = $this->Conn->query($Sql);
  67. $this->Err = mysqli_error($this->Conn);
  68. $this->Instr_ID = mysqli_insert_id($this->Conn);
  69. $this->Rest->free_result;
  70. $this->Conn->close;
  71. $this -> FormArray = '';
  72. return $this;
  73. }
  75. public function null(){
  76. $this->PageSize = 0;
  77. //$this->PageCount = 1;
  78. $this->PageStart = 1;
  79. $this->Field = ' * ';
  80. $this->Select = '';
  81. unset($this->Table, $this->Where,$this->Order, $this->Result);
  82. }
  84. public function Table( $TableName ) {//数据表
  85. $this -> null();
  86. $this->Table = '`' . $this->PreFix . $TableName . '`';
  87. return $this;
  88. }
  90. public function Field( $Array = '*' ) {//数据字段
  91. !empty( $this->Field ) ? $this->Field = '' : null;
  92. $Array = explode(',', $Array);
  93. foreach ( $Array as $field ) {
  94. $this->Field .= !$this->Start ? '`' . $field . '`' : ', `' . $field . '`';
  95. $this->Start++;
  96. }
  97. $this->Start = 0;
  98. return $this;
  99. }
  101. public function Where( $Where ) {//条件
  102. $this->Where = ' where ' .$Where;
  103. return $this;
  104. }
  106. public function Order( $Order ) {//排序
  107. $this->Order = ' order by ' . $Order;
  108. return $this;
  109. }
  111. public function pk( $key ) {//分页url参数键
  112. $this->PageKey = $key;
  113. return $this;
  114. }
  116. public function Page( $PageSize ) {//分页
  117. $this->PageSize = $PageSize;
  118. $this->PageNo = $this->get( $this->PageKey );
  119. $this->PageNo = empty( $this->PageNo ) || !isset( $this->PageNo ) || !is_numeric( $this->PageNo ) || $this->PageNo PageNo;
  120. return $this;
  121. }
  123. public function post( $Key, $Filter = true ){
  124. return $Filter ? strip_tags($_POST[$Key]) : $_POST[$Key];
  125. }
  127. public function get( $Key, $Filter = true ){
  128. return $Filter ? strip_tags($_GET[$Key]) : $_GET[$Key];
  129. }
  131. public function Sel(){
  132. $this->Select = 'Select ' . $this->Field . ' from ' . $this->Table . $this->Where . $this->Order;
  133. $this->Connection( $this->Select );
  134. if ( $this->Rest->num_rows ) {
  135. while ( $Rs = $this->Rest->fetch_assoc() ) {
  136. $this->Result[] = $Rs;
  137. }
  138. }
  139. $DataBase = $this->Result;
  140. return empty($DataBase) ? false : $DataBase;
  141. }
  143. public function querys( $Sql = '', $Type = 'not', $biao = false ) {
  144. $this->Select = $Sql;
  145. $this->Connection( $this->Select );
  146. if ( $this->Rest->num_rows ) {
  147. if ( !$biao ) {
  148. while ( $Rs = $this->Rest->fetch_array() ) {
  149. $this->Result[] = !preg_match('/^\d+$/i', $Type) ? $Rs : $Rs[ $Type ];
  150. }
  151. } else {
  152. while ( $Rs = $this->Rest->fetch_assoc() ) {
  153. $this->Result[] = $Rs;
  154. }
  155. }
  156. }
  157. $DataBase = $this->Result;
  158. return empty($DataBase) ? false : $DataBase;
  160. }
  162. public function executes( $Sql = '' ){
  163. $this->Connection( $Sql );
  164. return $this->Rest;
  165. }
  168. public function exists( $T = '', $F = '', $W = ''){
  169. if ( empty( $F ) ) { return 0; }
  170. $cmd = empty( $W ) ? 'Select sum(' . $F . ') as `baiyinum` from `' . $this->PreFix . $T .'`' : 'Select sum(' . $F . ') as `baiyinum` from `' . $this->PreFix . $T .'` Where ' . $W;
  171. $this->Connection( $cmd );
  172. unset( $T, $F, $W, $cmd );
  173. $Rel = $this->Rest->fetch_array();
  174. return round( $Rel['baiyinum'], 2 );
  175. }
  178. public function ExistsTo( $Bili = 10000, $T = '', $F = '', $W = ''){
  179. if ( empty( $F ) ) { return 0; }
  180. $cmd = empty( $W ) ? 'Select sum(' . $F . ') as `baiyinum` from `' . $this->PreFix . $T .'`' : 'Select sum(' . $F . ') as `baiyinum` from `' . $this->PreFix . $T .'` Where ' . $W;
  181. $this->Connection( $cmd );
  182. unset( $T, $F, $W, $cmd );
  183. $Rel = $this->Rest->fetch_array();
  184. return round( $Rel['baiyinum'] * $Bili );
  185. }
  188. public function Select( $Type = true, $ListNum = 1 ){ //返回记录（数组形式， 返回条数）
  189. $this->Select = 'Select ' . $this->Field . ' from ' . $this->Table . $this->Where . $this->Order;
  190. if ( is_numeric( $ListNum ) ) {
  191. if ( $this->PageSize > 0 ) {
  192. $this->Connection( $this->Select );//执行查询
  193. $this->PageCount = $this->Rest->num_rows;//取得记录总数
  194. $this->PageNum = ceil($this->PageCount / $this->PageSize); //总共有多少页
  195. $this->PageNo = $this->PageNo > $this->PageNum ? $this->PageNum : $this->PageNo;
  196. $this->PageStart = ( $this->PageNo - 1 ) * $this->PageSize; //当前从第几条开始返回
  197. $this->Select .= ' limit ' . $this->PageStart . ', ' .$this->PageSize; //重新构造sql语句
  198. } else {
  199. $this->Select .= ' limit ' . $ListNum; //重新构造sql语句
  200. }
  201. } else {
  202. $this->Select .= ' limit 1'; //重新构造sql语句
  203. }
  204. //echo $this->Select;
  205. $this->Connection( $this->Select );//再次执行查询
  206. if ( $this->Rest->num_rows ) {//如果记录存在
  207. if ( $Type ) {
  208. while ( $Rs = $this->Rest->fetch_array() ) {
  209. $this->Result[] = $Rs;
  210. }
  211. }else{
  212. while ( $Rs = $this->Rest->fetch_assoc() ) {
  213. $this->Result[] = $Rs;
  214. }
  215. }
  216. }
  217. if ( ( $ListNum == 1 or !is_numeric( $ListNum ) ) && !$this->PageSize) { $this->Result = $this->Result[0]; }
  218. $DataBase = $this->Result;
  219. return empty($DataBase) ? false : $DataBase;
  220. }
  222. public function Num() { //返回记录总数
  223. $this->Select = 'Select ' . $this->Field . ' from ' . $this->Table . $this->Where . $this->Order;
  224. $this->Connection( $this->Select );//执行查询
  225. return $this->Rest->num_rows;//取得记录总数
  226. }
  228. public function PageNav($NumNav = false ) { //分页
  229. $Action = $this -> get('action');
  230. !empty( $Action ) or $Action = 'index';
  231. $Module = $this -> get('module');
  232. !empty( $Module ) or $Module = 'index';
  233. $NavUrl = '/' . $Module . '/' . $Action . '/' . $this -> PageKey .'/';
  234. $NaIndex = '/' . $Module . '/' . $Action;
  235. $PageHtml = "\n
    ";
  236. $PageHtml .= '' . $this->PageCount . '条记录 ' . $this->PageNo . '/' . $this->PageNum . '页 ';
  237. $this->PageNo 首页\nPageNo - 1) . "\">上一页\n";
  238. if ( $NumNav ) { $PageHtml .= $this->NumPage($NavUrl); }
  239. $this->PageNo >= $this->PageNum or $PageHtml .= "PageNo + 1) . "\">下一页\nPageNum . "\">尾页\n";
  240. $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 if ( $Last > $this->PageNum ) { $First = $this->PageNum - 4; $Last = $this->PageNum;}
  • for( $i = $First; $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 首页\nPageNo - 1) . "\">上一页\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 '';
  • echo '';
  • 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 );
  • }
  • }
    • 复制代码


    声明：
    本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn
    上一篇：趁着我们还年轻 下一篇：简单中文验证码

    相关文章

    查看更多