PHP check_db_engine Examples

Example #1

File: database.php Project: asphix/icms2

function check_db()
{
    $db = $_POST['db'];
    $db['host'] = trim($db['host']);
    $db['user'] = trim($db['user']);
    $db['base'] = trim($db['base']);
    $db['engine'] = trim($db['engine']);
    $mysqli = @new mysqli($db['host'], $db['user'], $db['pass'], $db['base']);
    if ($mysqli->connect_error) {
        return array('error' => true, 'message' => sprintf(LANG_DATABASE_CONNECT_ERROR, $mysqli->connect_error));
    }
    $mysqli->set_charset("utf8");
    $check_engine = check_db_engine($mysqli, $db['engine']);
    if ($check_engine !== true) {
        return array('error' => true, 'message' => $check_engine);
    }
    $success = import_dump($mysqli, 'base.sql', $db['prefix'], $db['engine']);
    if ($success) {
        if (!$db['users_exists']) {
            $db['users_table'] = $db['prefix'] . 'users';
        }
        $_SESSION['install']['db'] = $db;
    }
    return array('error' => !$success, 'message' => LANG_DATABASE_BASE_ERROR);
}

Example #2

File: database.php Project: Val-Git/icms2

function check_db()
{
    $db = $_POST['db'];
    $db['host'] = trim($db['host']);
    $db['user'] = trim($db['user']);
    $db['base'] = trim($db['base']);
    $db['engine'] = trim($db['engine']);
    $db['clear_sql_mode'] = 0;
    $mysqli = @new mysqli($db['host'], $db['user'], $db['pass'], $db['base']);
    if ($mysqli->connect_error) {
        return array('error' => true, 'message' => sprintf(LANG_DATABASE_CONNECT_ERROR, $mysqli->connect_error));
    }
    if (!empty($mysqli->server_info)) {
        if (strpos($mysqli->server_info, '5.7') === 0) {
            $db['clear_sql_mode'] = 1;
        }
    }
    $mysqli->set_charset("utf8");
    $check_engine = check_db_engine($mysqli, $db['engine']);
    if ($check_engine !== true) {
        return array('error' => true, 'message' => $check_engine);
    }
    $success = import_dump($mysqli, 'base.sql', $db['prefix'], $db['engine']);
    if ($success) {
        $success = import_dump($mysqli, 'geo.sql', $db['prefix'], $db['engine']);
    }
    if ($success && !empty($db['is_install_demo_content'])) {
        $success = import_dump($mysqli, 'base_demo_content.sql', $db['prefix'], $db['engine']);
        $dir_install_upload = PATH . DS . 'upload';
        $dir_upload = DOC_ROOT . DS . 'upload';
        copy_folder($dir_install_upload, $dir_upload);
    }
    if ($success) {
        if (!$db['users_exists']) {
            $db['users_table'] = $db['prefix'] . 'users';
        }
        $_SESSION['install']['db'] = $db;
    }
    return array('error' => !$success, 'message' => LANG_DATABASE_BASE_ERROR);
}