PHP code example of natilosir / orm

    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

    

natilosir / orm example snippets

use natilosir\orm\db; 

$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();
    

$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>';
}

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

$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>';
}

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

$newUser = [
    'user'  => 'Jane.Doe',
    'name'  => 'Jane Doe',
    'email' => '[email protected]'];
DB::Table('users')
    ->insert($newUser);

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

$updateData = [
    'user'  => 'Jane.Doe',
    'name'  => 'John Smith',
    'email' => '[email protected]'];
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);

$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'); 

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

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

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();

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

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

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

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

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

$customQueryResults = DB::query("SELECT * FROM users WHERE email LIKE '%example.com%' LIMIT 5");

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

class User extends Model {
    protected static string $table = 'users';
}

User::createOrFirst([ 'user_id' => $request->fromID, ], [
'first_name' => $request->firstName,
'last_name'  => $request->lastName,
]);
// OR
$Result = User::where('user_id', $fromID)->first();