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 :)

Wildhoney · 06-02-2008, 09:44 PM

Thanks! You may not know it, but storing the MySQL details in a function is actually a great way of protecting the data. As those variables won't be available outside the function via a simple echo.

SpYkE112 · 06-03-2008, 05:27 AM

Yea, i noticed that to, similar to the protected/private "flag" i guess :D
I think later on i maybe will make some multiple databases, so that if you have one mysql server to handle your users then you have another to handle something like a forum, would be nice to i think :)