/**
* @param string $dbini 在 config/db.ini.php中配置数据库连接
*/
function __construct($dbini)
{
$this->_dbConfig = SDb::getConfig($dbini);
$this->_db = SDb::getDbEngine("pdo_mysql");
$this->_db->init($this->_dbConfig);
$this->_time = time();
}
/**
* 释放所有对象和数据库连接
* return object|false
*/
public static function destroy()
{
// 清除数据库连接，防止长连接导致的数据库超时
$db = SDb::getDbEngine("pdo_new_mysql");
$db->disconnect();
// 释放所有数据库对象
self::clear();
}
function __construct($pkid = false)
{
$this->_dbConfig = SDb::getConfig("default");
$this->_db = SDb::getDbEngine("pdo_mysql");
$this->_db->init($this->_dbConfig);
$this->_time = time();
if ($pkid !== false) {
$this->setPkid($pkid);
}
}
<?php
/*
drop table if exists test;
CREATE TABLE `test` (
`id` int not null primary key auto_increment,
`name` varchar(30) default NULL,
`password` varchar(30) default NULL,
KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
*/
$db = SDb::getDbEngine("mysql");
$db = SDb::getDbEngine("pdo_mysql");
if (!$db) {
die("DbEngine not exits");
}
$db->init(array("host" => "localhost", "user" => "root", "password" => "", "database" => "test"));
//插入记录
print_r($db->insert($table = "test", $items = array("name" => "testName", "password" => "testPassword")));
//检索一个
print_r($db->selectOne($table = "test", $condition = array(), $items = array("name")));
//按条件检索一个
print_r($db->selectOne($table = "test", $condition = array("id" => 1), $items = array("*")));
//搜索全部
$db->setLimit(-1);
print_r($db->select($table = "test", $condition = array(), $items = array("*")));
//按页检索
$db->setPage(2);
$db->setLimit(5);
//是否算总数
$db->setCount(true);
