Welcome Guest, Not a member yet? Register   Sign In
Profiler and Multiple DB's
#5

[eluser]dbrown75[/eluser]
<?php if (!defined('BASEPATH')) exit('No direct script access allowed');
/*
| -------------------------------------------------------------------
| DATABASE CONNECTIVITY SETTINGS
| -------------------------------------------------------------------
| This file will contain the settings needed to access your database.
|
| For complete instructions please consult the "Database Connection"
| page of the User Guide.
|
| -------------------------------------------------------------------
| EXPLANATION OF VARIABLES
| -------------------------------------------------------------------
|
| ['hostname'] The hostname of your database server.
| ['username'] The username used to connect to the database
| ['password'] The password used to connect to the database
| ['database'] The name of the database you want to connect to
| ['dbdriver'] The database type. ie: mysql. Currently supported:
mysql, mysqli, postgre, odbc, mssql
| ['dbprefix'] You can add an optional prefix, which will be added
| to the table name when using the Active Record class
| ['pconnect'] TRUE/FALSE - Whether to use a persistent connection
| ['db_debug'] TRUE/FALSE - Whether database errors should be displayed.
| ['cache_on'] TRUE/FALSE - Enables/disables query caching
| ['cachedir'] The path to the folder where cache files should be stored
| ['char_set'] The character set used in communicating with the database
| ['dbcollat'] The character collation used in communicating with the database
|
| The $active_group variable lets you choose which connection group to
| make active. By default there is only one group (the "default" group).
|
| The $active_record variables lets you determine whether or not to load
| the active record class
*/

$active_group = 'default';
$active_record = TRUE;

require_once('db-routing.php');

// Default database connection
$db['default']['hostname'] = MYSQL_HOST;
$db['default']['username'] = 'user';
$db['default']['password'] = 'password';
$db['default']['database'] = 'main_database';
$db['default']['dbdriver'] = 'mysql';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = '';
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';

// The second_database connection
$db['second_database']['hostname'] = MYSQL_HOST;
$db['second_database']['username'] = 'user';
$db['second_database']['password'] = 'password';
$db['second_database']['database'] = 'second_database';
$db['second_database']['dbdriver'] = 'mysql';
$db['second_database']['dbprefix'] = '';
$db['second_database']['pconnect'] = TRUE;
$db['second_database']['db_debug'] = TRUE;
$db['second_database']['cache_on'] = FALSE;
$db['second_database']['cachedir'] = '';
$db['second_database']['char_set'] = 'utf8';
$db['second_database']['dbcollat'] = 'utf8_general_ci';

?>


Messages In This Thread
Profiler and Multiple DB's - by El Forum - 04-02-2009, 02:15 PM
Profiler and Multiple DB's - by El Forum - 04-02-2009, 08:50 PM
Profiler and Multiple DB's - by El Forum - 04-03-2009, 06:11 AM
Profiler and Multiple DB's - by El Forum - 04-03-2009, 06:47 AM
Profiler and Multiple DB's - by El Forum - 04-03-2009, 06:59 AM
Profiler and Multiple DB's - by El Forum - 04-03-2009, 07:09 AM
Profiler and Multiple DB's - by El Forum - 04-03-2009, 07:32 AM
Profiler and Multiple DB's - by El Forum - 04-03-2009, 08:11 AM
Profiler and Multiple DB's - by El Forum - 04-03-2009, 12:45 PM



Theme © iAndrew 2016 - Forum software by © MyBB