Exemple #1
0
function dbutils_connect($host, $user, $pass, $base = '', $graceful = false)
{
    $port = ini_get('mysql.default_port');
    $parts = explode(']', $host);
    if (count($parts) > 1) {
        $port = str_replace(':', '', $parts[1]);
        $host = str_replace('[', '', $parts[0]);
    } else {
        $parts = explode(':', $host);
        if (count($parts) > 1) {
            $port = $parts[1];
            $host = $parts[0];
        }
    }
    $error = '';
    $dbconn = mysql_connect($host . ':' . $port, $user, $pass, true);
    if (!$dbconn) {
        $error = 'DB connection failure: ' . mysql_error();
    } else {
        setDataLink($dbconn);
        mysql_select_db($base, $dbconn);
        $error = mysql_error($dbconn);
        if ($error > '') {
            $error = 'DB access failure: ' . $error;
        }
    }
    if ($error > '') {
        if ($graceful) {
            return $error;
        } else {
            echo "\r\n" . $error . "\r\n";
            die;
        }
    } else {
        return $dbconn;
    }
}
Exemple #2
0
function dbutils_connect($host, $user, $pass, $base = '', $graceful = false, $timeout = 30)
{
    $port = ini_get('mysqli.default_port');
    $parts = explode(']', $host);
    if (count($parts) > 1) {
        $port = str_replace(':', '', $parts[1]);
        $host = str_replace('[', '', $parts[0]);
    } else {
        $parts = explode(':', $host);
        if (count($parts) > 1) {
            $port = $parts[1];
            $host = $parts[0];
        }
    }
    $error = '';
    $dbconn = mysqli_init();
    mysqli_options($dbconn, MYSQLI_OPT_CONNECT_TIMEOUT, $timeout);
    $good = mysqli_real_connect($dbconn, $host, $user, $pass, $base, $port);
    if (!$good) {
        // mysqli_connect_errno()
        $error = mysqli_connect_error();
        $error = 'DB connection failure: ' . $error;
    } else {
        setDataLink($dbconn);
        $error = mysqli_error($dbconn);
        if ($error > '') {
            $error = 'DB access failure: ' . $error;
        }
    }
    if ($error > '') {
        if ($graceful) {
            return $error;
        } else {
            throw new Exception($error);
            // was die();
        }
    } else {
        return $dbconn;
    }
}