数据库连接和定义

opmysqli{ private $host = ‘127.0.0.1‘; //服务器地址 private $name = ‘root‘; //登录账号 private $pwd = ‘111‘; //登录密码 private $dBase = ‘db_blog‘; //数据库名称 private $conn = ‘‘; //数据库链接资源 private $result = ‘‘; //结果集 private $msg = ‘‘; //返回结果 private $fields; //返回字段 private $fieldsNum = 0; //返回字段数 private $rowsNum = 0; //返回结果数 private $filesArray = array(); //返回字段数组 private $rowsArray = array(); //返回结果数组 //初始化类 function __construct($host=‘‘,$name=‘‘,$pwd=‘‘,$dBase=‘‘){ if($host != ‘‘) $this->host = $host; if($name != ‘‘) $this->name = $name; if($pwd != ‘‘) $this->pwd = $pwd; if($dBase != ‘‘) $this->dBase = $dBase; $this->init_conn(); } //链接数据库 function init_conn(){ $this->conn=mysqli_connect($this->host,$this->name,$this->pwd,$this->dBase); mysqli_query($this->conn,"set names gb2312"); } //查询结果 function mysqli_query_rst($sql){ if($this->conn == ‘‘){ $this->init_conn(); } $this->result = @mysqli_query($this->conn,$sql); } //取得字段数 function getFieldsNum($sql){ $this->mysqli_query_rst($sql); $this->fieldsNum = @mysqli_num_fields($this->result); } //取得查询结果数 function getRowsNum($sql){ $this->mysqli_query_rst($sql); $this->rowsNum = @mysqli_num_rows($this->result); return $this->rowsNum; } //取得记录数组（多条记录） function getRowsArray($sql){ $this->mysqli_query_rst($sql); while($row = mysqli_fetch_array($this->result,MYSQLI_ASSOC)) { $this->rowsArray[] = $row; } return $this->rowsArray; } //更新、删除、添加记录数 function uidRst($sql){ if($this->conn == ‘‘){ $this->init_conn(); } @mysqli_query($this->conn,$sql); $this->rowsNum = @mysqli_affected_rows($this->conn); return $this->rowsNum; } //获取对应的字段值 function getFields($sql,$fields){ $this->mysqli_query_rst($sql); if(mysqli_num_rows($this->result) > 0){ $tmpfld = mysqli_fetch_row($this->result); $this->fields = $tmpfld[$fields]; } return $this->fields; } //错误信息 function msg_error(){ if(mysqli_errno() != 0) { $this->msg = mysqli_error(); } return $this->msg; } //释放结果集 function close_rst(){ //mysqli_free_result($this->result); $this->msg = ‘‘; $this->fieldsNum = 0; $this->rowsNum = 0; $this->filesArray = ‘‘; $this->rowsArray = ‘‘; } //关闭数据库 function close_conn(){ $this->close_rst(); mysqli_close($this->conn); $this->conn = ‘‘; } } $conne = new opmysqli(); ?>

<?php
    define(‘PATH‘,$_SERVER[‘DOCUMENT_ROOT‘]);                //服务器目录
    define(‘ROOT‘,‘/TM/06/‘);                            //博客目录
    define(‘ADMIN‘,‘admin/‘);                                //后台目录
    define(‘PIC‘,‘center/pics/image/‘);                                    //上传图片目录
    define(‘BAK‘,‘sqlbak/‘);                                //备份目录
    define(‘HEADGIF‘,‘headgif/‘);                            //头像目录
    define(‘mysqliPATH‘,‘C:\\AppServ\\MySQL\\bin\\‘);            //mysqli执行文件路径
    define(‘mysqliHOST‘,‘localhost‘);                        //mysqli服务器ip
    define(‘mysqliDATA‘,‘db_blog‘);                            //mysqli数据库
    define(‘mysqliUSER‘,‘root‘);                                //mysqli账号
    define(‘mysqliPWD‘,‘111‘);                                //mysqli密码
    $picpostfix = array(‘image/gif‘,‘image/pjpeg‘,‘image/bmp‘);    //允许上传的图片后缀
    define(‘MAXSIZEPIC‘,500000);                        //允许上传的图片的最大字节数
?>

 

数据库连接和定义

标签：