wcatron/mysql-db-framework

A MySQL ODM (assistant) extremely flexible for any project.

MySQL Framework PHP

A MySQL ODM (assistant) extremely flexible for any project., _(*1)

, _(*2)

Overview, _(*3)

This framework allows you to quickly map objects to rows in a MySQL database., _(*4)

Setup, _(*5)

Create models for your objects and have them extend Row. Implement the toRow and fromRow methods and set the TABLE and ID_COLUMN constants. Call MyDB::configure() in your autoload.php file or wherever needed before database calls. You can now perform queries and get php objects back., _(*6)

Installation

Composer

composer require wcatron/mysql-db-framework

Models & MDB

Models

Your classes. Add two functions and two constants and allow any model to create objects., _(*7)

class Your Class extends Row {
    /** @var LinkedObject */
    var $linkedObject;

    const TABLE = "table";
    const ID_COLUMN = "table_id";

    function __construct() {
        $this->setObjectForKey(LinkedObjectClass::class, 'linked_id', 'linkedObject');
    }

    function toRow() {
        $row = parent::toRow();
        // ... Add your fields to the row.
        return $row;
    }

    function fromRow($row) {
        parent::fromRow($row);
        // ... Set your fields.
    }
}

Saving is extremely simple when you have an object whose class extends row., _(*8)

$object->save();, _(*9)

MyDB

Your connection to mysql. To get your rows as objects use this singleton MyDB::getInstance(), _(*10)

getObjectByID(Class::class,$id), _(*11)

Alternatively you can just call getByID($id) on your custom Row object., _(*12)

This will return your exact object., _(*13)

getObjectsWithQuery(Class::class,$query), _(*14)

An array of objects based on a custom query. Not all queries need to be written out though., _(*15)

getObjectByColumn(Class::class, 'ColumnName', $value), _(*16)

If you're only searching by one column use this simple function., _(*17)