Beispiel #1
0
/**
 * 安装数据
 *
 * @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;
}
Beispiel #2
0
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;
}
/**
 * 安装数据
 *
 * @access  public
 * @param   array         $sql_files        SQL文件路径组成的数组
 * @return  boolean       成功返回true,失败返回false
 */
function install_data($db_host, $db_user, $db_pass, $db_name, $sql_files)
{
    include_once ROOT_PATH . 'tools/controllers/includes/cls_mysql.php';
    include_once ROOT_PATH . 'tools/controllers/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, '', '', 'a.txt');
    $result = $se->run_all($sql_files);
    //    print_r($result);
    if (!empty($result) && $result === false) {
        return false;
    }
    return true;
}