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; } }
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; } }