#1 GoolLong
我有个日志数据库,里面的表全是后台守护程序根据时间自动生成的,比如表名是 log_201101 。我要在前台来处理这些表,是不可能先定义好model的,那么如何来初始化数据库连接呢?
2011-05-04 12:56:46
2011-05-04 12:56:46
class m_logdb extends spModel
{
var $pk = "1";
var $db = array(
'driver' => 'mysql',
'host' => 'localhost',
'port' => 3306,
'login' => 'user',
'password' => 'pwd',
'database' => 'logdb',
);
public function __construct(){
$db = spClass('db_mysql', array($this->db), SP_PATH.'/Drivers/mysql.php', TRUE);
$this->_db = $db;
}
}
$db = spClass("m_logdb");
$rows = $db->spPager($page, $page_size)->findSql("select * from log_201104");
2011-05-04 20:01:44
2011-05-04 20:05:11
2011-05-05 17:06:49