这是一个数据库链接类,为了简化操作和方便模板分离设计的!
class
mysql
{
function mysql ( $server , $username , $password , $db ) {
if ( $this -> conn = @ mysql_connect ( $server , $username , $password ) or die ( " 数据库连接错误 " ));
if ( mysql_select_db ( $db , $this -> conn) or die ( " 数据库名错误 " ));
}
function sql ( $sql ) {
mysql_query ( " set names utf-8 " , $this -> conn);
if ( $rrs = mysql_query ( $sql , $this -> conn) or die ( " SQL语句失败 " ));
while (@ $rs = mysql_fetch_array ( $rrs , MYSQL_ASSOC)) {
$rs_r [] = $rs ;
}
return $rs_r ;
}
function getlist( $db , $p = "" ){
foreach ( $db as $key => $dba ){
eval ( " global $ " . $p . " $key; " );
eval ( " $ " . $p . " $key=$dba; " );
}
}
}
function mysql ( $server , $username , $password , $db ) {
if ( $this -> conn = @ mysql_connect ( $server , $username , $password ) or die ( " 数据库连接错误 " ));
if ( mysql_select_db ( $db , $this -> conn) or die ( " 数据库名错误 " ));
}
function sql ( $sql ) {
mysql_query ( " set names utf-8 " , $this -> conn);
if ( $rrs = mysql_query ( $sql , $this -> conn) or die ( " SQL语句失败 " ));
while (@ $rs = mysql_fetch_array ( $rrs , MYSQL_ASSOC)) {
$rs_r [] = $rs ;
}
return $rs_r ;
}
function getlist( $db , $p = "" ){
foreach ( $db as $key => $dba ){
eval ( " global $ " . $p . " $key; " );
eval ( " $ " . $p . " $key=$dba; " );
}
}
}
比如有一个数据库,服务器名localhost 用户名fzzwake 密码 123 数据库名 test
下面就给个简单的用法示例
$sql
=
new
sql(
"
localhost
"
,
"
fzzwake
"
,
"
123
"
,
"
test
"
);
$rs = $sql -> sql( " select * from tb " );
foreach ($rs as $rs_r) ... {
$sql->getlist($rs_r,"p_");//第二个参数是变量名前缀,为了防止与已有的其他变量名相冲突
echo $p_id;
/**//*
p_为函数名前缀,id为字段名,这样就可以直接引用字段名相关的变量了!变量是可以直接在
echo <<<
$p_id
eot;
这样的格式里直接引用,这对于模板分离,将十分方便
*/
echo $p_username;
}
$rs = $sql -> sql( " select * from tb " );
foreach ($rs as $rs_r) ... {
$sql->getlist($rs_r,"p_");//第二个参数是变量名前缀,为了防止与已有的其他变量名相冲突
echo $p_id;
/**//*
p_为函数名前缀,id为字段名,这样就可以直接引用字段名相关的变量了!变量是可以直接在
echo <<<
$p_id
eot;
这样的格式里直接引用,这对于模板分离,将十分方便
*/
echo $p_username;
}
这个类支持初始化多次,能同时链接多个数据库哦!