PHP code example of bera / bera-db

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

bera / bera-db example snippets




use Bera\Db\Db;

try {
    $db = new Db('music_app', 'localhost', 'root', '', null, true);
} catch( Bera\Db\Exceptions\DbErrorException $e  ) {
    echo $e->getMessage();
}


    $db->insert('songs', [
        'title' => 'A New Songs',
        'author' => 'dev',
        'duration' => 300
    ]);


 $db->update('songs', [
        'title' => 'Another Songs'
    ], ['id' => 1]);


$db->delete('songs', ['id' => 1]);


$db->query('SELECT * FROM songs')->all()
$db->query('SELECT * FROM songs WHERE id = ?', [1])->one()
$db->findAll('songs');
$db->findOne('songs', ['id' => 1]);


 $db = new Db('music_app', 'localhost', 'root', '', null, true);


 $db->setDebugMode(true)


 $db->insert('table_name', $data = [])


 $db->update('table_name', $data = [], $conditions = [])


 $db->delete($table, $conditions=[], $glue = 'AND')


 $db->deleteUsingAnd($table, $conditions=[])


 $db->deleteUsingOr($table, $conditions=[])


 $db->query($sql, $params = [])


 $db->getAffectedRows()


 $db->lastInsertId()


 $db->query($sql, $params = [])->one()


 $db->query($sql, $params = [])->oneAsObject()


 $db->query($sql, $params = [])->all()


 $db->findOne($table, $conditions = [], $glue = 'AND', $as = 'object');


 $db->findAll($table, $conditions = [], $glue = 'AND');


 $db->start_transaction()


 $db->end_transaction()