Create a RESTful Services API in PHP.
Wall Script
Wall Script
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>
web notification

222 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
    2. Hello Kumar, I appreciate your comment and contribution on this article. Please if one need to pass a parameter to the login function in this article, how do I do that through the url? Assume you are calling the service from an android application and you need to pass the email and password to the url as parameter. I will appreciate a respond to this question please.

      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) "[email protected]" ["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. 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
  48. plz tell me form where we can post the value and how can get post value within function....

    ReplyDelete
  49. 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
  50. can anyone help me on how to access the service methods from the client code.

    ReplyDelete
  51. 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
  52. 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
  53. 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
  54. 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
  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. Good I'd like to know how to call the api from jquery mobile application

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

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

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

    from where i get it?

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

    ReplyDelete
  61. Very helpful tutorial, thanks very much!

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

    ReplyDelete
  63. 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
  64. Getting a 404 Not Found?
    Make sure to enable mod_rewrite in httpd.conf

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

    ReplyDelete
  66. 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
  67. nice post... Very helpful

    ReplyDelete
  68. 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
  69. 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
  70. cool guy !
    have a nice year !
    ben

    ReplyDelete
  71. 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
  72. 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
  73. Nice tutorial.Thanks.Keep up the good work

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

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

    ReplyDelete
  76. 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
  77. how to upload byte array of image in php?

    thaks,
    srinivas

    ReplyDelete
  78. 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
  79. hi its ok how to i run this script in my localhost

    ReplyDelete
  80. nice...very useful

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

    ReplyDelete
  82. 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
  83. hello I am not able to get response , plz help me

    ReplyDelete
  84. plz help me i am not geting response

    my web project name = rest

    request = http://localhost/rest/users

    htaccess = file same in example

    ReplyDelete
  85. 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
  86. Hello... Thanks for the tutorial...
    please how do i get to test what you have explained in this tutorial?

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

    ReplyDelete
  88. 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
  89. ultimate tuts dude..keep it up.thnx alot

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

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

    ReplyDelete
  92. 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
  93. client side code for login:

    $user_data = array();

    $user_data['email'] = '[email protected]';
    $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
  94. 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":"[email protected]","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
  95. 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":"[email protected]",
    "password":"test123"
    }

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

    ReplyDelete
  96. 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
  97. problem with your userID???
    try this:
    http://localhost/rest/users?id=2

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

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

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

    it's work

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

    ReplyDelete
  100. i am happy to see your new design

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

    ReplyDelete
  102. 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
  103. how to run dis application?

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

    ReplyDelete
  105. 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
  106. anything to insert data in to database???

    ReplyDelete
  107. 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
  108. can u please explain for beginners

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

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

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

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

    ReplyDelete
  113. nice tutorial really helpfull

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

    ReplyDelete
  115. 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
  116. 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
  117. 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
  118. THanks!!! very very good!

    ReplyDelete
  119. It really helps a lot. Thanks!

    ReplyDelete
  120. Nice tutorial for REST beginners, thanks!

    ReplyDelete
  121. How to pass parmater for insert data

    ReplyDelete
  122. 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
  123. 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
  124. 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
  125. How to Delete user from this
    http://localhost/CeederOn/rest/api.php?rquest=delete
    how to pass id actual i wanna ask

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

    ReplyDelete
  127. $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
  128. can you please explain how this api or urls will call in mobiles.what will be the connection?

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

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

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

    ReplyDelete
  132. 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
  133. can you explain using CURL..

    how can we do that without using Chrome exetention

    ReplyDelete
  134. Simply, fantastic! Thanks

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

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

    ReplyDelete
  137. 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
  138. how to get youtube api and show in our web ?

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

    ReplyDelete
  140. 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
  141. 301 error when i calling api.php?request=users

    ReplyDelete
  142. 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
  143. 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
  144. 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
  145. 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
  146. Thanks, it works for me, and do help me a lot.

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

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

    I m running on nginx server

    ReplyDelete
  149. I am getting the error Undefined index: email ,pwd on line 90,91
    $email="[email protected]";
    $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
  150. How we test the API?

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

    ReplyDelete
  151. 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
  152. 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


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


    iam getting this error how to handle it

    ReplyDelete


  154. 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
  155. 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
  156. 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
  157. 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
  158. you want use with html?that done using ajax.

    ReplyDelete
  159. 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
  160. giving me 404 error

    ReplyDelete
  161. http://localhost/rest/login/, to post the inputs, i face 400 Bad Request error when inputing the following json information:

    {
    "email":"[email protected]",
    "password":"test123"
    }

    ReplyDelete
  162. 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
  163. Very helpful article.Appreciating

    ReplyDelete

mailxengine Youtueb channel
Make in India
X