PHP Yii Database Connection Tutorial With Examples

PHP Yii Database Connection Tutorial with Examples

Contents

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',
        ),

Excute Query

$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();

Read :

Summary

You can also read about AngularJS, ASP.NET, VueJs, PHP.

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.

PHP Yii Database Connection Tutorial with Examples