simplecrud/simplecrud

A Simple CRUD Class to make your development process faster

Simple_CRUD

A Simple Create,Read,Update,Delete Library for your PHP Web App. Basically, there wouldn't be any need to tinker with annoying Query Codes. Leverages Both MYSQLi and PDO., _(*1)

How to use?

With Composer

First install Composer using, _(*2)

composer install, _(*3)

Then Require it using, _(*4)

composer require scrud/scrud, _(*5)

Which will then be added to your Composer.json dependencies., _(*6)

Or, _(*7)

---------------- Using the lib as a Class ------

1. Clone this Repo which will then be stored in your chosen directory as Simple_CRUD

git clone https://github.com/kofacts/Simple_CRUD.git", _(*8)

1. Open the File, _(*9)

2. Locate the src/ directory and Open the config.php, _(*10)

3. Fill in the necessary details and DB_Type. MYSQLI or PDO., _(*11)

$connectDetails=[ "hostname"=>"hostname", "username"=>"username", "password"=>"password", "DB_NAME"=>"database name", "connect_type"=>strtoupper("pdo or mysqli"), ]; , _(*12)

1. Inside your Main Page, say index.php, instantiate a Scrud Object.

$scrud= new Scrud;, _(*13)

1. Now you Have done the needful, What can you do with all this.

Some of the Basic Methods you can use.

1. create($tablename,$fields) : The tablename is the name of the Tablename you wish to add Data to, while the fields are the array of data you wish to insert values into. From the code below, the user_details is the tablename, while the array are yes, array of values you wish to insert data into.

$scrud->create("user_details",array("username"=>"Ricesss","password"=>"pico4421ss")); , _(*14)

1. get($tablename) : params is just $tablename. This would get all fields from DB. Simple instantiate the Scrud Class. eg

$posts=$scrud->get("user_details");, _(*15)

And then loop through all the fields., _(*16)

foreach($posts as $row) { echo $row['username']; } , _(*17)

1. get_where($tablename,$id,$value): This would accept params tablename,id/field and the value you wish to get. To use, simply do

$value=$scrud->get_where($tablename,$id,$value) And then use, _(*18)

echo $value['username'];, _(*19)

1. update($tablename,$field,$id,$value); This would accept params $tablename,$field [arrays],id to be update and value. To use, simply do,

$scrud->update("user_details",array("username"=>"Rapheal","password"=>"skjf..anything"),"id",1);, _(*20)

1. delete($tablename,$id,$value): This would accept params $tablename,$id to delete and then value. To Use, Simply do,

$scrud->delete("user_details","id",2);, _(*21)

Inspiration

The Concept is inspired by Codeigniter's Sleek Query System. Make it simple, and very simple has always been the name., _(*22)

Contribute

There are so many features that should be added to this platform. Hey, Don't just leave, you can always contribute by pulling a request., _(*23)

This would Help Me, How should i thank you.

Nah, Nada, Don't thank Me. Actually, you can thank me by Staring. Em, :smile: I think that is just it., _(*24)

PS: Some Basic Touches still going on., _(*25)

Licence

MIT, _(*26)