RESTp - RESTful web service for performing CRUD operations using PDOModel

RESTp is an advanced RESTFul Web service developed using PHP that helps you to perform crud operation. You can automatically generate all endpoints for crud operation of your database.

Demo url Documentation url

It is built 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 require 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 is a REST-based solution that simplifies CRUD operations for any mobile or web application. With RESTp, you simply connect it to your database, and it automatically generates all the necessary resources to handle CRUD operations, saving you valuable time and effort.

For every table in database, it provides endpoints to perform CRUD operations. 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 a 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 kinds 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 request 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