Bored is a PHP micro-framework. It provides a simple framework but you can bring things together in order to refine your own ad-hoc framework; just don't call the bored_run() function. The main documentation is the source code.
In a nutshell:
<?php
include('bored.php');
route('GET', '/hello/!name', function($name) {
return "Hello ${name}";
});
bored_run();
?>
Things bored will never have:
- An ORM
- A templating system
- Dependency injection
- Built-in database migration
- Unit testing
- More than 2000 SLOC.
Keep reading to learn about things bored do have.
It works like this:
route('GET', '/hello/?name', function($name = "Friend") {
return "Hello ${name}";
});
Argument prefixes are: !mandatory and ?optional.
Database facilities are based on the mysqli PHP extension. It mainly consists of a single function dbquery() which allows few but very convenient ways to interact with the database. In order to enabled the database you have to define four constants:
define('DBHOST', '');
define('DBUSER', '');
define('DBPASS', '');
define('DBNAME', '');
If one is missing, no DB connection gets opened and any call to dbquery() will fails. Once all of the above has been defined a connection to the DB is made available and it's possible to use dbquery(). Keep reading.
Fetch a single row:
$sql = "select id,username from users where id = 30";
$user = dbquery($sql);
print_r($user);
This will results in the following:
Array
(
[id] => 30
[username] => userfoo
...
)
Fetch multiple rows:
$sql = "select id,username from users";
$users = dbquery($sql, -1); /* -1 means no limit */
print_r($users);
This produces an output like this:
Array
(
[0] => Array
(
[id] => 248
[username] => userbar
...
)
[1] => Array
(
[id] => 425
[username] => userbaz
...
)
...
)
...
...
...
...
...