Posted By

evinweissenberg on 08/18/12

Tagged

Versions (?)

Last Edited at 08/18/12 07:31am

Statistics

Viewed 656 times

Favorited by 0 user(s)

Related snippets

Database Connection

/ Published in: PHP

Allows you to connect to different datasources. Very common to use something like this for development,staging and production deployments.

Highlighted TextExpand

<?php
/*
|---------------------------
| Author: Evin Weissenberg
|---------------------------
*/
class Connection {

public static $db = '1'; // 1=production, 2=staging, 3=development.

//PRODUCTION
    public static $host_1 = '';
    public static $username_1 = '';
    public static $password_1 = '';
    public static $db_name_1 = '';
    public static $port_1 = '';

//STAGING
    public static $host_2 = '';
    public static $username_2 = '';
    public static $password_2 = '';
    public static $db_name_2 = '';
    public static $port_2 = '';

//DEVELOPMENT
    public static $host_3 = 'localhost';
    public static $username_3 = 'root';
    public static $password_3 = 'password';
    public static $db_name_3 = 'my_database';
    public static $port_3 = '3306';

public static function dbConnection() {

if (self::$db == 1) {

mysql_connect(self::$host_1, self::$username_1, self::$password_1) or die(mysql_error());
            mysql_select_db(self::$db_name_1) or die(mysql_error());

return true;

} elseif (self::$db == 2) {

mysql_connect(self::$host_2, self::$username_2, self::$password_2) or die(mysql_error());
            mysql_select_db(self::$db_name_2) or die(mysql_error());

return true;

} elseif (self::$db == 3) {

mysql_connect(self::$host_3, self::$username_3, self::$password_3) or die(mysql_error());
            mysql_select_db(self::$db_name_3) or die(mysql_error());

return true;

} else {

return false;

}
    }
}

//Usage
Connection::$db=3;
Connection::dbConnection();

URL: http://www.evinw.com

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.

Posted By

Tagged

Versions (?)

Statistics

Related snippets

Database Connection

Comments

Choose a language for easy browsing: