A small & simple ORM solution for PHP


1 Design your database

2 Run the model builder

3 Behold a beautiful PHP model


Make the world a little bit better...




ORM


Object-relational mapping (ORM) is a technique that lets you query and manipulate data from a database using an object-oriented paradigm. When talking about ORM, most people are referring to a library that implements the Object-Relational Mapping technique, hence the phrase "an ORM".

This free-open-source and super easy to use ORM tool generates beautiful PHP classes based on your database's meta-data.
Like this:

/*
 * Returns a Contact by contactId
 * @param  $id
 * @return $contact
 */
public function find($id)
{
    $q="".

    "SELECT contactId,".
           "contactName,".
	   "contactEmail,".
	   "contactPhone,".
	   "contactSubject,".
	   "contactMessage,".
	   "contactCreated,".
	   "contactModified,".
	   "contactSource,".
	   "contactStatus ".
    "FROM  contact ".
    "WHERE contactId=".$id;

    $r=$this->selectDB($q,"Contact");
    return($r);
}







FAQ


The PHP model builder requires PHP 5.6 or newer

At the moment we are only supporting mysql However, Oracle, Microsoft SQL Server and PostgreSQL development is underway.

The PHP model builder uses a database first strategy. First model a normalized relational database. then run the modelBuilder script. The code generator builds Entity-Objects for each table and view in the database, complete with methods for find(), insert(), update() and delete()

Documentation is included in the download package




Questions? -- Answers?