Showing 21-22 of 22 items.

Multiple-database support in Yii

Created 15 years ago by Steve Friedl Steve Friedl, updated 14 years ago by phazei phazei. 18 comments

The customary configuration of a Yii application includes just a single database section in the protected/config/main.php file, but it's easy to extend this to support more than one, tying each Model to one of the databases.

20 0
39
Viewed: 155 189 times
Version: 1.1
Category: How-tos

Multiple Databases and Multiple Domains

Created 16 years ago by got 2 doodle got 2 doodle, updated 15 years ago by Maurizio Domba Cerin Maurizio Domba Cerin. 2 comments

Add these lines in /config/main.php

'components'=>array(
.........
		'db'=>array(
			'connectionString' => 'mysql:host=localhost;dbname=database1',
			'emulatePrepare' => true,
			'username' => 'root',
			'password' => 'itsasecret',
			'charset' => 'utf8',
		),
		'db2'=>array(
		    'class' => 'CDbConnection',
			'connectionString' => 'mysql:host=localhost;dbname=databa...
13 2
15
Viewed: 63 942 times
Version: 1.1
Category: Tutorials