Configuration
Config file : Irfa/config/database.php
<?php $config = [ 'DB_host' => 'localhost', 'DB_name' => 'database_name', 'DB_username' => 'yourusername', 'DB_password' => 'yourpassword', 'DB_port' => '3306', 'DB_driver' => 'mysql', ];Fetch all rows
<?php require 'Autoloader.php'; use Irfa\DBOperation as DB; $res = DB::table('book')->get(); foreach ($res as $r): echo $r['title']."<br>"; endforeach;Fetch Single row
$data= DB::table('book') ->where(['book_id' => 'ABC123']) ->first(); echo $data['title'];Select specific column
$data= DB::table('book') ->select(['book_id','title','synopsis']) ->where(['book_id' => 'ABC123']) ->first(); echo $r['book_id'].' '.$data['title'].' '.$r['author'];Order by
$res = DB::table('book')->orderBy('author','DESC')->get(); foreach ($res as $r): echo $r['title']."<br>"; endforeach;Insert Data
$params = ['title'=>'Lorem', 'author' => 'Ipsum']; DB::table('book')->insert($params);Update data
$params = ['title'=>'Ipsum', 'author' => 'Lorem']; DB::table('book') ->where(['book_id' => 'ABC123']) ->update($params);Delete data
DB::table('book') ->where(['book_id' => 'ABC123']) ->delete();