A PHP library that allows you to easily create and define your models using PDO

• PDO wrapper
• FETCH_INTO made easy
• Model helper

$ composer require lodev09/php-models

The main \Models\DB class is a PDO wrapper used to make CRUD much easier. It is a forked code from the php-pdo-wrapper-class

// connect to your database. Store the $db instance globally -- you only need to connect to your db ONCE!
$db = new \Models\DB(DB_HOST, DB_NAME, DB_USER, DB_PASSWORD);

Available CRUD methods

• $db->insert($sql, $binds) or $db->insert($table, $values)
• $db->select($sql, $binds)
• $db->row($sql, $binds) (same with select but will return single row)
• $db->update($sql, $binds) or $db->update('table', $values)
• $db->delete($sql, $binds) or $db->delete('table', $filters)

The default style is PDO::FETCH_OBJ

Example:

$users = $db->select("SELECT * FROM users WHERE active = 1 AND username = :username", array('username' => 'lodev09'));
var_dump($users);

The \Models\Model class is a parent class that can be inherited to a Model class. Inheriting this class allows you to automatically map the result "row" into your model class (table). This class basically uses the PDO::FETC_INTO style and made it easier for you. Here are the steps to link your table into a class:

1. Initiate the \Models\DB instance (see above)

$db = new \Models\DB(DB_HOST, DB_NAME, DB_USER, DB_PASSWORD);
\Models\Model::setDb($db);

2. Create your model class. For example, a User.php class

namespace Models;
class User extends Model {
 public function getName() {
 return $this->name;
 }
}

3. Register your table to your custom class

// somewhere in your init.php
\Models\User::register('users');

Now, you can directly get the User instance from a query. Example:

$user = \Models\User::row("SELECT id, name FROM users WHERE id = 1 AND active = 1");
// you can call the getName() method now
if ($user) {
 $name = $user->getName();
 echo 'His name is '.$name;
}

All bugs, feature requests, pull requests, feedback, etc., are welcome. Visit my site at www.lodev09.com or email me at lodev09@gmail.com

© 2018 - Coded by Jovanni Lo / @lodev09

Released under the MIT License. See LICENSE file.