peej/php-rest-sql

Play with our RESTful database interface with our interactive REST tutorial

PHP REST SQL

A HTTP REST interface to MySQL written in PHP

Description

PHP REST SQL is a class used to open a HTTP REST interface to a MySQL database using PHP and a HTTP server. Using standard HTTP requests, the data in a database can be created, retrieved, modified and deleted.

Requirements

PHP REST SQL was built and tested using Apache 2.0.45, PHP 4.3.4, and MySQL 3.23, although it should work with any version of PHP4 and MySQL and any HTTP server that will pass requests of all HTTP method types to PHP.

REST Browser

The database can be queried using a regular Web Browser, but to send the appropriate HTTP PUT, POST and DELETE requests you'll need a REST browser.

The Poster Firefox extension allows you to easily craft HTTP requests from within Firefox.

Installation

Place all the files in a directory in your Web servers docroot and edit the config file "phprestsql.ini" with your database information and the URL path to the directory.

To use tidy URLs, an example .htaccess file is included for the Apache Web server and the mod_rewrite module. Without mod_rewrite PHPRestSQL URLs will use the querystring and default document behavour to envoke the PHP script for the variety of URLs required by the RESTful interface.

php-rest-sql's Issues

php-rest-sql in afnetworking

How to use these php-rest-sql with AFNetworking in iOS. Please help me to solve this . When i am trying to connect server getting following error

2014-11-28 14:49:11.104 AFNetworkingTwo[2235:69667] Error: Error Domain=com.alamofire.error.serialization.response Code=-1011 "Request failed: not found (404)" UserInfo=0x7af6bf30 {com.alamofire.serialization.response.error.response=<NSHTTPURLResponse: 0x7af7a3b0> { URL: http://test.ile-china.com/api/mdl_content_module/?PHP_AUTH_PW=&PHP_AUTH_USER=root } { status code: 404, headers {
Connection = close;
"Content-Length" = 0;
"Content-Type" = "text/html";
Date = "Fri, 28 Nov 2014 09:19:04 GMT";
Server = "Apache/2.2.17 (Win32) PHP/5.3.5";
"X-Powered-By" = "PHP/5.3.5";
} }, NSErrorFailingURLKey=http://test.ile-china.com/api/mdl_content_module/?PHP_AUTH_PW=&PHP_AUTH_USER=root, NSLocalizedDescription=Request failed: not found (404), com.alamofire.serialization.response.error.data=<>}

Direct access to phprestsql.ini

You can display phprestsql.ini config in the browser
http://example.com/phprestsql.ini

One of the solution is to add:

RewriteRule phprestsql.ini !^$

to .htaccess

Warning Deprecated feature in PHP 5.4

Trying to access the index.php file via PHP 5.4.16 on Windows XP, I have :

Deprecated: Assigning the return value of new by reference is deprecated in [...]\index.php on line 5

It can be resolved by removing the '&' at the line 5 in the index.php

multiple databases

Is it possible to use php-rest-sql with multiple databases?

accessing MySQL-views lead to 0 byte response

When using MySQL-Views (for example to provide a merged dataset) it is shown like a usual table at the database overview however accessing it leads to a 0 byte response

Where querys

Is it possible to do a query with a where clause like in sql? If so would you mind providing some example code?
If not: that would be a really great enhancement.