读书人

ECSHOP SQL话语执行类

发布时间: 2012-12-25 16:18:28 作者: rapoo

ECSHOP SQL语句执行类

?
/** * 安装数据 * * @access  public * @param   array         $sql_files        SQL文件路径组成的数组 * @return  boolean       成功返回true,失败返回false */function install_data($sql_files){    global $err;    include(ROOT_PATH . 'data/config.php');    include_once(ROOT_PATH . 'includes/cls_mysql.php');    include_once(ROOT_PATH . 'includes/cls_sql_executor.php');    $db = new cls_mysql($db_host, $db_user, $db_pass, $db_name);    $se = new sql_executor($db, EC_DB_CHARSET, 'ecs_', $prefix);    $result = $se->run_all($sql_files);    if ($result === false)    {        $err->add($se->error);        return false;    }    return true;}function rollback($next_ver){    global $db, $prefix, $err;    $structure_path[] = ROOT_PATH . 'data/sqldata/' . $next_ver . '.sql';    if(!file_exists($structure_path[0]))    {        return false;    }    $db_charset = strtolower((str_replace('-', '', EC_CHARSET)));    $se = new sql_executor($db, $db_charset, 'ecs_', $prefix);    $result = $se->run_all($structure_path);    if ($result === false)    {        $err->add($se->error);        return false;    }    return true;}

读书人网 >SQL Server

热点推荐