Simple DB Operation Framework with PHP

<?php
$config = [
 'DB_host' => 'localhost',
 'DB_name' => 'database_name',
 'DB_username' => 'yourusername',
 'DB_password' => 'yourpassword',
 'DB_port' => '3306',
 'DB_driver' => 'mysql',
 ];

Basic Usage

 <?php
 require 'Autoloader.php';
 use Irfa\DBOperation as DB;
 
 $res = DB::table('book')->get();
 foreach ($res as $r):
 echo $r['title']."<br>";
 endforeach;

 $data= DB::table('book')
 	->where(['book_id' => 'ABC123'])
 	->first();
 	
 	echo $data['title'];

 $data= DB::table('book')
 ->select(['book_id','title','synopsis'])
 	->where(['book_id' => 'ABC123'])
 	->first();
 	
 	echo $r['book_id'].''.$data['title'].''.$r['author'];

$res = DB::table('book')->orderBy('author','DESC')->get();
 foreach ($res as $r):
 echo $r['title']."<br>";
 endforeach;

 $params = ['title'=>'Lorem', 'author' => 'Ipsum'];
 DB::table('book')->insert($params);

$params = ['title'=>'Ipsum', 'author' => 'Lorem'];
DB::table('book')
->where(['book_id' => 'ABC123'])
->update($params);

DB::table('book')
	->where(['book_id' => 'ABC123'])
	->delete();