PHPCRUDLib

PHPCRUDLib is simple code to help you do CRUD in minutes. ❤️

It is a 'peanut' 😊 library (or let's say petite file but awesome✨, because peanut taste good 😋)

To know more about what CRUD is, click here

It is just a single file. You add it to your project and boom 💥!!! You're done! No need to 'master' SQL before you CRUD 😄

//saving new record into table
$PHPCRUDLib->name ='Pepsi Cola';
$PHPCRUDLib->user_id =1;
$PHPCRUDLib->created_at =date('Y-m-d H:i:s');
$PHPCRUDLib->save();

Support

CONFIGURATION

DBConfig.php You have to edit this file to fit your database connection credentials

$dbms  //DBMS eg. mysql
$host  //database host eg. localhost
$port  // database port eg. 3306
$user  // database user eg. root
$pass //password of database user eg. p@ssw0rd
$dbname  // database name eg. sales_db

USAGE

Download or clone this repo. After you have downloaded or cloned the repo, place the folder in any directory inside your project.

Then put this code in the file you want to perform your CRUD operations

//add or include library to file
include '../PHPCRUDLib.php';
use PHPGrammers\PHPCRUDLib as PHPCRUDLib;
//define table name
$table = 'products';
//create library object and pass the table name to it
$PHPCRUDLib = new PHPCRUDLib($table);

So the important thing is to pass the table name to PHPCRUDLib() that is PHPCRUDLib($argument) where argument is the table name

You do not have to always repeat this $PHPCRUDLib = new PHPCRUDLib($table_name);, Once you are CRUDing on the same table in the same file, you only write it once.

And it is not compulsory to use this variable $PHPCRUDLib, you can use any variable of your choice

SAMPLE

Once the above is done, you can then go ahead and perform your CRUD swiftly

Save new record into table Eg.1

$PHPCRUDLib = new PHPCRUDLib($table_name);
$PHPCRUDLib->name ='Pepsi Cola';
$PHPCRUDLib->user_id =1;
$PHPCRUDLib->created_at =date('Y-m-d H:i:s');
$PHPCRUDLib->save();

Save new record into table Eg.2

$products = new PHPCRUDLib($table_name);
$products->name ='A1 Bread';
$products->user_id =2;
$products->created_at =date('Y-m-d H:i:s');
$products->save();

update record

//update records using id
$PHPCRUDLib->name ='Malta Guinness';
$id = 5;
$PHPCRUDLib->update($id);

This code strictly depends on column name id so your primary key or unique must be id

delete single record

//delete one record using id
$id = 3;
$PHPCRUDLib->delete($id);

This code strictly depends on column name id so your primary key or unique must be id

select all records

//select all records in table
$result = $PHPCRUDLib->allRecords();

UPDATES/ FIXES

Feel free to raise issues if your find any bugs or concerns and PR if you have any contributions to make.