模型主要功能是操作數(shù)據(jù)庫
刪除數(shù)據(jù)
$this->Execute(SqlToolsClass::DeleteData(表名,條件));
取單條數(shù)據(jù)
$this->GetRow(SqlToolsClass::SelectItem(表名,條件,字段,join,order,group,limit,having));
取多條數(shù)據(jù)
$this->GetRow(SqlToolsClass::SelectItem(表名,條件,字段,join,order,group,limit,having));
分頁數(shù)據(jù)
$this->createPage(SqlToolsClass::SelectItem(表名,條件,字段,join,order,group,limit,having));
獲取表名
SqlToolsClass::getTableName(表名);
新增一條數(shù)據(jù)
$this->Execute(SqlToolsClass::InsertData(表名,一維數(shù)組));
新增多條數(shù)據(jù)
$this->Execute(SqlToolsClass::InsertDatas(表名,二維數(shù)組));
更新數(shù)據(jù)
$this->Execute(SqlToolsClass::EditData(表名,數(shù)組,條件));
class coreModelAdmin extends coreFrameworkModel
{
function __construct()
{
parent::__construct();
}
function delManagerMenu($id){
$sql=SqlToolsClass::DeleteData("manager_menu", "id=$id");
return $this->Execute($sql);
}
function delMenu($id){
$sql=SqlToolsClass::DeleteData("menu", "id=$id");
return $this->Execute($sql);
}
//獲取管理員用戶
function getAdminList($get){
$join="left join ".SqlToolsClass::getTableName("admin_group")." as g on g.id=a.gid ";
$sql=SqlToolsClass::SelectItem("admin as a",null,"a.*,g.title as group_title",$join,null,"a.id");
return $this->createPage($sql);
}
function getAdmin($id){
$sql=SqlToolsClass::SelectItem("admin","id=$id");
return $this->GetRow($sql);
}
function delAdmin($id){
$sql=SqlToolsClass::DeleteData("admin", "id=$id");
return $this->Execute($sql);
}
function updataUserLogin($data,$id){
$sql=SqlToolsClass::EditData("admin", $data, "id=$id");
$this->Execute($sql);
}
function getGroup($id,$status){
if ($status){
$sql=SqlToolsClass::SelectItem("admin_group",$where);
return $this->GetAll($sql);
}else{
if ($id) $where="id=".$id;
$sql=SqlToolsClass::SelectItem("admin_group",$where);
return $this->GetRow($sql);
}
}
function saveAuth($id,$data){
$sql=SqlToolsClass::DeleteData("admin_group_auth", "gid=$id");
$this->Execute($sql);
$sql=SqlToolsClass::InsertDatas("admin_group_auth", $data);
return $this->Execute($sql);
}
function getAuth($id){
$sql=SqlToolsClass::SelectItem("admin_group_auth","gid=$id");
return $this->getAll($sql);
}
}
更多建議: