?? mysql.php
字號:
<?php
class mysql
{
var $dbhost="localhost";
var $dbuser="root";
var $dbpw="";
var $dbname="easy";
var $rs;
////////////// init class ///////////////////
function mysql($dbhost="", $dbuser="", $dbpw="",$dbname="")
{
$this->dbhost = $dbhost ? $dbhost: $this->dbhost;
$this->dbuser = $dbuser ? $dbuser: $this->dbuser;
$this->dbpw = $dbpw ? $dbpw: $this->dbpw ;
$this->dbname = $dbname ? $dbname: $this->dbname;
$this->connect(); /////connect server
$this->select_db(); ///// select database
}
function connect($dbhost="",$dbuser="",$dbpw="")
{
$dbhost = $dbhost ? $dbhost : $this->dbhost;
$dbuser = $dbuser ? $dbuser : $this->dbuser;
$dbpw = $dbpw ? $dbpw : $this->dbpw ;
if(!$link=@mysql_pconnect($dbhost, $dbuser, $dbpw))
{
$this->halt('Can not connect to server');
}
return $link;
}
function select_db($dbname="")
{
$dbname=$dbname?$dbname:$this->dbname;
return mysql_select_db($dbname);
}
function query($sql)
{
$query = mysql_query($sql);
$this->rs=$query;
if(!$query) $this->halt('MySQL Query Error');
return $query;
}
function fetch_object($rs="")
{
$rs=$rs?$rs:$this->rs;
return @mysql_fetch_object($rs);
}
function fetch_array($rs="",$result_type = MYSQL_ASSOC)
{
$rs=$rs?$rs:$this->rs;
return @mysql_fetch_array($rs, $result_type);
}
function num_rows($rs="")
{
$rs=$rs?$rs:$this->rs;
return mysql_num_rows($rs);
}
function insert_id()
{
return mysql_insert_id();
}
function errno()
{
return mysql_errno();
}
function error()
{
return mysql_error();
}
function affected_rows()
{
return @mysql_affected_rows();
}
function halt($message ="")
{
echo mysql_error(); echo mysql_errno ();
echo $message;
exit();
}
function free_result($rs)
{
mysql_free_result($rs);
}
function close($link)
{
return mysql_close($link);
}
}//End for class
function check_str($str,$start,$len)
{$str=trim($str);
if (strlen($str) > $len){
for($i=0; $i < $len; $i++)
if (ord($str[$i]) > 128) $i++;
$str= substr($str,$start,$i);
}
return $str;
}
?>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -