PHP code example of danidoble / database

1. Go to this page and download the library: Download danidoble/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/ */

danidoble / database example snippets

 
use Danidoble\Database\Sql;

$users = Sql::from('users')->get();

var_dump($users);

 
use Danidoble\Database\Sql;

$users = Sql::from('users')->get();

var_dump($users);

 
use Danidoble\Database\Sql;

$user = Sql::from('users')->first();

var_dump($user);

 
use Danidoble\Database\Sql;

$user = Sql::from('users')->find(1);

var_dump($user);

 
use Danidoble\Database\Sql;

$user = new Sql();
$user->name = "Gregory";
$user->last_name = "Hui";
$user->save();

 
use Danidoble\Database\Sql;

$user = Sql::from('users')->id('name_id')->find(1);
$user->name = "somthing else";
$user->save();

 
use Danidoble\Database\Sql;

$user = Sql::from('users')
    ->set('name','Pedro')
    ->set('last_name','Crox')
    ->where('name','Gregory','=')
    ->update();

 
use Danidoble\Database\Sql;

$user = Sql::from('users')->find(1);
$user->delete();

 
use Danidoble\Database\Sql;

$user = Sql::from('users')->find(1);
$user->forceDelete();