How to get data from another mysql server?

Yii 1.1 General Discussion
1

Hello,

I have one form where I want to get data from another mysql server. Is that possible? If possible, can how tell me how?

Thanks

2

Just make a new CDbConnection class:

In your config file:


		'another_db'=>array(

			'connectionString' => 'mysql:host=...;dbname=...',

			'emulatePrepare' => true,

			'username' => '...',

			'password' => '...',

			'charset' => 'utf8',

			'class' => 'CDbConnection',

		),

And specify this db class in model.

3

Can you tell me how to use ip address in mysql:host=.

Thanks