zblog创建新表创建表类的方法

在主题或者插件的include.php文件顶部引用文件

include_once__DIR__.'/database/index.php';

在引入的php里面写入创建表类的代码

$ytecn_database=array(
'ytecn_table'=>array(
'name'=>'%pre%ytecn_table',
'info'=>array(
'ID'=>array('ytecn_ID','integer','',0),
'UID'=>array('ytecn_UID','integer','',0),
'Name'=>array('ytecn_Name','string',255,''),
'Content'=>array('ytecn_Content','string','',''),
'Status'=>array('ytecn_Status','integer','',0),
),
),
);
foreach($ytecn_databaseas$k=>$v){
$table[$k]=$v['name'];
$datainfo[$k]=$v['info'];
}
functionytecn_table_CreateTable(){
global$zbp,$ytecn_database;
foreach($ytecn_databaseas$k=>$v){
if(!$zbp->db->ExistTable($v['name'])){
$s=$zbp->db->sql->CreateTable($v['name'],$v['info']);
$zbp->db->QueryMulit($s);
}
}
}
classytecntableextendsBase{
publicfunction__construct(){
global$zbp;
parent::__construct($zbp->table['ytecn_table'],$zbp->datainfo['ytecn_table'],__CLASS__);
}
publicfunction__get($name)
{
global$zbp;
switch($name){
case'Url':
return"详情的url访问地址";
break;
case'Author':
return$zbp->GetMemberByID($this->UID);
default:
returnparent::__get($name);
break;
}
}
publicstaticfunctionGetList($select=null,$w=null,$order=null,$limit=null,$option=null){
global$zbp;
if(empty($select)){
$select=array('*');
}
if(empty($w)){
$w=array();
}
$sql=$zbp->db->sql->Select(
$zbp->table['ytecn_database'],
$select,
$w,
$order,
$limit,
$option
);
$result=$zbp->GetListType('ytecntable',$sql);
return$result;
}
}

在启动主题或者插件的时候执行创建表的函数

functionInstallPlugin_****(){
ytecn_table_CreateTable();
}

查询多条数据

$where=array();
$where[]=array('=','ytecn_Status',0);
$array=ytecntable::GetList(null,$where,array("ytecn_ID"=>"DESC"));
foreach($arrayas$item){
echo$item->Name;
}

查询单条数据（多条件）

$table=newytecntable;
$w=array();
$w['Pid']=$pid;
$w['Uid']=$zbp->user->ID;
$w['Type']=$type;
$table->LoadInfoByFields($w);
print_r($table);

查询单条数据（通过ID）

$table=newytecntable;
$table->LoadInfoByID($id);
print_r($table);

添加数据

$table=newytecntable;
$table->Name='豫唐';
$table->Status=0;
$table->Save();

修改数据

$id=(int)GetVars("id","POST");
$table=newytecntable;
$table->LoadInfoByID($id);
$table->Name='豫唐ytecn';
$table->Status=1;
$table->Save();

删除数据

$id=GetVars("id","GET");
$table=newytecntable;
if(!empty($id)){
$table->LoadInfoByID((int)$id);
}
$table->Del();

完整源码案例：