A cute mysql function :)

SpYkE112 · 06-02-2008, 01:00 PM

Well, as i work on my current project, i made up a nice little mysql connect function:

PHP Code:


			
function connect_to_db($linkname) {
    global ${$linkname};
    $host = 'localhost';
    $user = '';
    $pass = '';
    $name = '';
    
    if (${$linkname} = mysql_connect($host, $user, $pass)) {
        if (mysql_select_db($name, ${$linkname})) {
            return true;
        } else {
            return false;
        }
    } else {
        return false;
    }
}

Usage is really simple to, a little snippet could be:

PHP Code:


			
if (connect_to_db('link1')) {
    echo('Yes, id: ' . $link1);
} else {
    echo('No.');
}

I for one think it is nice, ofcause it can't compare to a complete DAL but for a little project on a default LAMP server it is nice :)