php连接access如何改为php连接mysql
<?php
//ACCESS执行类
class db{
var $db_path ;
//构造数据库路径
function dbpath($str)
{
$this->db_path=$str;
return $this->db_path;
}
//建立链接
function connect()
{
$db_link="DRIVER=Microsoft Access Driver (*.mdb);DBQ=".$this->db_path;
$db_result=odbc_connect($db_link,"","");
return $db_result;
}
//建立方法
function query($SQL)
{
$db_result=$this->connect();
$rs=odbc_exec($db_result,$SQL);
return $rs;
}
//断开链接
function db_close()
{
return odbc_close($this->connect());
}
}
//实例化类
$db = new db();
$db->dbpath($config["dbpath"]);
$db->charpage="GB2312";
?>
<?php
//ACCESS执行类
class db{
public $db_path ;
//构造数据库路径
function dbpath($db_path)
{
$this->db_path=$db_path;
return $this->db_path;
}
//建立链接
function connect()
{
$db_result=mysql_connect($this->db_path,"root","root");
return $db_result;
}
//建立方法
function query($SQL)
{
$rs=mysql_query($SQL,$this->connect());
return $rs;
}
//断开链接
function db_close()
{
return mysql_close($this->connect());
}
}
//实例化类
$db = new db();
$conn=$db->connect("localhost"轮橘);
mysql_select_db("核桐空database",$conn); //选择数据库,我默认了database
$rs=$db->query("set names gb2312");
?>
我测试成改瞎功了~
我做了一下修改~