Skip to content

Latest commit

 

History

History
87 lines (66 loc) · 2.98 KB

README.md

File metadata and controls

87 lines (66 loc) · 2.98 KB

ELOQUENT CLASS

Install the bundle using Composer:

composer require roy404/eloquent

DOCUMENTATION

The Eloquent class is a database query builder that provides a fluent interface to create SQL queries.

Methods

  • table(): Sets the table for the query.
  • select(): Adds a column to the select clause.
  • where(): Adds a where clause to the query.
  • orWhere(): Adds an OR where clause to the query.
  • orderBy(): Adds an order by clause to the query.
  • offset(): Adds an offset clause to the query.
  • limit(): Adds a limit clause to the query.
  • create(): Creates a new record in the database.
  • replace(): Replaces a record in the database.

Model

The Model class extends Eloquent and provides additional methods for interacting with database tables that correspond to models.

  • all(): array: Retrieves all records from the database table.
  • create(array $binds): int: Creates a new record in the database table.
  • replace(array $binds): int: Replaces a record in the database table.
  • find(int $id): array: Retrieves a record by its primary key.
  • select(...$columns): Eloquent: Selects specific columns from the database table.
  • where(string $column, mixed $operator_or_value, mixed $value = self::DEFAULT_VALUE): Eloquent: Adds a where clause to the query.

Return Data

However, these functions are not yet fully implemented; you will need to complete them yourself.

  • lastID(): int: Returns the last inserted ID from the database.
  • fetch(): array: Fetches all rows from the result set as an array of arrays.
  • col(): array: Fetches the first column of all rows from the result set as an array.
  • field(): mixed: Fetches a single field value from the first row of the result set.
  • row(): array: Fetches the first row from the result set as an associative array.
  • count(): int: Returns the number of rows affected by the last SQL statement.

Example Usage

// Define the User class
class User extends Model
{
    protected string $primary_key = 'id';
    protected array $fillable = ['name'];
}

// Create a new user
$userId = User::create([
    'name' => 'Robroy'
]);

// Retrieve a user by ID
$user = User::find($userId);

// Update a user's record
User::where( 'name', 'Robroy' )->update(['name' => 'Robert']);

// Delete a user's record
User::where( 'name', 'Robert' )->delete();

// Another Example
$user = User::select( 'name', 'email', 'contact' )
    ->where( 'name', '<>', 'robot' )
    ->where( 'email', '[email protected]' )
    ->where( function( \Illuminate\Databases\Eloquent $group ) {
        $group->where( 'contact', '+63 917 130 4494' )
              ->orWhere( 'contact', '216-2944' )
    })
    ->limit( 1 )
    ->row();

// Another Example [2]
DB::table( 'user' )->select( 'name' )->where( 'id', $userId )->field();

YOU WILL NEED TO CHANGE THE LOGIC OF THE FUNCTION BELOW:

Illuminate\Databases\DB::run() - We suggest you to create your own class that runs the query with the action provided in the Return Data list.