Drago Database

Simple recurring questions., _(*1)

, _(*2)

Technology

PHP 8.3 or higher
composer

Knowledge

Dibi - smart database layer for PHP

Installation

composer require drago-ex/database

Basic Model Example

#[Table('table_name', 'primary_key')]
class Model
{
    use Database;
}

Common Queries

Reading records from a table:, _(*3)

$this->model->read('*');

Find records by column name:, _(*4)

$this->model->find('column, 'value');

Get a record by ID:, _(*5)

$this->model->get(1);

Delete a record by column name:, _(*6)

$this->model->delete('column, 'value');

Save records as an array (update if id is provided):, _(*7)

$this->model->save(['column' => 'value']);

Using Entities

class SampleEntity extends Drago\Database\Entity
{
    public const Table = 'name';
    public const PrimaryKey = 'id';

    public ?int $id = null;
    public string $sample;
}

Use the entity in a model:, _(*8)

#[From(SampleEntity::Table, SampleEntity::PrimarKey)]
class Model
{
    use Database;
}

Fetch records as objects:, _(*9)

$row = $this->model->find('id', 1)->record();

// Accessing properties
echo $row->id;
echo $row->sample;

Save Entity Records

To save entity data (update record if id is present):, _(*10)

$entity = new SampleEntity;
$entity->id = 1;
$entity->sample = 'sample';

$this->save($entity);

Advanced Features

Entity Class for Database Mapping

You can use a custom entity class with database mapping:, _(*11)

/** @extends Database<SampleEntity> */
#[From(SampleEntity::Table, SampleEntity::PrimaryKey, class: SampleEntity::class)]
class Model
{
    use Database;
}

// Fetch records directly as objects
$row = $this->model->find('id', 1)->record();

// Access the object's properties
echo $row->id;
echo $row->sample;

// Fetch all records
$allRecords = $this->model->read('*')->recordAll();