当前位置：Gxlcms > 数据库问题 > php数据库操作

php数据库操作

时间：2021-07-01 10:21:17 帮助过：32人阅读

* Time: 16:43
*/

/**
* 数据库连接
* Class Mysql
*/
class Mysql{
private $mysql_server_name=‘localhost‘;
private $mysql_username=‘root‘;
private $mysql_password=‘‘;
private $mysql_database=‘webmap‘;
private $mysql_charset=‘utf8‘;
private $mysqli;

function __construct(){
$this->connect();
}
function __destruct(){
$this->close();
// echo ‘数据成功关闭‘;
}

/**
* sql连接
*/
function connect(){
$this->mysqli=new mysqli($this->mysql_server_name,$this->mysql_username,
$this->mysql_password,$this->mysql_database);
//检查连接是否成功
if (mysqli_connect_errno()){
//注意mysqli_connect_error()新特性
die(‘Unable to connect!‘. mysqli_connect_errno().":".mysqli_connect_error());
}
if (!$this->mysqli->set_charset($this->mysql_charset)) {
printf("Error loading character set utf8: %s\n", $this->mysqli->error);
} else {
$this->mysqli->character_set_name();
}
// echo "成功！";
// return $this->mysqli;
}

function insert($table,$array){
    $keys=join(",",array_keys($array));
    $vals="‘".join("‘,‘",array_values($array))."‘";
    $sql="insert $table ($keys) values({$vals})";
    mysqli_query($this->mysqli, $sql);
    return mysqli_insert_id($this->mysqli);
}

function update($table,$array,$where=null){
    $str=‘‘;
    foreach($array as $key=>$val){
        if($str==null){
            $sep="";
        }else{
            $sep=",";
        }
        $str.=$sep.$key."=‘".$val."‘";
    }
    $sql="update $table set $str".($where==null?null:" where ".$where);
    $result=mysqli_query($this->mysqli,$sql);
    //var_dump($result);
    //var_dump(mysql_affected_rows());exit;
    if($result){
        return mysqli_affected_rows($this->mysqli);
    }else{
        return false;
    }
}


function delete($table,$where=null){
    $where=$where==null?null:" where ".$where;
    $sql="delete from $table $where";
    mysqli_query($this->mysqli,$sql);
    return mysqli_affected_rows($this->mysqli);
}


function fetchOne($sql,$result_type=MYSQLI_ASSOC){
    $result=mysqli_query($this->mysqli,$sql);
    $row=mysqli_fetch_array($result,$result_type);
    return $row;
}


function fetchAll($sql,$result_type=MYSQLI_ASSOC){
    $result=mysqli_query($this->mysqli,$sql);
    $rows=[];
    while(@$row=mysqli_fetch_array($result,$result_type)){
        $rows[]=$row;
    }
    return $rows;
}

function getResultNum($sql){
        $result=mysqli_query($this->mysqli,$sql);
        return mysqli_num_rows($result);
    }


    function getInsertId(){
        return mysqli_insert_id($this->mysqli);
    }

    function close(){
        mysqli_close($this->mysqli);
    }

}


/**
 * 此class一些操作
 */

//数据库操作示例
//$test=new Mysql();
//$res=$test->insert("admins",[‘admins_name‘=>‘ccc‘,‘admins_pass‘=>md5(‘ccc‘)]);
//$res=$test->update("admins",[‘admins_name‘=>‘king‘,‘admins_pass‘=>md5(‘king‘)],"admins_id=2");
//$res = $test->delete("admins", "admins_name=‘ccc‘");
/*$res=$test->fetchAll("select * from admins");
var_dump($res);
echo count($res);*/
//echo $test->getResultNum("select * from admins where admins_name=‘ccc‘");

php数据库操作

标签：

php数据库操作

人气教程排行