Beispiel #1
0
/**
 * @param $host
 * @param $port
 * @param $login
 * @param $pass
 * @param string $db
 * @param string $prefixe
 * @return array|bool
 */
function req_mysql_dist($host, $port, $login, $pass, $db = '', $prefixe = '')
{
    if (!charger_php_extension('mysql')) {
        return false;
    }
    if ($port > 0) {
        $host = "{$host}:{$port}";
    }
    $link = @mysql_connect($host, $login, $pass, true);
    if (!$link) {
        spip_log('Echec mysql_connect. Erreur : ' . mysql_error(), 'mysql.' . _LOG_HS);
        return false;
    }
    $last = '';
    if (!$db) {
        $ok = $link;
        $db = 'spip';
    } else {
        $ok = spip_mysql_selectdb($db);
        if (defined('_MYSQL_SET_SQL_MODE') or defined('_MYSQL_SQL_MODE_TEXT_NOT_NULL')) {
            mysql_query($last = "set sql_mode=''");
        }
    }
    spip_log("Connexion vers {$host}, base {$db}, prefixe {$prefixe} " . ($ok ? "operationnelle sur {$link}" : 'impossible'), _LOG_DEBUG);
    return !$ok ? false : array('db' => $db, 'last' => $last, 'prefixe' => $prefixe ? $prefixe : $db, 'link' => $GLOBALS['mysql_rappel_connexion'] ? $link : false);
}
Beispiel #2
0
function req_mysql_dist($host, $port, $login, $pass, $db='', $prefixe='') {
	if (!charger_php_extension('mysql')) return false;
	if ($port > 0) $host = "$host:$port";
	$link = @mysql_connect($host, $login, $pass, true);
	if (!$link) {
		spip_log('Echec mysql_connect. Erreur : ' . mysql_error(),'mysql');
		return false;
	}
	$last = '';
	if (!$db) {
		$ok = $link;
		$db = 'spip';
	} else {
		$ok = spip_mysql_selectdb($db);
		if (defined('_MYSQL_SET_SQL_MODE') 
		  OR defined('_MYSQL_SQL_MODE_TEXT_NOT_NULL') // compatibilite
		  )
			mysql_query($last = "set sql_mode=''");
	}
#	spip_log("Connexion vers $host, base $db, prefixe $prefixe "
#		 . ($ok ? "operationnelle sur $link" : 'impossible'));

	return !$ok ? false : array(
		'db' => $db,
		'last' => $last,
		'prefixe' => $prefixe ? $prefixe : $db,
		'link' => $GLOBALS['mysql_rappel_connexion'] ? $link : false,
		);
}