YII框架连接数据库

1.protected\config\main.php

		'db'=>array(
			'connectionString' => 'sqlite:'.dirname(__FILE__).'/../data/testdrive.db',
		),
		// uncomment the following to use a MySQL database
		/*
		'db'=>array(
			'connectionString' => 'mysql:host=localhost;dbname=testdrive',
			'emulatePrepare' => true,
			'username' => 'root',
			'password' => '',
			'charset' => 'utf8',
		),
		*/

修改为

                /*
		'db'=>array(
			'connectionString' => 'sqlite:'.dirname(__FILE__).'/../data/testdrive.db',
		),*/
		// uncomment the following to use a MySQL database
		
		'db'=>array(
			'connectionString' => 'mysql:host=localhost;dbname=数据库名',
			'emulatePrepare' => true,
			'username' => 'root',
			'password' => '数据库密码',
			'charset' => 'utf8',
		),

2.测试数据库是否连上，在一个方法里写上

var_dump(Yii::app()->db);

如：

	function actionLogin(){
		var_dump(Yii::app()->db);
		//通过控制器方法调用视图
		$this->renderPartial('login');
	}

调用此方法，即可知是否连上数据库