$table['cat_spider'] = '%pre%cat_spider'; # 定义这个可以使用 $zbp->table['cat_spider'] 获取表名字
$datainfo['cat_spider'] = array(
'ID' => array('id', 'integer', '', 0),
'Name' => array('name', 'string', 128, ''),
'Ip' => array('ip', 'string', 128, ''),
'Url' => array('url', 'string', 128, ''),
'Status' => array('status', 'string', 128, ''),
'Stime' => array('stime', 'integer', '', 0)
);
function cat_spider_createtable() # 创建表
{
global $zbp;
if (!$zbp->db->ExistTable($GLOBALS['table']['cat_spider'])) {
$s = $zbp->db->sql->CreateTable($GLOBALS['table']['cat_spider'], $GLOBALS['datainfo']['cat_spider']);
$zbp->db->QueryMulit($s);
}
}
删除表
$zbp->db->sql->get()->drop()->table($zbp->db->dbpre . 'cat_spider')->ifexists()->query;
或
echo $zbp->db->sql->get()->drop()->table($zbp->table['cat_spider'])->ifexists()->sql;
# DROP TABLE IF EXISTS zbp_cat_spider ;
$zbp->db->dbpre 是表前缀
