Micro-db
Micro-db is a lightweight ORM library.
Installation
First you need to install Composer. You may do so by following the instructions at getcomposer.org. Then run
composer require fullstackpe/micro-db
If you prefer you can create a composer.json in your project folder.
{
"require": {
"fullstackpe/micro-db": "^1.1"
}
}Then run the command
composer install
The ActiveRecord Class
If you have a table called book. You need to create an active record Class
called Book that extends the Class micro\db\ActiveRecord. The class Book
needs to implement two methods: tableName() and dbConnection().
Example
use micro\db\ActiveRecord;
class Book extends ActiveRecord {
public static function tableName()
{
return 'book';
}
public static function dbConnection()
{
$servername = "127.0.0.1";
$username = "root";
$password = "fullstack";
$database = "mysql";
return new \micro\db\Connection($servername, $username, $password, $database);
}
}Then you can instantiate the class.
Example
// Create a new book
$book = new Book();
$book->title('This is the title of my book');
$book->save();
// fetchs all books
$books = Book::find()->all();
foreach($books as $book) {
echo $book->title;
}
// search for one book
$condition = [
['=', 'id', '1']
];
$book = Book::find()->where($condition)->one();
echo $book->titleThe QueryBuilder Class
The queryBuilder class builds a Sql statement.
Example
$table = 'home';
$qB = new \micro\db\QueryBuilder();
$columns = [
'id',
'name',
'address'
];
$sql = $qB->select($columns)->from($table)->getRawSql();The variable $sql is equal to the string "SELECT id, name, address FROM home".
Contribution
Feel free to contribute! Just create a new issue or a new pull request.
License
This library is released under the MIT License.
