PHP Yii Database Connection Tutorial with Examples
Today, We want to share with you PHP Yii Database Connection Tutorial with Examples.
In this post we will show you Yii Database Access, hear for php – configuring database connection in Yii framework we will give you demo and example for implement.
In this post, we will learn about Connect To A MySQL Database With Yii with an example.
PHP Yii Application Configuration main DB (config/main.php)
Yii Database Connection – Sqlite Database
The PHP Based Frameworks The Yii Database To connect the Mysql sqlite db with web application, I should the folder Information of database.
'db'=>array( 'connectionString' => 'sqlite:'.dirname(__FILE__).'/../pakainfo/livepaka.db', ),
Yii Database Connection – Mysql Database
The PHP Based Frameworks The Yii Database To connect the mysql db with web simple application, I should the Eneter your “localhost” hosting Information, database name(pakainfo), username(atmiya), and password(Jayu#$54#*&*#PakaInfo).
'db'=>array( 'connectionString' => 'mysql:host=localhost;dbname=pakainfo', 'emulatePrepare' => true, 'username' => 'atmiya', 'password' => 'Jayu#$54#*&*#PakaInfo', 'charset' => 'utf8', ),
$clients = Yii::app()->db->createCommand() ->select('cname, cpass') ->from('user_mst') ->where('id=:id', array(':id'=>1)) ->queryRow();
PHP Yii CDbConnection – Yii Database Connection
The Yii PHP based Frameworks CDbConnection display a connection to a simple database.
$connection=new CDbConnection($hosting,$username,$password); $connection->active=true;
PHP Yii Excute Query
$sqlStatement="select cname, cpass from user_mst where id=:id limit 1"; $yii_conn=$connection->createCommand($sqlStatement); $yii_conn->bindParam(':id',$cid); $yii_conn->execute(); $user=$yii_conn->query();
I hope you get an idea about Yii Database Connection.
I would like to have feedback on my Pakainfo.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.