Create a RESTful Services API in PHP.
Wall Script
Follow Me:
Monday, May 14, 2012

Create a RESTful Services API in PHP.

Are you working with multiple devices like iPhone, Android and Web then take a look at this post that explains you how to develop a RESTful API in PHP.  Representational state transfer (REST) is a software system for distributing the data to different kind of applications. The web service system produce status code response in JSON or XML format.

Create a RESTful Services API in PHP.

Download Script

New Tutorial: Create a RESTful services using Slim PHP Framework

Developer
Arun Kumar Shekar
Arun Kumar Sekar
Engineer
Chennai, INDIA

Database
Sample database users table columns user_id, user_fullname, user_email, user_password and user_status.
CREATE TABLE IF NOT EXISTS `users`
(
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`user_fullname` varchar(25) NOT NULL,
`user_email` varchar(50) NOT NULL,
`user_password` varchar(50) NOT NULL,
`user_status` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Rest API Class: api.php
Contains simple PHP code, here you have to modify database configuration details like database name, username and password.
<?php
require_once("Rest.inc.php");

class API extends REST
{
public $data = "";
const DB_SERVER = "localhost";
const DB_USER = "Database_Username";
const DB_PASSWORD = "Database_Password";
const DB = "Database_Name";

private $db = NULL;

public function __construct()
{
parent::__construct();// Init parent contructor
$this->dbConnect();// Initiate Database connection
}

//Database connection
private function dbConnect()
{
$this->db = mysql_connect(self::DB_SERVER,self::DB_USER,self::DB_PASSWORD);
if($this->db)
mysql_select_db(self::DB,$this->db);
}

//Public method for access api.
//This method dynmically call the method based on the query string
public function processApi()
{
$func = strtolower(trim(str_replace("/","",$_REQUEST['rquest'])));
if((int)method_exists($this,$func) > 0)
$this->$func();
else
$this->response('',404);
// If the method not exist with in this class, response would be "Page not found".
}

private function login()
{
..............
}

private function users()
{
..............
}

private function deleteUser()
{
.............
}

//Encode array into JSON
private function json($data)
{
if(is_array($data)){
return json_encode($data);
}
}
}

// Initiiate Library
$api = new API;
$api->processApi();
?>

Login POST
Displaying users records from the users table Rest API URL http://localhost/rest/login/. This Restful API login status works with status codes if status code 200 login success else status code 204 shows fail message. For more status code information check Rest.inc.php in download script.
private function login()
{
// Cross validation if the request method is POST else it will return "Not Acceptable" status
if($this->get_request_method() != "POST")
{
$this->response('',406);
}

$email = $this->_request['email'];
$password = $this->_request['pwd'];

// Input validations
if(!empty($email) and !empty($password))
{
if(filter_var($email, FILTER_VALIDATE_EMAIL)){
$sql = mysql_query("SELECT user_id, user_fullname, user_email FROM users WHERE user_email = '$email' AND user_password = '".md5($password)."' LIMIT 1", $this->db);
if(mysql_num_rows($sql) > 0){
$result = mysql_fetch_array($sql,MYSQL_ASSOC);

// If success everythig is good send header as "OK" and user details
$this->response($this->json($result), 200);
}
$this->response('', 204); // If no records "No Content" status
}
}

// If invalid inputs "Bad Request" status message and reason
$error = array('status' => "Failed", "msg" => "Invalid Email address or Password");
$this->response($this->json($error), 400);
}

Users GET
Displaying users records from the users table Rest API URL http://localhost/rest/users/
private function users()
{
// Cross validation if the request method is GET else it will return "Not Acceptable" status
if($this->get_request_method() != "GET")
{
$this->response('',406);
}
$sql = mysql_query("SELECT user_id, user_fullname, user_email FROM users WHERE user_status = 1", $this->db);
if(mysql_num_rows($sql) > 0)
{
$result = array();
while($rlt = mysql_fetch_array($sql,MYSQL_ASSOC))
{
$result[] = $rlt;
}
// If success everythig is good send header as "OK" and return list of users in JSON format
$this->response($this->json($result), 200);
}
$this->response('',204); // If no records "No Content" status
}

DeleteUser
Delete user function based on the user_id value deleting the particular record from the users table Rest API URL http://localhost/rest/deleteUser/
private function deleteUser()
{

if($this->get_request_method() != "DELETE"){
$this->response('',406);
}
$id = (int)$this->_request['id'];
if($id > 0)
{
mysql_query("DELETE FROM users WHERE user_id = $id");
$success = array('status' => "Success", "msg" => "Successfully one record deleted.");
$this->response($this->json($success),200);
}
else
{
$this->response('',204); // If no records "No Content" status
}
}

Chrome Extention
A Extention for testing PHP restful API response download here Advanced REST client Application

.htaccess code
Rewriting code for friendly URLs. In the download code you just modify htaccess.txt to .htaccess
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-s
RewriteRule ^(.*)$ api.php?rquest=$1 [QSA,NC,L]

RewriteCond %{REQUEST_FILENAME} -d
RewriteRule ^(.*)$ api.php [QSA,NC,L]

RewriteCond %{REQUEST_FILENAME} -s
RewriteRule ^(.*)$ api.php [QSA,NC,L]
</IfModule>
Was this article helpful?
Thanks! Your feedback helps us to improve 9lessons.info


201 comments:

  1. pls post more about api i want to learn that

    ReplyDelete
  2. It's very nice , what about XML RPC

    ReplyDelete
  3. really usefull to me.. thanks a lot :)

    ReplyDelete
  4. That a very well but I want some more example & declaration pls provide this.Thank u

    ReplyDelete
  5. Kool man nice work .. i have used this one

    ReplyDelete
  6. Good job ! But it would be much better if you indent the Code with Tabs, as the code above is little difficult to understand

    ReplyDelete
  7. I will definitely try it out to develop demo API by myself and will try the same API for the android app development.

    Thank for sharing detailed article.

    ReplyDelete
  8. Very good tutorial! Thanks a lot!

    ReplyDelete
  9. Very good post as usual! Good work, Arun! :)

    ReplyDelete
  10. Could you explain how to get data? As I see in this script, in URL you send a name, that name is the name on the function. Further more _request is set to array. So you wrap everything in an array?? But then, how to extract, so you get correct function?? IM CONFUSED! And where to extend this so I can claim and API key ?

    ReplyDelete
  11. @KFllash32 : This is little bit tricky but more user friendly, api(api.php) demo class wrote like this way query string as a function. But you can write your own class insteed of api.php. Validating api key or headers and all up to you.

    ReplyDelete
  12. I have some experiences in this, so I figures out a way, but the Login function in the api.php will not work for most users because you also need email and username input. And something strange.
    You write this: $this->response('',204). And this will return nothing at all, because first param is '' (empty) and in the function you return data (data is the first param left empty). So what is the point with this one?

    ReplyDelete
  13. Every nice ... big thanks if i can have more tutorial

    ReplyDelete
  14. how to highlight your codes?

    ReplyDelete
  15. Your diagrams are impressive, what tool you use for that?

    ReplyDelete
  16. I heard PHP is not good for applying RESTfull because it does not integrate natively query functionality DELETE and PUT

    It's really?

    ReplyDelete
    Replies
    1. Well, that upto you what you think. But PHP is the best option for HTTP request in SSS.

      Delete
  17. thank this blog always saves me.I love your jobs and i stay tune.I ll try this API because i have a simillar projet and this will help i think so

    ReplyDelete
  18. well nice post keep it up for us to learn more...

    ReplyDelete
  19. Can any one explain this line in Sample database "users"

    ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

    ReplyDelete
  20. What did you use in making the illustration:
    https://lh6.googleusercontent.com/-u9hFxEK0OS8/T6a9yHaniHI/AAAAAAAAF_Y/prEsvdWrNtI/s550/rest.png

    ReplyDelete
  21. What about security :))?
    Write is you can how to use also with REST OAuth.
    Also do you know why some API uses such url
    site.com/api/create.json
    why the use dot?

    ReplyDelete
  22. Post more information regarding the REST modules and I want to integrate it with my application

    ReplyDelete
  23. nice sir.. Thank you for sharing always your ideas to us ..

    ReplyDelete
  24. i am having a problem getting Params such as email and Password for the sample Post function login()
    could it be htaccess?
    email and password keep coming in as null

    any suggestions? I have Sample Code

    ReplyDelete
  25. Well, this example ios really nice and working so far. I just wanna know if it's possible to request for a special user this way:

    http://localhost/rest/users/14

    GET: List info for user with ID of 14

    How do I manage it with your code? Is that possible?

    ReplyDelete
  26. how to pass request for deleteuser and login in url..

    pls explain someone

    ReplyDelete
  27. This is really nice and easy plugin. Can u plz tell me how to call 'login' function with POST menthod. Plz it's urgent. It wil be really great if you reply ASAP

    ReplyDelete
  28. This tutorial is not in detail for the person who is new to API. I was trying to create an API that inserts records to my db. I know i could use this, But i'm struggling

    ReplyDelete
  29. Hi,

    Can anyone tell how to use this api? Do I need to call it from other application? If yes, then how?

    ReplyDelete
  30. I always see Get request. How to change it to POST ?

    ReplyDelete
  31. Could you please post an example for inserting data using POST.

    ReplyDelete
  32. could you please post insert & fetch data using xml with rest

    ReplyDelete
  33. Can you explain the post methods. Means how can i post email and password

    thanks

    ReplyDelete
  34. thanks.... its enough to start with rest api for begginers

    ReplyDelete
  35. Hello,

    I am new to php, how to execute this program ?

    Can any one help.

    ReplyDelete
  36. what are de .ds_store and .htacces files for? regards!

    ReplyDelete
  37. To execute the program you must have php installed, and a web server.

    I'd suggest you look for tutorials for beginning php first. Then when you are comfortable, and know what REST is, then come back

    ReplyDelete
  38. not working how to see result of http://localhost/rest/users/??

    ReplyDelete
  39. How to call it for testing...

    ReplyDelete
  40. hi!
    can u explain me how use credential for calling REST resources after login?

    ReplyDelete
  41. Nice job Arun :D
    but are you sure that the returns in json?

    for example, i use your Rest.inc.php file for construct an api, and this file return that's

    string(508) " object(Api)#1 (8) { ["data"]=> string(0) "" ["db":"Api":private]=> resource(4) of type (mysql link) ["_allow"]=> array(0) { } ["_content_type"]=> string(16) "application/json" ["_request"]=> array(3) { ["rquest"]=> string(5) "login" ["Email"]=> string(15) "user1@gmail.com" ["Password"]=> string(5) "12345" } ["_resp"]=> array(1) { ["Id"]=> string(1) "1" } ["_method":"REST":private]=> string(0) "" ["_code":"REST":private]=> int(200) } "

    is json?

    ReplyDelete
  42. Very helpful... I can test it in php and working perfectly. But unable to call it in windows phone.
    So, Can you tell me how can I call it in Windows Phone apps.

    ReplyDelete
  43. Make sure to enable mod_rewrite in httpd.conf

    ReplyDelete
  44. I am getting this error:
    Notice: Undefined index: rquest in C:\server\www\jrserver.dev\public_html\rest\api.php on line 69

    ReplyDelete
  45. Thanks for the info !

    ReplyDelete
  46. @eureckou: you should pass the parameter rquest and value to that.
    for example. "http://localhost/rest/api.php?rquest=users" so that your rquest parameter will be passed and the value will be accessed in processApi(). Then the action will be taken according to your request.

    ReplyDelete
  47. Thanks for sharing

    ReplyDelete
  48. Hi, thanks for that good.. it took me a while to find any good and easy to use examples..

    One question.. When I use to Chrome extension to test the web service, the login and deleteUser function is not working.. During the debbuging I found out that $_GET and $_POST is just empty.. any idea why that happens?

    ReplyDelete
  49. plz tell me form where we can post the value and how can get post value within function....

    ReplyDelete
  50. Good tutorial but you know that the POST implementation is not working, right? There are a lot of people asking for help in the comments but I guess the author forgot about this post... It's a shame.

    ReplyDelete
  51. can anyone help me on how to access the service methods from the client code.

    ReplyDelete
  52. There is no impementation of any methods to add a user so to use the API you need to first add data into your database's 'users' table. Use an online md5 generator to create the password and make sure to have the field 'user-status' set to 1 if you want to get the data. To login (/login) use POST and variables 'pwd' and 'email' in Payload, to see users (/users use GET. To delete, no idea. Seems like dELETE is not accepted on my system (Chrome/Windows). I hope this will help some of you.

    ReplyDelete
  53. To delete users, there is an error: in Rest.inc.php, within the inputs() method, DELETE must be treated as PUT, not as GET as it is currently set.

    ReplyDelete
  54. Really helpful dude..thanks a lot.. :)

    ReplyDelete
  55. curl testing

    $ch = curl_init('http://api.local/deleteUser?id=2');
    curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "DELETE");
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    echo $result = curl_exec($ch);

    ReplyDelete
  56. curl testing

    $ch = curl_init('http://api.local/deleteUser?id=2');
    curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "DELETE");
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    echo $result = curl_exec($ch);

    ReplyDelete
  57. curl testing

    $ch = curl_init('http://api.local/deleteUser?id=2');
    curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "DELETE");
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    echo $result = curl_exec($ch);

    ReplyDelete
  58. Good I'd like to know how to call the api from jquery mobile application

    ReplyDelete
  59. Hi,
    Can you tell me please where from download Rest.inc.php?

    ReplyDelete
  60. To use it without problems make sure you have:
    apt-get install php5-curl

    ReplyDelete
  61. require_once("Rest.inc.php");

    from where i get it?

    ReplyDelete
  62. Not served in WAMPSERVER gives me a problem in the require_once ("Rest.inc.php");

    ReplyDelete
  63. Very helpful tutorial, thanks very much!

    ReplyDelete
  64. I am new to SOAP and REST which do you recommend me to learn and is easy to learn.

    ReplyDelete
  65. How do I use the private function login() section. If i have 2 inputs for username and password and I post the email and password to api.php how can I log that user in through private function login()?

    ReplyDelete
  66. Getting a 404 Not Found?
    Make sure to enable mod_rewrite in httpd.conf

    ReplyDelete
  67. we want to create api for prepaid mobile recharges & other kindly provide suggession to get it

    ReplyDelete
  68. Hi,

    I am trying to use this code and actually i am getting an notice like..


    Notice: Undefined index: rquest in C:\xampp\htdocs\rest\api.php on line 69

    Can you please explain what the problem..

    ReplyDelete
  69. nice post... Very helpful

    ReplyDelete
  70. hi guys. i am new to PHP. here i am using this api.php for webservice consuming to mobiles.can any one please tell me how can i use POST method for login function.

    my table name: user

    column names : email , password
    please urgent please.
    thanks in advance.

    ReplyDelete
  71. u can also use this to call with the style /users instead of api.php?rquest=users
    $func = trim(str_replace("/","",$_SERVER['REQUEST_URI']));
    $func = trim(str_replace("restcomicapp","",$func));
    $func = trim(explode("?",$func)[0]);

    ReplyDelete
  72. cool guy !
    have a nice year !
    ben

    ReplyDelete
  73. You dont kwown with means API REST.

    Example, with same URL:
    /resource/333

    diferent HTTP VERB (DELETE, POST, PUT, GET), Delete, create, update or GET de resource


    ReplyDelete
  74. hi am getting an error like

    Notice: Undefined index: rquest in C:\xampp\htdocs\rest\api.php on line 69

    What should I do

    ReplyDelete
  75. Nice tutorial.Thanks.Keep up the good work

    ReplyDelete
  76. Hi, thanks alot but i am new beginer with restful, can you help me how test demo?

    ReplyDelete
  77. Thank you for this! Simple, but it works for my little project.

    ReplyDelete
  78. can you explain me why do you get function by $func = strtolower(trim(str_replace("/","",$_REQUEST['rquest'])));

    I don't find any rquest variable.

    ReplyDelete
  79. how to upload byte array of image in php?

    thaks,
    srinivas

    ReplyDelete
  80. i'm new to php.here is api.php is a client code & Rest.cin.php is a server code? wt is the use of htaccess.txt and how to run?

    ReplyDelete
  81. hi its ok how to i run this script in my localhost

    ReplyDelete
  82. nice...very useful

    ReplyDelete
  83. this is awesome tutorial for learning api web application.it is very useful for developing android application.

    ReplyDelete
  84. We can make this without using REST keyword, So how we can ensure that its used REST API. Is there have any specific keyword for REST ? Please someone explain this.

    ReplyDelete
  85. hello I am not able to get response , plz help me

    ReplyDelete
  86. plz help me i am not geting response

    my web project name = rest

    request = http://localhost/rest/users

    htaccess = file same in example

    ReplyDelete
  87. Thanks a lot Arun, it really helped a lot.
    Cleraed my basic confusion about rest api and solved my purpose too.
    Keep it up.

    ReplyDelete
  88. Hello... Thanks for the tutorial...
    please how do i get to test what you have explained in this tutorial?

    ReplyDelete
  89. please i have tried implementing this but i i have not been able to consume the api in a client file.

    ReplyDelete
  90. Login is not worked for me. But i changed something like following...Now its working fine..

    Please use $_REQUEST to get params,

    if(isset($_REQUEST['email']) && isset($_REQUEST['pwd'])){
    $email = $_REQUEST['email'];
    $password = $_REQUEST['pwd'];

    // Input validations
    if(!empty($email) and !empty($password)){
    //keep all queries
    }
    }

    ReplyDelete
  91. ultimate tuts dude..keep it up.thnx alot

    ReplyDelete
  92. gud tut..
    can u help how to send response in json/xml
    if user send url as format/json or format/xml

    ReplyDelete
  93. nice post to learn

    ReplyDelete
  94. So this is what REST does. Thank you!

    ReplyDelete
  95. Hi I just Use you Rest API and also using rest client but every time I getting Response does not contain any data. Please Help

    ReplyDelete
  96. client side code for login:

    $user_data = array();

    $user_data['email'] = 'nss@gmail.com';
    $user_data['pwd'] = md5('test123');

    // cURL code
    $ch = curl_init('http://localhost/rest/api.php?request=login');

    curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");
    curl_setopt($ch, CURLOPT_POSTFIELDS, $user_data);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
    $response = curl_exec($ch);

    echo $response;

    $http_code = curl_getinfo($ch, CURLINFO_HTTP_CODE);
    curl_close($ch);

    echo $http_code;

    ReplyDelete
  97. HI , This is a very nice tutorial. GET request is working fine. But POST request is not working properly. Here is the solution,I tested this in mozilla rest client addon. Please enter json format data in request body [{"email":"ajayvaineela@yahoo.com","pwd":"123456"}].

    For reading that json code we need to add few lines in api.php.
    $request_body = file_get_contents('php://input');
    $json = json_decode($request_body);
    $email = $json[0]->email;
    $password = $json[0]->pwd;
    Thats all. In mozilla rest client addon at the time of executing pls select method type POST.
    Thanks..


    ReplyDelete
  98. Thanks for the lesson!
    In advance rest client->chrom i tried,
    http://localhost/rest/login/, to post the inputs, i face 400 Bad Request error when inputing the following json information:

    {
    "email":"mash@mst.fi",
    "password":"test123"
    }

    i wonder to know the way json should be inputed for posting the login information.

    ReplyDelete
  99. Hi, is really http://localhost/rest/deleteUser/ even rest?
    Shouldn't be somthing like DELETE http://localhost/rest/users/21 to be able to call it Rest?
    Where is the Uniform Interface in all this?

    You really should read this carefully: http://en.wikipedia.org/wiki/Representational_state_transfer

    ReplyDelete
  100. problem with your userID???
    try this:
    http://localhost/rest/users?id=2

    don't use:
    http://localhost/rest/users/2

    ReplyDelete
  101. try with:
    http://localhost/rest/users?id=2

    don't use:
    http://localhost/rest/users/2

    it's work

    ReplyDelete
  102. Hi, it was nice work for me Thanks

    ReplyDelete
  103. i am happy to see your new design

    ReplyDelete
  104. Hello! just start with this the rest api, I saw your code and if I understand but as implemented on a small website.

    ReplyDelete
  105. This error code is too generic. Can you give more info, a complete description of the error message, a picture, something more?
    Without more info, I won't be able to help you
    Thanks mate

    ReplyDelete
  106. how to run dis application?

    ReplyDelete
  107. thankyou very much for your sharing ! ^_^
    can you explain to me how htaccess file works?

    ReplyDelete
  108. Hi,
    I am getting


    Notice: Undefined index: email in D:\XMAPP\xampp\htdocs\rest\api.php on line 92



    Notice: Undefined index: pwd in D:\XMAPP\xampp\htdocs\rest\api.php on line 93

    {"status":"Failed","msg":"Invalid Email address or Password"}

    When i using http://localhost/rest/login API with post method

    ReplyDelete
  109. anything to insert data in to database???

    ReplyDelete
  110. nice post, so how to access this rest on Andorid with java code?? would you mind to give an example?? i had a code with web service server side on php then client side on java. but i didnt apply API REST to my code. im just a newbie,

    ReplyDelete
  111. can u please explain for beginners

    ReplyDelete
  112. How to use html form to post data to the function

    ReplyDelete
  113. Thanks for the great tutorial!

    ReplyDelete
  114. I like this tutorial. How to use this on web app?
    thanks in advance

    ReplyDelete
  115. How to use html form to post data to the function.Thanks for the great tutorial!

    ReplyDelete
  116. Nice tutorial AKS, easy and simple to understand.
    But as most of the people in this thread mentioned, I am also little stuck with the POST implementation. I am not sure, over here how to make POST request with login.
    When I use http://localhost/rest/login, I always get 406 (Not acceptable) in the headers (Request method being served as GET). But as you mentioned in the tut that it is Login POST, so can you/someone please share how to make a POST request for login. How can I test it on localhost?

    ReplyDelete
  117. It's very nice , what about XML RPC
    Thanks

    ReplyDelete
  118. Hi,
    I'm new to PHP im struggling with the htaccess configuration. I'm using port 8080 for my server localhost:8080



    RewriteEngine On

    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteCond %{REQUEST_FILENAME} !-s
    RewriteRule ^(.*)$ http://localhost:8080/api.php?rquest=$1 [QSA,NC,L]

    RewriteCond %{REQUEST_FILENAME} -d
    RewriteRule ^(.*)$ http://localhost:8080/api.php [QSA,NC,L]

    RewriteCond %{REQUEST_FILENAME} -s
    RewriteRule ^(.*)$ http://localhost:8080/api.php [QSA,NC,L]


    can anyone help me? Thanks in advance :D

    ReplyDelete
  119. nice tutorial really helpfull

    ReplyDelete
  120. why are we using htaccess configuration ? im a newbie

    ReplyDelete
  121. I created one record in the users table and then tried to run the api "localhost/rest/api.php?rquest=1 but I got a blank page. if I want to retrieve the data from the users database, how do I do it?

    ReplyDelete
    Replies
    1. me too, i received the blank page please need someone to help.

      Delete
    2. me too i receieved a blank page for this tutorial please someone to help
      thank you

      Delete
    3. user httpRequester or postman to post,get,delete,put data, rquest is ment to find the request method and it need not be in the url.

      Delete
  122. Hi i run the above script but i am getting an error, 'Fatal error: Class 'Rest' not found in C:\xampp\htdocs\rest\api.php on line 4 '. Please help me to fix this, thanks in advance :)

    ReplyDelete
  123. Mr Srinvas Tamada. Are you aware the deleteUser function doest function? Whenever a request is made (using the above recommended API client for chrome, nothing happens. It just returns a 204 no content error. I found out that the $id assignment doesn't work because $this->_request['Id] is blank. A searched the web and found out that this has to do with a complication with most web servers not allowing Delete requests, or a complication with PHP and delete requests, either way the delete request is the problem. I confirmed this by simply switch the request method for the deleteuser function to POST instead of delete and it worked. I'm not sure what you did to you Dev environment for it to work, or what environment you're using (I'm using the lateset XAMPP, BTW). Would you please correct me or your tutorial?
    Thanks for the great tutorial nonetheless.

    ReplyDelete
  124. THanks!!! very very good!

    ReplyDelete
  125. It really helps a lot. Thanks!

    ReplyDelete
  126. Nice tutorial for REST beginners, thanks!

    ReplyDelete
  127. How to pass parmater for insert data

    ReplyDelete
  128. Nice tutorial for beginners, Thanks.

    I am using same method for my api but stuck now.
    i have two urls
    1. api/users - to get all users which is done already
    2. api/users/search/id - to search user with id ( any keyword )

    can someone guide me on how to get it done ?

    ReplyDelete
  129. How to create a a function for url like api/users/edit/1 ?
    it simply update the user with id 1, values will be passed by POST

    ReplyDelete
  130. Suppose : i want to access data from a server through REST api System and the server link is www.test.com

    I do have the username and password .

    Now how to fetch the data...

    I tried using the firefox Add-On RESTclient 2.0.3 and it works...but i can't write the code of my own...

    i am trying since last week but unfortunately still unsuccessful :(

    Can you please help me....i haven't had much knowledge about REST..beginner you ca say.

    ReplyDelete
  131. How to Delete user from this
    http://localhost/CeederOn/rest/api.php?rquest=delete
    how to pass id actual i wanna ask

    ReplyDelete
  132. Nice Tutorial
    How can I call it with curl can you please help me?

    ReplyDelete
  133. $func = strtolower(trim(str_replace("/","",$_REQUEST['rquest'])));

    Can Some one help me in understanding, what this code line above does, cz am getting an error when ever I hit the api method

    the error is undefined index : rquest

    thanks

    ReplyDelete
  134. can you please explain how this api or urls will call in mobiles.what will be the connection?

    ReplyDelete
  135. please explain how the connection was built between api and android or ios or anything

    ReplyDelete
  136. how the urls are called from mobiles and connect to mysql and get the results?

    ReplyDelete
  137. great post , well explained and super understandable ... thank you very much !!!
    from Paraguay

    ReplyDelete
  138. It does not work for GET http://localhost/services/customer/1 (This is actual REST calls)
    But it works with http://localhost/services/customer?id=1

    What shall we do to make it work with such URL?

    ReplyDelete
  139. can you explain using CURL..

    how can we do that without using Chrome exetention

    ReplyDelete
  140. Simply, fantastic! Thanks

    ReplyDelete
  141. Hi,
    Please tell me anyone,
    get is working.
    how to test delete using chrome extension?

    ReplyDelete
  142. Something that worth reading... Thanx for the lesson

    ReplyDelete
  143. thanks for the tut it worked properly... but i have a prblm with .htaccess files i just want to add a new file like api.php to .htaccess. Can you please help me with these...

    ReplyDelete
  144. how to get youtube api and show in our web ?

    ReplyDelete
  145. how can i use this service with post key value parameter using poster

    ReplyDelete
  146. Here is the add user(insert):

    private function adduser(){
    // Cross validation if the request method is GET else it will return "Not Acceptable" status
    if($this->get_request_method() != "POST"){
    $this->response('',406);
    }
    $name = isset($_POST['name']) ? mysql_real_escape_string($_POST['name']) : "";
    $email = isset($_POST['email']) ? mysql_real_escape_string($_POST['email']) : "";
    $password = isset($_POST['pwd']) ? mysql_real_escape_string($_POST['pwd']) : "";
    $status = isset($_POST['status']) ? mysql_real_escape_string($_POST['status']) : "";
    $sql = mysql_query("INSERT INTO `users` (`user_id`, `user_fullname`, `user_email`, `user_password`, `user_status`) VALUES (NULL, '$name', '$email', '$password', '$status');", $this->db);
    if($sql){
    $success = array('status' => "Success", "msg" => "Successfully inserted");
    $this->response($this->json($success),200);
    }else{
    $this->response('',204); // If no records "No Content" status
    }

    ReplyDelete
  147. 301 error when i calling api.php?request=users

    ReplyDelete
  148. How can i create a page except api.php? I create a page mails.php but it is not working due to some htaccess issue. How can i solve it. I want to use another page for data insertion using cron job on the server. Please let me know, how can i execute the another page?

    ReplyDelete
  149. Very useful tutorial. But I have a problem in the login POST method - the email and password parameters are being passed empty as it is not entering in the IF condition.... and I am using Google Advanced Rest Client. Any help please?

    ReplyDelete
  150. I have a problem with delete method. When i tested using advanced rest client addon in chrome i cant get the id in request in php. Is there any problem with api.php.

    ReplyDelete
  151. Why does the POST method only work using x-www-form-urlencoded? Is it possible to send the parameters in JSON? I tried using JSON format but the parameters were sent empty. Any help please?

    ReplyDelete
  152. Thanks, it works for me, and do help me a lot.

    ReplyDelete
  153. please provide the rest api code using codeigniter.

    ReplyDelete
  154. Can some provide the NGINX configuration for this API.

    I m running on nginx server

    ReplyDelete
  155. I am getting the error Undefined index: email ,pwd on line 90,91
    $email="abc@gmail.com";
    $pwd="abcd";
    $strPost= 'email='.$email.'&pwd='.$pwd;
    in curl I am passing values like this
    curl_setopt($ch, CURLOPT_POSTFIELDS,$strPost);

    please help me

    ReplyDelete
  156. How we test the API?

    http://localhost/rest/users/ is referring me anything

    ReplyDelete
  157. Hi,

    I am trying to use this code and actually i am getting an notice like..


    Notice: Undefined index: rquest in C:\xampp\htdocs\rest\api.php on line 69

    Can you please explain what the problem..

    ReplyDelete
  158. Hi,

    I am trying to use this code and actually i am getting an notice like..


    Notice: Undefined index: rquest in C:\xampp\htdocs\rest\api.php on line 69

    Can you please explain what the problem..

    ReplyDelete


  159. Notice: Undefined index: rquest in C:\xampp\htdocs\rest\api.php on line 69


    iam getting this error how to handle it

    ReplyDelete


  160. Notice: Undefined index: email in C:\xampp\htdocs\rest\api.php on line 89



    Notice: Undefined index: pwd in C:\xampp\htdocs\rest\api.php on line 90

    {"status":"Failed","msg":"Invalid Email address or Password"}

    ReplyDelete
  161. hi,
    i am use odbc php but i have a problem. can you help me? please

    code -- code -- code --

    $sorgu="SELECT mno,durum FROM dba.masa";
    $sorgu=@odbc_exec($conn,$sorgu);
    if (!$sorgu) { echo"Sorgu Hatası"; }



    $result = array();

    while ($sorgu_yaz = odbc_fetch_array($sorgu)) {
    $result[] = $sorgu_yaz;
    }
    ..
    $this->response($this->json($result), 200);
    ..
    private function json($data){
    if(is_array($data)){
    return json_encode($data);
    }
    }



    this is not working pleasee help me

    ReplyDelete
  162. i am not able to change headers to json content type


    Host: localhost
    User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:43.0) Gecko/20100101 Firefox/43.0
    Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    Accept-Language: en-US,en;q=0.5
    Accept-Encoding: gzip, deflate

    ReplyDelete
  163. Hi,

    It is very useful for me...Thank you for this article...

    I have a issue to close the connection of MySQL. I am using destruct function for close the connection but it is not working...Please help me.

    here is the code,
    function __destruct() {
    mysql_close($this->db);
    }

    ReplyDelete
  164. you want use with html?that done using ajax.

    ReplyDelete
  165. Authors, you should answer to those questions asked in your blog, else this REST API a waste of time. I see there is a lot of unanswered questions up there. Please answer those. Thanks.

    ReplyDelete
    Replies
    1. Please try to use latest one http://www.9lessons.info/2014/12/create-restful-services-using-slim-php.html

      Delete

Make in India