PHP数据库助手类

最新推荐文章于 2023-09-25 20:42:27 发布

IT回忆录

最新推荐文章于 2023-09-25 20:42:27 发布

阅读量935

点赞数

分类专栏： PHP

本文链接：https://blog.csdn.net/vs2008ASPNET/article/details/8222984

版权

PHP 专栏收录该内容

3 篇文章 0 订阅

订阅专栏


<?php
 /*
  对数据库操作的助手类
  */

 class SqlHelper{
  
  private $conn;
  private $host="127.0.0.1";
  private $username="root";
  private $password="123";
  private $database="emp";
  /**
  * @return the $conn
  */
 public function getConn() {
  return $this->conn;
 }

  /**
  * @return the $host
  */
 public function getHost() {
  return $this->host;
 }

  /**
  * @return the $username
  */
 public function getUsername() {
  return $this->username;
 }

  /**
  * @return the $password
  */
 public function getPassword() {
  return $this->password;
 }

  /**
  * @return the $database
  */
 public function getDatabase() {
  return $this->database;
 }
 
 public function __construct(){
   $this->conn=new mysqli($this->host,$this->username,$this->password,$this->database);
   if(mysqli_connect_error()){
    die("数据库连接错误".$this->conn->error);
   }
  }
  
 //执行DQL语句
 public function Execute_DQL($sql){
   $arr=array();
   $res=$this->conn->query($sql);
   $i=0;
   while($row=$res->fetch_assoc()){
    $arr[$i++]=$row;
   }
   return $arr;
   $res->free_result();
  }
 public  function Execute_DQL_Array($sql){
  $arr=array();
  $res=$this->conn->query($sql);
  $i=0;
  while($row=$res->fetch_array()){
   $arr[$i++]=$row;
  }
  return $arr;
  $res->free_result();
 }
  
 //关闭连接
 public function Close(){
   $this->conn->close();
  }
  
 //执行DML语句
 public function Execute_DML($sql){
   $this->conn->query($sql);
   echo $this->conn->affected_rows;
 }
  
 }
?>