MODEL_APP::mdl_create_table PHP Method

mdl_create_table() public method

创建表 mdl_create function.
public mdl_create_table ( ) : void
return void
    function mdl_create_table()
    {
        foreach ($this->appStatus as $_key => $_value) {
            $_arr_status[] = $_key;
        }
        $_str_status = implode("','", $_arr_status);
        foreach ($this->appSyncs as $_key => $_value) {
            $_arr_syncs[] = $_key;
        }
        $_str_syncs = implode("','", $_arr_syncs);
        $_arr_appCreate = array("app_id" => "smallint NOT NULL AUTO_INCREMENT COMMENT 'ID'", "app_name" => "varchar(30) NOT NULL COMMENT '应用名'", "app_key" => "char(64) NOT NULL COMMENT '校验码'", "app_url_notify" => "varchar(3000) NOT NULL COMMENT '通知接口 URL'", "app_url_sync" => "varchar(3000) NOT NULL COMMENT '同步接口 URL'", "app_status" => "enum('" . $_str_status . "') NOT NULL COMMENT '状态'", "app_note" => "varchar(30) NOT NULL COMMENT '备注'", "app_time" => "int NOT NULL COMMENT '创建时间'", "app_ip_allow" => "varchar(1000) NOT NULL COMMENT '允许调用 IP 地址'", "app_ip_bad" => "varchar(1000) NOT NULL COMMENT '禁止 IP'", "app_sync" => "enum('" . $_str_syncs . "') NOT NULL COMMENT '是否同步'", "app_allow" => "varchar(3000) NOT NULL COMMENT '权限'");
        $_num_mysql = $this->obj_db->create_table(BG_DB_TABLE . "app", $_arr_appCreate, "app_id", "应用");
        if ($_num_mysql > 0) {
            $_str_alert = "y050105";
            //更新成功
        } else {
            $_str_alert = "x050105";
            //更新成功
        }
        return array("alert" => $_str_alert);
    }

Usage Example

Example #1
0
 private function table_app()
 {
     include_once BG_PATH_MODEL . "app.class.php";
     //载入管理帐号模型
     $_mdl_app = new MODEL_APP();
     $_arr_appTable = $_mdl_app->mdl_create_table();
     if ($_arr_appTable["alert"] != "y050105") {
         $this->obj_api->halt_re($_arr_appTable);
     }
 }
All Usage Examples Of MODEL_APP::mdl_create_table