RedBeanPHP Cheat Sheet - Revision history

Admin at 21:45, 11 January 2016

2016-01-11T21:45:28Z

Admin at 17:13, 10 January 2016

2016-01-10T17:13:41Z

Admin at 17:08, 10 January 2016

2016-01-10T17:08:21Z

Admin at 23:18, 9 January 2016

2016-01-09T23:18:51Z

Admin: Created page with "[http://www.redbeanphp.com/index.php RedBeanPHP site] I love RBPHP since it's single file light-weight x-DB and clean ORM. -- my opinion (R) -- This is by no means complete ..."

2016-01-09T23:05:13Z

Created page with "[http://www.redbeanphp.com/index.php RedBeanPHP site] I love RBPHP since it's single file light-weight x-DB and clean ORM. -- my opinion (R) -- This is by no means complete ..."

New page

[http://www.redbeanphp.com/index.php RedBeanPHP site]

I love RBPHP since it's single file light-weight x-DB and clean ORM. -- my opinion (R) --

This is by no means complete cheat sheet; many things were left out, see [http://www.redbeanphp.com/index.php full documentation] for all tips and tricks.

== Basics and CRUD ==

[http://www.redbeanphp.com/index.php?p=/download Download RedBeanPHP]

<pre>require 'rb.php';
R::setup();

// create a new bean, and setting some properties (member and array access supported);
// the bean name has to be lowercase alphabetical;
// properties names have to contain only alphanumeric and underscore
$book = R::dispense('book');
$book->title = 'Learn to Program';
$book['rating'] = 10;
$book['price'] = 29.99;

// save it - if table does not exist, RBPHP will create it based on added properties;
// if it does exist, RBPHP will update the table to hold any new data, if necessary
$id = R::store($book);

// reading a bean by ID, or multiple by array of ID's
$book = R::load('book', $id);
$books = R::loadAll('book', $ids);

// updating a bean
$book->title = 'Learn to fly';
$book->rating = 'good'; // rating will be changed from integer to varchar
$book->published = '2015-02-15'; // column will be added, type 'date'; R::isoDate() and R::isoDateTime() generate current date(time)
R::store($book);

// deleting a bean or multiple beans
R::trash($book);
R::trashAll($books);

// delete all beans of given type
R::wipe('book');

// destroy the whole DB
R::nuke();

// reload bean from DB
$bean = $bean->fresh();</pre>

== Select / Query ==

<pre>$book = R::find('book', 'rating > 4');
$books = R::find('book', 'title LIKE ?', ['Learn to%']); // with bindings
$promotions = R::find('person', 'contract_id IN ('.R::genSlots($contractIDs).')', $contractIDs); // R::genSlots() will generate proper number of '?' for bindings
$book = R::findOne('book', 'title = ?', ['SQL Dreams']); // returns single bean, not array; NULL if none found

// find all, no WHERE's
$books = R::findAll('book');
$books = R::findAll('book' , 'ORDER BY title DESC LIMIT 10');

// all of find(), findOne(), and findAll() support named slots
$books = R::find('book', 'rating < :rating', [':rating' => 2]);

// using cursors - saves on loading
$collection = R::findCollection('page', 'ORDER BY content ASC LIMIT 5');
while($item = $collection->next())
// process bean $item

// find with multiple possible values
R::findLike('flower', ['color' => ['yellow', 'blue']], 'ORDER BY color ASC');

// if the bean does not exist, it's created
$book = R::findOrCreate('book', ['title' => 'my book', 'price' => 50]);</pre>

@@ Line 12: / Line 12: @@
 <pre>require 'rb.php';
 R::setup();
 // create a new bean, and setting some properties (member and array access supported);

@@ Line 52: / Line 52: @@
 // reload bean from DB
 $bean = $bean->fresh();</pre>
 == Select / Query / Transactions ==

@@ Line 4: / Line 4: @@
 This is by no means complete cheat sheet; many things were left out, see [http://www.redbeanphp.com/index.php full documentation] for all tips and tricks.
 == Basics and CRUD ==
@@ Line 23: / Line 25: @@
 // if it does exist, RBPHP will update the table to hold any new data, if necessary
 $id = R::store($book);
 // reading a bean by ID, or multiple by array of ID's
@@ Line 47: / Line 53: @@
 $bean = $bean->fresh();</pre>
-== Select / Query ==
+== Select / Query / Transactions ==
 <pre>$book = R::find('book', 'rating > 4');
@@ Line 70: / Line 76: @@
 // if the bean does not exist, it's created
-$book = R::findOrCreate('book', ['title' => 'my book', 'price' => 50]);</pre>
+$book = R::findOrCreate('book', ['title' => 'my book', 'price' => 50]);

@@ Line 51: / Line 51: @@
 <pre>$book = R::find('book', 'rating > 4');
 $books = R::find('book', 'title LIKE ?', ['Learn to%']);    // with bindings
-$promotions = R::find('person', 'contract_id IN ('.R::genSlots($contractIDs).')', $contractIDs);    // R::genSlots() will generate proper number of '?' for bindings
+$promotions = R::find('person', 'contract_id IN ('.R::genSlots($contractIDs).')', $contractIDs);    // R::genSlots() generates ?'s for bindings
 $book = R::findOne('book', 'title = ?', ['SQL Dreams']);    // returns single bean, not array; NULL if none found