RESTp - RESTful web service for performing CRUD operations using PDOModel

URL demo
Documentation URL


RESTp is a high-level RESTFul web service developed in PHP that helps you perform crud operations.

It is built on top of the popular database abstraction script"PDO Model"And supports Mysql, sqlite, pgsql and MSSQL. You can easily perform insert/update/delete/read operations using RESTp api.

Most mobile and web applications need to use some API to communicate with the server to send and receive data.REST is by far the most used style of API design, especially in the mobile world.These mobile and web applications often require the use of APIs to perform crud operations, i.e. insert data, read data, update data, and delete data.Coding the crud operations for each individual mobile app and web app is a rather tedious task. This is where RESTp comes into play.

RESTp provides a single application based on REST architecture that helps you perform CRUD operations on any type of mobile and web applications.All you need to do is connect it to your database and it will automatically generate various resources to perform CRUD operations.

For each table in the database, it provides endpoints to perform CRUD operations. Below is an example of all RESTp api endpoints for a table
  • GET /{table_name} - retrieves a list of all records for table name "{table_name}"
  • GET /{table_name}/12 – Retrieves a specific records of table name “{table_name}” with ID 12
  • POST /{table_name} - create a new entry in {table_name}
  • PUT /{table_name}/12 - update the record with ID #12 in {table_name}
  • DELETE /{table_name}/12 - deletes the record with ID #12 {table_name}
So, if you have table name "orders" in your database, it will automatically generate standard rest endpoint like below.
  • GET /orders - Retrieves a list of all records with table name "orders"
  • GET /orders/12 – Retrieves a specific records of table name “orders” with ID 12
  • POST /orders - create a new order
  • PUT /orders/12 – Updates order #12
  • DELETE /orders/12 – Deletes order with ID #12

RESTp is built on top of our popular database abstraction script PDOModel. Therefore, users will also get a free copy of PDOModel (a $13 value).


You can use any kind of application to connect to the REST api. no matter how .NET web app or android mobile or iphone app or php web app, you can connect various apps to this api and perform CRUD operations.You can send data as json or normal form submission (x-www-form-urlencoded) and receive data as json, xml, html table.

Features

  • A single api to perform CRUD operations on any database
  • Supports many different databases (Mysql, PGSQL, SQLITE and SQLSERVER)
  • Built on top of the popular database abstraction script PDOModel
  • Supports multiple input and output types
  • Action filtering based on request type (GET, PUT, POST, DELETE)
  • Automatically generate endpoints based on table names
  • Support for pretty urls and non-pretty urls (if mod_rewrite is not enabled)
  • IP-based filters (allow IP-based access and block)
  • Allow or block access to specific tables (resources)
  • Authenticate with JWT

FAQs

What is rest?


What is the PDO model?

Requirements

  • PHP 5.3 or higher
  • CURL if you want to use CURL PHP connection

Credits

  • Managed LTE topic for demonstration purposes

RESTp - RESTful web service for performing CRUD operations using PDOModel [Free Download]
RESTp - RESTful web service for performing CRUD operations using PDOModel [Nulled]
PHP Scripts » Database Abstractions

METADATA
  • Files Included: JavaScript JS, JavaScript JSON, HTML, CSS, PHP, SQL
  • Software Version: PHP 7.x, PHP 5.3, PHP 5.4, PHP 5.5, PHP 5.6