- Clone https://github.com/tomkrush/bella
- Make sure bella is visible on server and target index.php for the unit tests.
- So far I can confirm that Bella runs on at least PHP 5.2.13.
The best place to check out examples is in the unit tests (bella/tests).
$users = new Table('users'); echo $users->project('*')->to_sql(); // Result: SELECT * FROM users $users = new Table('users'); $query = $users->where($users['name']->eq('bob')->otherwise($users['age']->lt(25)));
// Result: SELECT FROM users WHERE (name = 'bob' OR age < 25)
I had to rename to methods 'and' to 'also' and 'or' to 'otherwise'. This decision was made because PHP uses both keywords 'or' and 'and'.
If anyone finds words to better describe these methods message me.