README

This is a simple and elegant implementation of an ORM (Object-Relational Mapping) for PHP, designed to work with relational databases using fluent query building and Eloquent-style syntax.

Requirements

PHP >= 8.0
Composer

Installation

You can install this ORM package via Composer:

composer require natilosir/ORM

Alternatively, you can clone the repository directly:

git clone https://github.com/natilosir/ORM

Example

When using the DB class, make sure to include it with use .

use natilosir\orm\db;

Select

Select all data with chaining methods

$users = DB::Table('users')
    ->where('name', 'second')
    ->where('email', 'third')
    ->orderBy('id', 'max') // max = DESC, min = ASC
//  ->orderBy('max') // default value is id
    ->limit(3)
    ->get();

Search

Search with multiple conditions

$searchResults = DB::Table('users')
    ->search(['name' => 'Jane', 'email' => 'example.com'])
    ->orderBy('id', 'ASC') // max = DESC, min = ASC
    ->where('age', '>', 25)
    ->limit(3)
    ->get();

foreach ($searchResults as $result) {
    echo $result['id'].' - '.$result['name'].' - '.$result['email'].'<br>';
}

Count

Count users with where condition

$userCount = DB::Table('users')
 // ->where('age', 25)  or search
    ->where('age', '>', 25)
    ->where('age', '>', 25, 'OR')
    ->where('age', '=', 25, 'and')
    ->count();

orderBy

Use the orderBy clause to sort users by email in ascending order with a limit

$orderedResults = DB::Table('users')
    ->where('name', 'John')
    ->where('name', 'jane')
    ->orderBy('id', 'deSC') // max = DESC, min = ASC
    ->limit(3)
    ->get();

foreach ($orderedResults as $result) {
    echo $result['id'].' - '.$result['name'].' - '.$result['email'].'<br>';
}

value

Use the value function to add multiple columns dynamically with automatic numbering for duplicates.

$Price = DB::Table('extra')
    ->value('price','date')->get();

output

SELECT price, id FROM extra //...

Insert array

Insert : Inserting new data with an array

$newUser = [
    'user'  => 'Jane.Doe',
    'name'  => 'Jane Doe',
    'email' => 'jane.doe@example.com'];
DB::Table('users')
    ->insert($newUser);

Insert model

Insert new data with model instance

$data        = DB::Table('users');
$data->user  = 'first';
$data->name  = 'second';
$data->email = 'third';
$data->save();

Update array

Update data with an array

$updateData = [
    'user'  => 'Jane.Doe',
    'name'  => 'John Smith',
    'email' => 'john.smith@example.com'];
DB::Table('users')
    ->update(1, $updateData); // 1 is the ID and update({where}, {UpdateArray})

// Alternatively, update with multiple conditions:
DB::Table('users')
    ->update(['name' => 1, 'user' => 3], $updateData); // update({whereArray}, {UpdateArray})

//AND
DB::Table('users')
//  ->where(['name' => 1, 'user' => 2])
    ->where('name', 1) //AND oder methods in where
    ->update($updateData);

Update model

Update: Updating data with a model instance

$data        = DB::Table('users');
$data->user  = 'first';
$data->name  = 'second';
$data->email = 'third';
$data->save(1);  // 1 is the ID for the record to update $data->save('name' => 'Jane Doe');

createOrFirst

DB::Table('users')->createOrFirst([ 'user_id' => $request->fromID, ], 
[
'first_name' => $request->firstName,
'last_name'  => $request->lastName,
]);

createOrUpdate

DB::Table('users')->createOrUpdate([ 'user_id' => $request->fromID, ],
[
'first_name' => $request->firstName,
'last_name'  => $request->lastName,
]);

Delete

Delete data

DB::Table('users')
    ->delete(1); // 1 is the ID of the record to delete

// Alternatively, delete using conditions:
DB::Table('users')
    ->delete(['name' => 1, 'user' => 6]);

//AND
DB::Table('users')
    ->where(['name' => 1, 'user' => 5]) //AND oder methods in where
    ->delete();

DISTINCT

Using DISTINCT in SQL

$users = DB::Table('users')
    ->select('email')
    ->distinct()
    ->get();

foreach ($users as $user) {
    echo $user['email'].'<br>';
}

JSON

JSON

$users = DB::Table('users')
    ->limit(3)
    ->json()
    ->get();

echo $users;
// [{"id":116,"name":"John Smith", ...

sql

show sql

$price = DB::Table('extra')->WHERE('id', '>', '1')->value('price','date')
    ->sql();