这是我写的PHP连接MYSQL的类,
可是现在要用ACCESS了,
那位大侠能帮我改下,改成连接ACCESS的啊???
我不会连接ACCESS啊....
求救...
<?php
class mysql{ private $host;
private $name;
private $pass;
private $table;
private $ut; function __construct($host,$name,$pass,$table,$ut){
$this->host=$host;
$this->name=$name;
$this->pass=$pass;
$this->table=$table;
$this->ut=$ut;
$this->connect(); }
function connect(){ $link=mysql_connect($this->host,$this->name,$this->pass) or die ($this->error());
mysql_select_db($this->table,$link) or die("没该数据库:".$this->table);
mysql_query("SET NAMES '$this->ut'"); } function query($sql, $type = '') {
if(!($query = mysql_query($sql))) $this->show('Say:', $sql);
return $query;
} function show($message = '', $sql = '') {
if(!$sql) echo $message;
else echo $message.'<br>'.$sql;
} function affected_rows() {
return mysql_affected_rows();
} function result($query, $row) {
return mysql_result($query, $row);
} function num_rows($query) {
return mysql_num_rows($query);
} function num_fields($query) {
return mysql_num_fields($query);
}
function fetch_row($query) {
return mysql_fetch_row($query);
}
function fetch_asso($query){
return mysql_fetch_assoc($query);
}
function fetch_field($query){
return mysql_fetch_field($query);
} function free_result($query) {
return mysql_free_result($query);
}
function fetch_array($query) { return mysql_fetch_array($query);
} function insert_id() {
return mysql_insert_id();
}
function version() {
return mysql_get_server_info();
}
function data_seek($query,$s){
return mysql_data_seek($query,$s);
} function close() {
return mysql_close();
} } function htmtocode($content) {
$content = str_replace("\n", "<br>", str_replace(" ", " ", $content));
return $content;
}
$db = new mysql('localhost','root','','jiankun',"gb2312");
?>
可是现在要用ACCESS了,
那位大侠能帮我改下,改成连接ACCESS的啊???
我不会连接ACCESS啊....
求救...
<?php
class mysql{ private $host;
private $name;
private $pass;
private $table;
private $ut; function __construct($host,$name,$pass,$table,$ut){
$this->host=$host;
$this->name=$name;
$this->pass=$pass;
$this->table=$table;
$this->ut=$ut;
$this->connect(); }
function connect(){ $link=mysql_connect($this->host,$this->name,$this->pass) or die ($this->error());
mysql_select_db($this->table,$link) or die("没该数据库:".$this->table);
mysql_query("SET NAMES '$this->ut'"); } function query($sql, $type = '') {
if(!($query = mysql_query($sql))) $this->show('Say:', $sql);
return $query;
} function show($message = '', $sql = '') {
if(!$sql) echo $message;
else echo $message.'<br>'.$sql;
} function affected_rows() {
return mysql_affected_rows();
} function result($query, $row) {
return mysql_result($query, $row);
} function num_rows($query) {
return mysql_num_rows($query);
} function num_fields($query) {
return mysql_num_fields($query);
}
function fetch_row($query) {
return mysql_fetch_row($query);
}
function fetch_asso($query){
return mysql_fetch_assoc($query);
}
function fetch_field($query){
return mysql_fetch_field($query);
} function free_result($query) {
return mysql_free_result($query);
}
function fetch_array($query) { return mysql_fetch_array($query);
} function insert_id() {
return mysql_insert_id();
}
function version() {
return mysql_get_server_info();
}
function data_seek($query,$s){
return mysql_data_seek($query,$s);
} function close() {
return mysql_close();
} } function htmtocode($content) {
$content = str_replace("\n", "<br>", str_replace(" ", " ", $content));
return $content;
}
$db = new mysql('localhost','root','','jiankun',"gb2312");
?>
现在要用,不会搞,
百度了,搞不懂...