----------phpdebug----------
Server=localhost;DataBase=mysql;UserID=root;PassWord=123456
resource(5)oftype(mysqlresult)

Outputcompleted(1secconsumed)-NormalTermination

<?php
classDBCLS
{

//debug调试开关
var$debug=true;

//debuginfo错误信息，调试信息
var$debuginfo="debuginformations:\r\n";

//db_serverMySQL主机地址
var$db_server;

//db_name数据库名
var$db_name;

//db_user数据库用户名
var$db_user;

//db_passwd密码
var$db_passwd;

//db_links数据库连接
var$db_link;

//db_query_sqlSQL语句
var$db_query_sql="showtables";

//db_recordset结果集，记录集
var$db_recordset;

//ready就绪开关
var$conntstr_ready=false;
var$link_ready=false;
var$db_ready=false;

//setorreturnConnectionString返回，或者设定连接字符串
functionconnection_string($connstr="")
{
if(""==$connstr)
{
//如果没有参数传入，返回已有的连接字符
return"Server=".$this->db_server.";DataBase=".$this->db_name.";UserID=".$this->db_user.";PassWord=".$this->db_passwd;
}
else
{
//否则，解析连接字符，初始化变量
preg_match_all("|([a-zA-Z0-9]*)=([a-zA-Z0-9]*);*|",$connstr,$tmparr,PREG_PATTERN_ORDER);
$this->db_server=(strtolower($tmparr[1][0])=="server")?$tmparr[2][0]:"";
$this->db_name=(strtolower($tmparr[1][1])=="database")?$tmparr[2][1]:"";
$this->db_user=(strtolower($tmparr[1][2])=="userid")?$tmparr[2][2]:"";
$this->db_passwd=(strtolower($tmparr[1][3])=="password")?$tmparr[2][3]:"";
//var_dump($tmparr);

if(""==$this->db_serveror""==$this->db_nameor""==$this->db_useror""==$this->db_passwd)
$this->conntstr_ready=false;//如果有其中一个以上变量被赋以空字符串"",准备未就绪
else
$this->conntstr_ready=true;
return$this->conntstr_ready;
}

}

//连接数据库，返回连接对象
functionconnect()
{
if(!$this->conntstr_ready)
{
if($this->debug){$this->debuginfo.="连接字符串无效！\r\n";}
return$this->link_ready;
}
if($this->db_link=@mysql_connect($this->db_server,$this->db_user,$this->db_passwd))
{
$this->link_ready=true;
return$this->link_ready;
}
}

//选择数据库
functionselect($db="")
{
if(!$this->db_link)
{
if($this->debug){$this->debuginfo.="没有可用的数据库连接！\r\n";}
$this->db_ready=false;
}
if(""==$db)
{
if(mysql_select_db($this->db_name))
$this->db_ready=true;
}
if(mysql_select_db($this->db_name=$db))
$this->db_ready=true;
return$this->db_ready;
}

//执行查询
functionexecute($SQL="")
{
if(""!=$SQL)
{
$this->db_query_sql=$SQL;
//if($this->debug){$this->debuginfo.="SQLisnull!\r\n";}
//returnfalse;
}
if(""==$this->db_query_sql)
{
if($this->debug){$this->debuginfo.="SQLisnull!\r\n";}
returnfalse;
}
$this->db_recordset=mysql_query($this->db_query_sql);
returntrue;
}
}

$dbmy=newDBCLS();//创建一个DBCLS对象
if(!$dbmy->connection_string("Server=localhost;DataBase=mysql;UserID=root;PassWord=123456"))//初始化DBCLS对象dbmy

print$dbmy->debuginfo;//初始化失败，输出错误信息

else

print$dbmy->connection_string();//初始化成功，输出连接字符串
print"\r\n";

if(!($dbmy->connect())or!($dbmy->select()))//如果连接数据库，或者选择数据库失败
print$dbmy->debuginfo;//输出出错信息
//$dbmy->db_query_sql="select*fromuser";
if($dbmy->execute())//执行查询指令
{//如果不出错
var_dump($dbmy->db_recordset);//输出返回的结果集
}
?>

输出信息：

----------phpdebug----------
Server=localhost;DataBase=mysql;UserID=root;PassWord=123456
resource(5)oftype(mysqlresult)

Outputcompleted(1secconsumed)-NormalTermination

使用PHP和XSL stylesheets转换XML文档 在php中输出html代码

评论 (0) All