CRUD library for MySQL with PDO
By ComStudio
$ composer create-project devstackgroup/cbase --stability=dev
# config/bootstrap.php
<?php
return [
'pdo' => new PDO(
'mysql:host=127.0.0.1;dbname=dbname',
'dbuser',
'dbpassword'
)
];
127.0.0.1
- host addressdbname
- database namedbuser
- database usernamedbpassword
- database password
<?php
require 'vendor/autoload.php';
use CBase\Query\Query;
$db = new Query(require_once 'config/bootstrap.php');
$db->setTable('test');
$db->create([
'field' => 1
]);
$db->close();
Read All with order by id DESC and limit 2 to assoc array
<?php
require 'vendor/autoload.php';
use CBase\Query\Query;
$db = new Query(require_once 'config/bootstrap.php');
$db->setTable('test');
$data = $db->read(['field'])
->orderBy([
'id' => 'DESC'
])
->limit(2)
->get([
'all' => true,
'fetch' => 'assoc'
]);
var_dump($data);
$db->close();
Read All to array
<?php
require 'vendor/autoload.php';
use CBase\Query\Query;
$db = new Query(require_once 'config/bootstrap.php');
$db->setTable('test');
$data = $db->read()
->get();
foreach ($data as $value) {
var_dump($value);
}
$db->close();
<?php
require 'vendor/autoload.php';
use CBase\Query\Query;
$db = new Query(require_once 'config/bootstrap.php');
$db->setTable('test');
$db->update([
'field' => 2
])
->where([
'id' => 1
])
->exec();
$db->close();
<?php
require 'vendor/autoload.php';
use CBase\Query\Query;
$db = new Query(require_once 'config/bootstrap.php');
$db->setTable('test');
$db->delete()
->where([
'id' => 1
])
->exec();
$db->close();