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!";
?>
