Redbeanphp

require ‘rb.php’;
$db = require ‘../config/config_db.php’;
R::setup($db[‘dsn’], $db[‘user’], $db[‘pass’], $options);
R::freeze(true);
R::fancyDebug( TRUE );
var_dump(R::testConnection());
Создание таблиц в базе
$cat = R::dispense(‘category’);
$cat->title = ‘Категория 3’;
$id = R::store($cat);
var_dump($id);

Read
$cat = R::load(‘category’, 2);
print_r($cat);
echo $cat->title; $cat->title;

Update-1
$cat = R::load(‘category’, 3);
echo $cat->title . ‘<br>’;
$cat->title = ‘Категория 3’;
R::store($cat);
echo $cat->title;
Update-2
$cat = R::dispense(‘category’);
$cat->title = ‘Категория 3!!!’;
$cat->id = 3;
R::store($cat);

Delete po ID
$cat = R::load(‘category’, 2);
R::trash($cat);

Delete po ALL
$cat = R::wipe(‘category’);

$cats = R::findAll(‘category’, ‘id > ?’, [2]);
$cats = R::findAll(‘category’, ‘title LIKE ?’, [‘kate’]);
$cat = R::findOne(‘category’,’id = 2′);
echo ‘<pre>’;
print_r($cat);