php 连接mysql数据库类

来源：互联网发布：美国知乎quora 编辑：程序博客网时间：2024/05/29 09:16

<?php class Mysql{  private $host; //链接那个数据库是本地的还是其他的  private $user;  //用户名  private $password;  //密码  private $dbname;  //数据库  private $conn; //链接数据库  private $result;  //查询的结果  private $array=array();  //把查询的结果放到数组里面，自己看这写，需要的就用不需要的就不写    function __construct($host,$user,$password,$dbname){   $this->host=$host;   $this->user=$user;   $this->password=$password;   $this->dbname=$dbname;   $this->db_connect();     }    public  function db_connect(){   $this->conn=mysql_connect($this->host,$this->user,$this->password) or die("Could not Connect MySql Server");   mysql_query("SET NAMES 'gb2312'");   mysql_select_db($this->dbname,$this->conn);  }    public function get_result($sql){   $this->result=mysql_query($sql,$this->conn);   return $this->result;  }    public function get_array($sql){   $this->result=mysql_query($sql,$this->conn);      while($row=mysql_fetch_array($this->result)){    $this->array[]=$row;   }   return $this->array;  } } ?>

调用：

<?php

require_once('mysql.php');

$mysql=new Mysql("localhost:3306","root","111000",'test');

$sql = "inser into tbl_nam (id,no,name,) values (1，1，1)";
$result=$mysql->get_array(" $sql");

print_r($result);

0 0