RESTp – RESTful web service for performing CRUD operations using PDOModel

Demo url

Documentation url

RESTp is an advanced RESTFul Web service developed using PHP that helps you to perform crud operation.

It is build on top of the popular database abstraction script
“PDOModel”
and supports Mysql, sqlite, pgsql and MSSQL. You can easily perform Insert/Update/Delete/Read operation using RESTp api.

Most of the Mobile and Web Apps requires communication with server using some API to send and received data. REST is by far the most commonly-used style for designing APIs, especially in the mobile world.
These Mobile and web apps often requires to perform crud operation i.e Insert data, read data, update data and delete data using API.
To write code for the crud operations for each individual mobile app and web app is quite cumbersome task. That’s where RESTp comes into action.

RESTp provides a single application based on REST architecture that helps you to perform CRUD operation on any kind of mobile and web apps. All you need to do is to connect it to your database and it automatically generates all kind of resources to perform CRUD operation.

For every tables in database, it provides endpoints to perform CRUD operation. An example of all RESTp api endpoints for a table are below

• GET /{table_name} – Retrieves a list of all records of table name “{table_name}”
• GET /{table_name}/12 – Retrieves a specific records of table name “{table_name}” with ID 12
• POST /{table_name} – Creates a new entry in {table_name}
• PUT /{table_name}/12 – Updates record of ID #12 in {table_name}
• DELETE /{table_name}/12 – Deletes record with ID #12 {table_name}

So if you have table name “orders” in your database, it automatically generate standard rest end points as below.

• GET /orders – Retrieves a list of all records of table name “orders”
• GET /orders/12 – Retrieves a specific records of table name “orders” with ID 12
• POST /orders – Creates a new order
• PUT /orders/12 – Updates order #12
• DELETE /orders/12 – Deletes order with ID #12

RESTp is build on top of our popular database abstraction script PDOModel. So users will get free copy of PDOModel also (worth $13).

You can use any kind of application to connect to RESTp api. Whether it is .NET web app or android mobile or iphone app or php web app, You can connect all kind of application to this api and perform CRUD operation. You can send data either as json or normal form submission (x-www-form-urlencoded) and received data as json, xml, html table.

Features

• Single api to perform CRUD operation on any database
• Supports multiple different database (Mysql, PGSQL, SQLITE and SQLSERVER)
• Build on top of popular database abstraction script PDOModel
• Multiple Input and Output types supported
• Action filtering as per request type (GET, PUT, POST, DELETE)
• Autogenerates endpoint as per the table names
• Supports pretty url as well as non pretty urls (if mod_rewrite not enabled)
• IP based filters (Allow access and block based on IP)
• Allow or block access of particular table (resource)
• Authentication using JWT

FAQs

What is Rest?
REST means “REpresentational State Transfer”. It is an architectural style for developing web services.
REST requires that a client make a request to the server in order to retrieve or modify data on the server.

What is PDOModel?
PDOModel – Database abstraction and helper PHP class that helps to do insert,
update, delete, select operation using PDO without writing any queries and with much lesser code.
It supports Mysql, Postgres,SQlite and SQL Server database.PDOModel provides a complete solution to
perform CRUD operations on three different types of database (Mysql, Postgres and Sqlite).

For more details about PDOModel, please
click here

Requirements

• PHP 5.3 or higher
• CURL if you want to connect using CURL PHP

Credits

• Admin LTE theme for demo purpose