============= RapidREST allows you to have a working CRUD API in sixty seconds!
=============
I've been looking build simple test applications that implement API's as a learning experience but dreaded the time commitment for designing databases and doing the actual programming for an application I'd abandon after three days. Architecting a clever, re-usable way to handle database access was my main problem so I started PHP Model Buddy. Months have gone by and my dwindling free time to experiment has left me with a half-finished database access framework.
I recently discovered RedBeanPHP and my problem was solved. If you're not familiar with it, RedBeanPHP is an on-the-fly ORM for PHP. Want to create a record in a table that doesn't exist? Boom, the table and columns are made. It's absolutely perfect if you want to get up and running quickly.
Rather than re-inventing the wheel I decided to use Slim Framework in RapidREST to handle the API routes. Check /config/routes.php and you'll thank me for doing so.
=============
You'll need an apache server with mod_rewrite and PHP >= 5.3.0
Composer is needed to install the dependencies.
php composer.phar create-project andrew-natoli/rapid-rest -sdevgit clone https://github.com/AndrewNatoli/PHP-RapidREST.gitNow use composer to install Slim Framework and RedBeanPHP.
sudo php composer.phar updateOpen /config/rapidrest-config.php to configure your database connection.
Enjoy your CRUD API!
============= There are five base universal routes in RapidREST. They're perfect for prototyping small applications but I suggest removing and re-writing their controllers before moving your app to production if it's going to be public.
ReadBeanPHP will automatically build the table schema for you based on the information you send.
Returns all of the records and their contents in the specified table.
{
"statuscode": 200,
"data": [{
"id": "1",
"title": "Important Message",
"text": "Hello, world!"
}, {
"id": "2",
"title": "Also important",
"text": "This is a message"
}],
"count": 2
}Returns the specified record from a table.
{
"statuscode": 200,
"data": [{
"id": "1",
"text": "Bacon!",
"title": "Important Message"
}]
}Creates a new record in the table.
{
"statuscode": 200,
"data": {
"id": 3
}
}Updates an existing record in the table.
{
"statuscode": 200,
"data": {
"id": 2
}
}Deletes a record from the table.
{
"statuscode": 200,
"deleted": true
}============= These return a JSON response by the way. If a record can't be found, updated, created, etc. the program will spit out a JSON error message.
GET requests will list the found record(s) within the "data" array:
POST and PUT will return the ID of the created (or updated) record:
DELETE will response with whether not a record was deleted.
Exceptions look like this:
{"message":"Record not found.","statusCode":404}============= As mentioned earlier, you'll probably want to remove the stock API routes and controllers when you take your application public. This is a quick guide to where everything is so you can evolve your RapidREST Prototype API into a production-worthy API.
Kill the process and return a JSON-encoded error message!
use API\Exceptions\APIException
throw new APIException("Record not found!",404);It's reccomended you use the Response classes rather than simply using json_encode() to allow for easy changes to your code in the future. You can extend the base JSON or abstract Response class and define your own methods to whitelist values or output additional data.
use API\Response\JSON
$response = array();
$response['data'] = $array_or_object;
return new JSON($response);============= Pull requests welcome :)
============= Cheers to necenzurat for devising a way of installing RedBeanPHP through composer.
https://github.com/necenzurat/redbeanphp-composer
And of course, Cheers to the developers of Slim Framework and RedBeanPHP.
=============
Copyright (c) 2014 Andrew Natoli
Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:
The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.