mor/mdb

Database orm for php

v1.1.0 2021-11-27 14:47 UTC

Requires

• symfony/dotenv: ^5.3

MIT

• mohammadreza Haghshenas

README

Setup

Require mdb with composer:

composer require mor/mdb

use Mor\Mdb\Mdb;

Change your database server details in .env file under src:

DB_DRIVER=mysql
DB_SERVER=localhost
DB_NAME=test
DB_USERNAME=root
DB_PASSWORD=
DB_CHARSET=utf8mb4

Mdb supports Mysql.

Create Table

$tableName = "users";
$args = [
    "id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY",
    "email VARCHAR(50)",
    "firstname VARCHAR(30) NOT NULL",
    "lastname VARCHAR(30) NOT NULL"
];

Mdb::createTable($tableName, $args);

For this in args, you should know how sql defines it's cols. (for mysql)

Insert Data

$table = "users";
$data = [
    "email"=>"[e-mail]",
    "firstname"=>"somefirstname",
    "lastname"=>"somelastname"
];

Mdb::table($table)->insert($data);

Update Data

$table = "users";
$data = [
    "email"=>"[e-mail]"
];

Mdb::table($table)->where('email', '[e-mail]')->update($data);

Get Data

$table = "users";

Mdb::table($table)->getAll(); // Gets all rows
Mdb::table($table)->first(); // Gets first row
Mdb::table($table)->last(); // Gets last row

Get All

$cols = "firstname,lastname"; // Columns - default is *
$limit = "2" // Limit of rows - default is 0 (unlimited)

Mdb::table('users')->getAll($cols, $limit);
// For first() and last() method, they only get $cols parameter.

Where

Mdb::table('users')->where('id', 1)->getAll();

You can use where method as many as you want.

Mdb::table('users')->where('firstname', "somefirstname")->where("lastname","somelastname")->getAll();

Where with operator

Mdb::table('users')->where('id', 1, ">")->getAll();

orWhere

Mdb::table('users')->where('id', 1)->orWhere('id', 2)->getAll();
// orWhere with operator is the same as where.

Where with Array

You can pass an array with data to whereArray method.

$data = [
    "firstname"=>"somefirstname",
    "lastname"=>"somelastname"
];

Mdb::table('users')->whereArray($data)->first();

Order By

Mdb::table('users')->order('id', 'DESC')->getALL();

Get Count of rows

Mdb::table('users')->where('id',1,'>')->countOfRows(); // return int

Delete data

Mdb::table('users')->where('email','[e-mail]')->delete();