PHP code example of mhmmdq / database

1. Go to this page and download the library: Download mhmmdq/database library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php.

    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

mhmmdq / database example snippets




/* Add autoloader to php file */
onnection([
    'driver'=>'mysql',
    'host'=>'localhost',
    'port'=>'',
    'username'=>'root',
    'password'=>'',
    'charset'=>'utf8mb4',
    'collation'=>'utf8mb4_general_ci',
    'database'=>'oop'
]);


use Mhmmdq\Database\QueryBuilder as DB;

$db = new DB();


$db->table('users');


$users = $db->table('users')->get();
var_dump($users);


$users = $db->table('users')->toJson();
echo $users;


$users = $db->table('users')->toJson(false);
echo $users;


$users = $db->table('users')->toArray();
var_dump($users);


$users = $db->table('users')->get();
echo $db->rowCount();


$users = $db->table('users')->select('username,email')->toJson();
echo $users;


$users = $db->table('users')->orderBy('id','DESC')->get();


$db->table('users')->count();


$db->table('users')->max('score');


$db->table('users')->min('score');


$db->primaryKey('columnName');


$users = $db->table('users')->where('6')->get();


$users = $db->table('users')->where('username','mhmmdq')->get();


$users = $db->table('users')->where('name','LIKE','%Mohammad%')->get();


$users = $db->table('users')->where('name','mohammad')->where('age','>','18')->get();


$users = $db->table('users')->limit(6)->get()


$user = $db->table('users')->first()


$user = $db->table('users')->find('username','mhmmdq');


$user = $db->table('users')->find('username','mhmmdq','json');


$db->notFoundView($path);


$user = $db->table('users')->findOrFail('username','mhmmdq');


$users = $db->table('users')->pagination(5)->get()


echo $db->links();


echo $db->links([
        'linksNumber'=>'8',
        'classList'=>[
            'nav'=>'Page navigation example',
            'ul'=>'pagination',
            'li'=>'page-item',
            'li:active'=>'active',
            'a'=>'page-link'
        ]
]);


$db->insert('users',[
   'username'=>'user1',
   'email'=>'[email protected]',
   'password'=>password_hash('12345678',PASSWORD_DEFAULT),
]);


$validate = [
    'username'=>'uniq|min:6|max:255',
    'email'=>'uniq|email'
];


$db->insert('users',[
   'username'=>'user1',
   'email'=>'[email protected]',
   'password'=>password_hash('12345678',PASSWORD_DEFAULT),
],$validate);


$db->update('users',[
        'username'=>'mhmmdqasemi'
],['username','mhmmdq']);


$validate = [
    'username'=>'uniq|min:6|max:255',
];
$db->update('users',[
        'username'=>'mhmmdqasemi'
],['username','mhmmdq'],$validate);


$db->delete('users',['id','8']);