php 数据库连接控制类

connect.php

<?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;
  }
 }
 ?>

index.php

<?php
 require_once('connect.php');
 
 $mysql=new Mysql("localhost:3306","root","root",'test');
 
 
 $result=$mysql->get_result("select * from table1");
 while($row=mysql_fetch_array($result)){
  echo $row["id"] . " ".$row["name"] ."<br/>";
 }
 $result=$mysql->get_result("insert into table1(name) values('zxl');");
 echo "insert into ok!";
 ?>