Interested to Buy Any Domain ? << Click Here >> for more details...
How to add more than one database in your code?
- 1 Answers
- 127 Views
- I also Faced
- E-Mail Answers
Answer / Harveer Singh
In Drupal, you can add multiple databases by modifying the settings.php file. Here's a simple example:
```
$databases = array(
'default' => array(
'default' => array(
'database' => '<db_name_1>',
'username' => '<user_name_1>',
'password' => '<password_1>',
'host' => '<host_name_1>',
'port' => '<port_number_1>',
'driver' => '<database_driver>', // For example, mysql or pdo_mysql.
'prefix' => '<table_prefix_1>',
),
),
'otherdb' => array(
'default' => array(
'database' => '<db_name_2>',
'username' => '<user_name_2>',
'password' => '<password_2>',
'host' => '<host_name_2>',
'port' => '<port_number_2>',
'driver' => '<database_driver>', // For example, mysql or pdo_mysql.
'prefix' => '<table_prefix_2>',
),
),
);
| Is This Answer Correct ? | 0 Yes | 0 No |
How does drupal scale?
What are drupal distributions and drupal installation profiles
Is drupal a programming language?
Name the translations available in drupal?
What is teaser in drupal ?
How can I translate drupal to my local language?
How do you handle upgrades?
What is aggregator module?
How to modify the form validation in drupal?
What is difference between update and alter query?
Why Drupal needs database? What databases are supported?
If we delete the page.tpl.php then drupal site will work or not?
PHP 
