php操作mysqli(示例代码)

<?PHP
define("MysqL_OPEN_LOGS",true);
class MysqLiHelp
{ private $db; public function construct()
{
//如果要查询日志log的话，怎么办 } public function get($name )
{
//echo "GET:",$name;
if(in_array($name,array("db"),true))//或者isset($this->$name)
return $this->$name;
return null; }
public function connect($host,$user,$pass,$db,$charSet='utf8',$force=false)
{ if($this->db && ($this->db instanceof MysqLi) && !$force)
{
return ;
}
$this->db=new MysqLi($host,$db);
if (MysqLi_connect_error()) {
die('Connect Error (' . MysqLi_connect_errno() . ') '
. MysqLi_connect_error());
}
$this->db->set_charset($charSet); }
//$dbname string
//返回值如果成功则返回 TRUE，失败则返回 FALSE。
function select_db ($dbname )
{
return $this->db->select_db($dbname);
} //$query MysqLi_result
//$resulttype int MysqLI_ASSOC,MysqLI_NUM,or MysqLI_BOTH. Defaults to MysqLI_BOTH.
//返回值 Returns an array of strings that corresponds to the fetched row or NULL if there are no more rows in resultset.
function fetch_array(/MysqLi_result/ $query,$resulttype = MysqLI_ASSOC)
{
//var_dump(!null);
if(!$query || !($query instanceof MysqLi_result))
return NULL;
return $query->fetch_array($resulttype);//
} function data_seek($result,$offset)
{ return $result->data_seek($offset); } function fetch_assoc($query)
{ return $query->fetch_assoc();// 关联数组
} function fetch_row($query)
{
return $query->fetch_row();// 索引数组，数字0,1。eg。。。
} function fetch_fields($query)
{
return $query->fetch_fields();
} //$query string
//$resultmode int
//返回值如果成功则返回 TRUE，失败则返回 FALSE。 For SELECT,SHOW,DESCRIBE or EXPLAIN MysqLi_query() will return a result object.
public function query($sql,$resultmode=MysqLI_STORE_RESULT )
{
if(MysqL_OPEN_LOGS) { $sqlstarttime = $sqlendttime = 0; $mtime = explode(' ',microtime());
$sqlstarttime = $mtime[1]+ $mtime[0] ;
} //真正查询
$query=$this->db->query($sql,$resultmode); if(MysqL_OPEN_LOGS) {
// sleep(1);
$mtime = explode(' ',microtime());
$sqlendttime = $mtime[1] + $mtime[0] ;
$sqlQueryTime = number_format($sqlendttime - $sqlstarttime,6);
//dblogs($sql,$sqlQueryTime,1);
$explain = array();
$info = $this->db->info;
if($query && preg_match("/^(select )/i",$sql)) {
$explain = $this->fetch_array($this->db->query('EXPLAIN '.$sql),MysqLI_ASSOC );
}
$GLOBALS['MysqL_debug_query'][] = array('sql'=>$sql,'time'=>$sqlQueryTime,'info'=>$info,'explain'=>$explain);
}
if(!$query)
{
$this->halt('MysqL Query Error',$sql);
}
return $query; } //返回值 MysqLi_stmt对象
function prepare($sql)
{
return $this->db->prepare($sql); } function affected_rows() {
return $this->db->affected_rows;
}
function error()
{
return $this->db->error; }
function errno()
{
return $this->db->errno;
}
//result 没有 function num_rows($query)
{
return $query->num_rows; } //返回值　int The number of fields from a result set.
//也可以用另外一种方式 MysqLiHelp->db->field_count返回。
function num_fields($query)
{
return $query->field_count;
} function free_result($query)
{
//all methods are equivalent;
$query->free();
//$query->free_result();
//$query->close();
} function insert_id()
{ if(($id = $this->db->insert_id)>= 0)
{ return $id;
}else
{
$idArr=$this->fetch_array($this->query("SELECT last_insert_id() as id"));
return intval($idArr[0]);
}
//return ($idArr=$this->fetch_array($this->query("SELECT last_insert_id() as id")))[0]
//return ($id = $this->db-insert_id)>= 0 ? $id : 0 ;
} function close() { return $this->db->close();
}
function halt($message,$sql)
{
$dberror = $this->error();
$dberrno = $this->errno();
$help_link = "http://faq.comsenz.com/?type=MysqL&dberrno=".rawurlencode($dberrno)."&dberror=".rawurlencode($dberror);
echo "<div style=\"position:absolute;font-size:11px;font-family:verdana,arial;background:#EBEBEB;padding:0.5em;\">
MysqL Error

Message: $message

sql: $sql

Error: $dberror

Errno.: $dberrno

<a href=\"$help_link\" target=\"_blank\">Click here to seek help.

php操作mysqli(示例代码)

猜你在找的PHP相关文章