PHP Yii Database Connection Tutorial with Examples

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.

Also Read This πŸ‘‰   Laravel 6 LIKE query example using Eloquent WHERE clause

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).

Also Read This πŸ‘‰   PHP Array Length size count Function with Example

'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.

Also Read This πŸ‘‰   Laravel 6 group by month/year using Eloquent

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.