数据库连接和定义

class 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);                        //允许上传的图片的最大字节数
?>

 

转载于:https://www.cnblogs.com/mengluo/p/4790148.html