How to add more than one database in your code?
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 |
Where to use the theme hook?
How does drupal compare to commercial cms systems?
What are the render arrays in drupal?
How can one make the most of drupal? What are the main advantages?
Explain drupal administration
How do I create a view in drupal 8?
What are the browser requirements for drupal?
How can I customize my 404 - page not found page?
How url aliases works in drupal?
How to create a responsive theme in drupal?
How do I remove breadcrumbs from my drupal pages?
Drupal can run on command line?