自MYSQL 4.1起,MYSQL新的时代到来的前夜,数据库存取过程发生了一个小小的变化。致使好多人在存取过程中出现了乱码数据的现象。加之,读写数据库已经是PHP编写网页的一个重要的过程。故此,将其小小打成一个类,方日后的使用。
mysql.php
----------------------------------------------------------------------
<?php
class imysql{
/*
class name:imysql
author:yagas
email:yagas@iebsoft.com
site:http://www.iebsoft.com
*/
var $db;
//初始化并打开数据库
function imysql($mysql){
$this->db = mysql_connect($mysql['host'], $mysql['user'], $mysql['password']);
if(!$this->db){
echo mysql_error();
exit;
}
mysql_select_db($mysql['database'], $this->db);
@mysql_query("set names '".$mysql['charset']."'", $this->db);//对mysql4.0以上版本设置读写编码
}
//关闭数据库,并释放资源
function free(){
mysql_close($this->db);
$this->db = NULL;
}
//执行SQL命令
function runSQL($SQL, $assoc='1'){
$result = mysql_query($SQL);
if((int)$assoc == 1){
$result = mysql_fetch_assoc($result);
}
return $result;
}
}
?>
class imysql{
/*
class name:imysql
author:yagas
email:yagas@iebsoft.com
site:http://www.iebsoft.com
*/
var $db;
//初始化并打开数据库
function imysql($mysql){
$this->db = mysql_connect($mysql['host'], $mysql['user'], $mysql['password']);
if(!$this->db){
echo mysql_error();
exit;
}
mysql_select_db($mysql['database'], $this->db);
@mysql_query("set names '".$mysql['charset']."'", $this->db);//对mysql4.0以上版本设置读写编码
}
//关闭数据库,并释放资源
function free(){
mysql_close($this->db);
$this->db = NULL;
}
//执行SQL命令
function runSQL($SQL, $assoc='1'){
$result = mysql_query($SQL);
if((int)$assoc == 1){
$result = mysql_fetch_assoc($result);
}
return $result;
}
}
?>
使用方法如下:
config_inc.php
-------------------------------------------------------------------------
<?php
$mysql = array("host"=>"localhost",
"user"=>"root",
"password"=>"",
"database"=>"db_21cnci",
"charset"=>"latin1"
);
$mysql = array("host"=>"localhost",
"user"=>"root",
"password"=>"",
"database"=>"db_21cnci",
"charset"=>"latin1"
);
?>
include.php
-------------------------------------------------------------------------
<?php
require_once('config_inc.php');
require_once('mysql.php');
?>
index.php
-------------------------------------------------------------------------
<?php
require_once('include.php');
$db = new imysql($mysql);
$l = $db->runSQL("SELECT * FROM `cnci_admin_group` where `gid`='1'");
echo $l['groupName'];
$db->free();
$db = NULL;
$l = $db->runSQL("SELECT * FROM `cnci_admin_group` where `gid`='1'");
echo $l['groupName'];
$db->free();
$db = NULL;
?>