<?php
/*
 * my database Class 
 * by lijg 20181030
 */
define('DBHOST', '119.45.116.199');
define('DBUSER', 'mfdb');
define('DBPWD', 'LYDBSK.159260.HH');
define('DBNAME', 'mfdb');
define('PORT', '3306');

class MdbLib{
    public function __construct(){
        $this->link = mysqli_connect(DBHOST, DBUSER, DBPWD, DBNAME, PORT);
        mysqli_set_charset($this->link, 'UTF8');
    }
    
    public function querySql($sql = ''){
        if(empty($sql)){
            return false;
        }
        return mysqli_query($this->link, $sql);
    }
    
    public function queryNum($query){
        if(empty($query)){
            return false;
        }
        return mysqli_num_rows($query);
    }
    
    public function queryRs($query){
        if(empty($query)){
            return false;
        }
        return mysqli_fetch_array($query);
    }
    
    public function queryRsAll($query){
        if(empty($query)){
            return false;
        }
        $rs = array();
        while($row = mysqli_fetch_assoc($query)){
            $rs[] = $row;
        }
        return $rs;
    }
    
    public function queryError(){
        return mysqli_error($this->link);
    }
    
    public function queryErrno(){
        return mysqli_errno($this->link);
    }
    
	public function queryNid(){
        return mysqli_insert_id($this->link);
    }
	
    public function queryAR(){
        return mysqli_affected_rows($this->link);
    }
    
    public function begin(){
        return mysqli_begin_transaction($this->link);
    }
    
    public function commit(){
        return mysqli_commit($this->link);
    }
    
    public function __destruct(){
        //TODO
    }
}