links = mysql_connect($host, $user, $pass)){
return false;
}
mysql_select_db($dbname);
$this->connected = true;
}
//关闭
function close(){
$this->connected = false;
$this->link = null;
return true;
}
//快速查询
//返回影响的记录条数
function _query($sql){
if(empty($sql) or !$this->connected){ return false; }
return mysql_query($sql);
}
//返回二维数组(行, 列)
function execute($sql){
if(empty($sql) or !$this->connected){ return false;}
$result = $this->_query($sql);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
$out[]=$row;
}
mysql_free_result($result);
return $out;
}
//返选输出范围
function selectlimit($sql,$numrows=-1,$offset=-1){
if(empty($sql) or !$this->connected){ return false;}
$sql = $sql." LIMIT $numrows,$offset";
$result = $this->_query($sql);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
$out[]=$row;
}
mysql_free_result($result);
return $out;
}
//取单个字段记录
function getone($sql){
if(empty($sql) or !$this->connected){ return false;}
$result = $this->_query($sql);
$row = mysql_fetch_array($result);
mysql_free_result($result);
return $row[0];
}
//取单个表记录
function getrow($sql){
if(empty($sql) or !$this->connected){ exit('db connected error');return false;}
$result = $this->_query($sql);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
mysql_free_result($result);
return $row;
}
//删除记录
function del($sql){
return $this->_query($sql);
}
//增加记录
function into($sql){
$this->_query($sql);
return mysql_insert_id();
}
}
echo "
";
$conn = new db;
$conn->connect();
$sql = 'SELECT * FROM mt_tag';
$sql1 = "INSERT INTO mt_tag (tagname) VALUES ('abc')";
$sql2 = "DELETE FROM `mt_tag` WHERE (`id`='123') ";
$arr = ($conn->selectlimit($sql,0,5));
foreach($arr as $v){
foreach ($v as $k=>$v1){
echo $k."->>".$v1."";
}
echo "
";
}
var_dump($conn->_query($sql2));
print_r($conn->getrow($sql));
print_r($conn->getone($sql));
$conn->close();
?>