DEV Community

loading...
Cover image for PHP Package:
Database operations using CRUD operations

PHP Package: Database operations using CRUD operations

Tiago Cavalcante Pereira
A backend developer (PHP) who likes to find solutions and create things.
・2 min read

Configure database

 directory: src/Interfaces/IConnect.php
Enter fullscreen mode Exit fullscreen mode

The default configuration uses the sqlite database.

You can also configure the database of your choice.

Note: Check if the PDO - PHP database extension is supported

  /*const DATABASE = "mysql:"; 
    const HOST = "host=localhost;";
    const DBNAME = "dbname=name";
    const USER = "";
    const PASS = "";*/

    const DATABASE = "sqlite:".__DIR__."../../database.db"; 
    const HOST = "";
    const DBNAME = "";
    const USER = null;
    const PASS = null;
Enter fullscreen mode Exit fullscreen mode

Methods

Method Description
create(array $data) Add new entries
all( ) List all entries
find($id) Find entry by id
update($id, array $data) Update or edit existing entries
delete($id) Remove existing entries
execute($sql) Execute SQL statement

Starting a project

Somewhere in your project, you may need to use autoload

 include __DIR__ ."/vendor/autoload.php";
Enter fullscreen mode Exit fullscreen mode

Let's assume you have a table with the following assignments

   users (id,name,age)
Enter fullscreen mode Exit fullscreen mode

Creating the User class

   use Tigo\Crud\Abstracts\AbsCrud; //import class

   class User extends AbsCrud
   {
        /**
        * Get Table
        */
       protected static function getTable()
       {
           return "users";
       }
        /**
        * Get Primary key
        */
       protected static function getPrimaryKey()
       {
           return "id";
       }
   }
Enter fullscreen mode Exit fullscreen mode

Now the "User" class can use all the features of the "AbsCrud" class

  • EXAMPLE: Add new entries
     $data = ['name'=>'Hi','age'=>1];
     $user = new User();
     $user::create($data);
Enter fullscreen mode Exit fullscreen mode
  • EXAMPLE: List all entries
    $user = new User();
    foreach($user::all() as $item){
      echo "ID: ".$item->id."<br>";
      echo "Name: ".$item->name."<br>";
      echo "Age: ".$item->age."<br>";
      echo "----------<br>";
   }
Enter fullscreen mode Exit fullscreen mode
  • EXAMPLE: Find entry by id
    $user = new User();
    $id = 1;
    foreach($user::find($id) as $item){
      echo "ID: ".$item->id."<br>";
      echo "Name: ".$item->name."<br>";
      echo "Age: ".$item->age."<br>";
      echo "----------<br>";
   }
Enter fullscreen mode Exit fullscreen mode
  • EXAMPLE: Update or edit existing entries
     $user = new User();
     $id = 1;
     $data = ['name'=>'Hiii','age'=>8];
     $user::update($id,$data);
Enter fullscreen mode Exit fullscreen mode
  • EXAMPLE: Remove existing entries
     $user = new User();
     $id = 1;
     $user::delete($id);
Enter fullscreen mode Exit fullscreen mode
  • EXAMPLE: Execute SQL statement
     $user = new User();
     $sql = "select * from users";
     $user::execute($sql);
Enter fullscreen mode Exit fullscreen mode

Download source code: Github

Discussion (0)