MODEL_ADMIN::mdl_create_table PHP Метод

mdl_create_table() публичный Метод

创建表 在安装或升级时调用 mdl_create function.
public mdl_create_table ( ) : void
Результат void
    function mdl_create_table()
    {
        foreach ($this->adminStatus as $_key => $_value) {
            $_arr_status[] = $_key;
        }
        $_str_status = implode("','", $_arr_status);
        foreach ($this->adminTypes as $_key => $_value) {
            $_arr_types[] = $_key;
        }
        $_str_types = implode("','", $_arr_types);
        $_arr_adminCreate = array("admin_id" => "smallint NOT NULL AUTO_INCREMENT COMMENT 'ID'", "admin_name" => "varchar(30) NOT NULL COMMENT '用户名'", "admin_pass" => "char(32) NOT NULL COMMENT '密码'", "admin_rand" => "char(6) NOT NULL COMMENT '随机串'", "admin_note" => "varchar(30) NOT NULL COMMENT '备注'", "admin_nick" => "varchar(30) NOT NULL COMMENT '昵称'", "admin_status" => "enum('" . $_str_status . "') NOT NULL COMMENT '状态'", "admin_type" => "enum('" . $_str_types . "') NOT NULL COMMENT '类型'", "admin_allow" => "varchar(3000) NOT NULL COMMENT '权限'", "admin_time" => "int NOT NULL COMMENT '创建时间'", "admin_time_login" => "int NOT NULL COMMENT '登录时间'", "admin_ip" => "varchar(15) NOT NULL COMMENT '最后 IP 地址'");
        $_num_mysql = $this->obj_db->create_table(BG_DB_TABLE . "admin", $_arr_adminCreate, "admin_id", "管理员");
        if ($_num_mysql > 0) {
            $_str_alert = "y020105";
            //更新成功
        } else {
            $_str_alert = "x020105";
            //更新成功
        }
        return array("alert" => $_str_alert);
    }

Usage Example

Пример #1
0
 private function table_admin()
 {
     include_once BG_PATH_MODEL . "admin.class.php";
     //载入管理帐号模型
     $_mdl_admin = new MODEL_ADMIN();
     $_arr_adminTable = $_mdl_admin->mdl_create_table();
     if ($_arr_adminTable["alert"] != "y020105") {
         $this->obj_api->halt_re($_arr_adminTable);
     }
 }
All Usage Examples Of MODEL_ADMIN::mdl_create_table