mysql strtolower_自己写的mysql类_PHP教程 - strtolower

...行转换的常用函数。1.将字符串转换成小写strtolower(): 该函数将传入的字符串参数所有的字符都转换成小写,并以小定形式放回这个字符串

2.将字符转成大写strtoupper(): 该函数的作用同strtolower函数相反,是将...

---------- php debug ----------

Server=localhost;DataBase=mysql;UserID=root;PassWord=123456

resource(5) of type (mysql result)

Output completed (1 sec consumed) - Normal Termination

//debug 调试开关

var $debug = true;

//debuginfo 错误信息，调试信息

var $debuginfo = "debug informations:

";

//db_server MySQL主机地址

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_sql SQL语句

var $db_query_sql = "show tables";

//db_recordset 结果集，记录集

var $db_recordset;

//ready 就绪开关

var $conntstr_ready = false;

var $link_ready = false;

var $db_ready = false;

//set or return Connection String 返回，或者设定连接字符串

function connection_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_server or "" == $this->db_name or "" == $this->db_user or "" == $this->db_passwd)

$this->conntstr_ready = false; //如果有其中一个以上变量被赋以空字符串"",准备未就绪

else

$this->conntstr_ready = true;

return $this->conntstr_ready;

}

}

//连接数据库，返回连接对象

function connect()

{

if(!$this->conntstr_ready)

{

if($this->debug){$this->debuginfo .= "连接字符串无效！

";}

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;

}

}

//选择数据库

function select($db = "")

{

if(!$this->db_link)

{

if($this->debug){$this->debuginfo .= "没有可用的数据库连接！

";}

$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;

}

//执行查询

function execute($SQL = "")

{

if("" != $SQL)

{

$this->db_query_sql = $SQL;

//if($this->debug){$this->debuginfo .= "SQL is null!

";}

//return false;

}

if("" == $this->db_query_sql)

{

if($this->debug){$this->debuginfo .= "SQL is null!

";}

return false;

}

$this->db_recordset = mysql_query($this->db_query_sql);

return true;

}

}

$dbmy = new DBCLS(); //创建一个DBCLS对象

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

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

else

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

print "

";

if(!($dbmy->connect()) or !($dbmy->select())) //如果连接数据库，或者选择数据库失败

print $dbmy->debuginfo; //输出出错信息

//$dbmy->db_query_sql = "select * from user";

if($dbmy->execute()) //执行查询指令

{ //如果不出错

var_dump($dbmy->db_recordset);//输出返回的结果集

}

?>

输出信息：

---------- php debug ----------

Server=localhost;DataBase=mysql;UserID=root;PassWord=123456

resource(5) of type (mysql result)

Output completed (1 sec consumed) - Normal Termination

http://www.bkjia.com/PHPjc/532641.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/532641.htmlTechArticle---------- php debug ---------- Server=localhost;DataBase=mysql;UserID=root;PassWord=123456 resource(5) of type (mysql result) Output completed (1 sec consumed) - Normal Terminatio...

...行转换的常用函数。1.将字符串转换成小写strtolower(): 该函数将传入的字符串参数所有的字符都转换成小写,并以小定形式放回这个字符串

2.将字符转成大写strtoupper(): 该函数的作用同strtolower函数相反,是将...

这篇文章主要介绍了关于浅谈PHP源码二：关于strlen, strtolower, strtoupper, ord, chr函数，有着一定的参考价值，现在分享给大家，有需要的朋友可以参考一下int strlen ( string string )返回字符串的长度在标准扩展中并没有相...

在php中字母大小写转换函数包括有:strtolower,strtoupper,ucfirst,ucwords等等函数，本文章来分别给各位介绍这几个字母大小写转换函数使用方法.1.将字符串转换成小写strtolower():该函数将传入的字符串参数所有的字符都转换成...

...注解。可以通过 commit记录查看已添加的注解。 strtolower string strtolower ( string $string ) 将字符串转换成小写字符。 strtoupper string str

...i;

var_dump($func($file));

}

function get_file_ext_1($file) {

return strtolower(trim(substr(strrchr($file, '.'), 1)));

}

function

...unc($file)); } function get_file_ext_1($file) { return strtolower(trim(substr(strrchr($file, '.'), 1))); } function get_file_ext_2($file) { return

...类名或者方法名(下面讲解)。

$this->class = ucfirst(strtolower($class)).'Controller'; //对类名进行安全处理，并加上控制器后缀

$this->method = strtolower($meth

...false ){ $path = explode( "/", trim( $url, "/" ) ); $model = strtolower( $path[1] ); $action = isset( $path[2] ) ? strtolower(

关于require (strtolower($object) . '.class.php')的问题代码require (strtolower($object) . '.class.php');运行出现如下错误提示：Fatal error: require(): Failed opening requ

POWERED BY ©点凡CMS-PHP技术站 ALL RIGHTS RESERVED  本网站部分内容来源于互联网，如有侵犯版权请来信告知,我们将立即处理(363623854#qq.com)