/** * 安装数据 * * @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; }
/** * 安装数据 * * @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; }