How to create REST API for Android app using PHP, Slim and MySQL – Day 1/2

I am so looking forward to the next article. This is looking very interesting

It’s useful, thanks.

Very useful and nice presentation.

Thanks for your great articles and projects all over androidhive.info

Awesome article! I’m relay looking forward for next one!

Good article. Looking forward to the next one.

Nice Article,very interesting…..and waiting for the next one…… 🙂

Nice one

Easy to understand as usual… Thanks.. Waiting for next one.

Nice post @Ravi Tamada:disqus… Got to know about Slim framework through this post.. 🙂

Ravi, just curious, are you using Eclipse or Android Studio for this?

Ravi sir not getting how to put value in header, pls help me

Very nice article for beginners of REST. Thank you so much Ravi.

Thank you so much. It’s very good article.

Very nice tutorial ravi, i have a question regarding a security issue:
1) How can i handle an expiration date for the api-key? because if i store the api-key in SharedPreferences and send the api_key everytime with the request, the user will be forever logged in

Hii ravi i am geting
{
error: true
message: “Required field(s) name, email, password is missing or empty”
}

please tell me how to solve this problem i am stcing from 2 days …where is fault i am not getting and its telling 404 bad request…

The third part would be sweet!

HI RAVI,

I HAVE NOT FIND ANY GOOD EXAMPLE TO PARSE REST API USING JSON PARSING CAN HELP ME.

Very good explanation with diagrams and videos. Thanks a lot.

How can we implement this tutorial on hosting?

Thankyou so much ravi……. It’s nice article to learn REST API for the beginners….

The tutorial was excellent.It works fine for me in localhost but not on live server.On uploading the project to live server i got 404 not found exception..Anyone came across this issue..Pls help….

Hello there,
I want to download the sources of the tutorial but when I sign up, I never get the email that would validate my account.
How can I do?

Thank you in advance

Excellent tutorial, Thank you very much!!

I am confused! Why I need the slim framework and if it must, how can i create one for myself. Please also guide me through the android app code (I already know the “Connecting sql to android” part.

Hi,
First thank you for the tutorial it’s really great.

I try to test the REST API but I’ve got some problems.
I work on LAMP (Debian), I download the source from you website (thanks) but when I try to test with Advanced Rest Client I’ve got the 404 error

If you have some ideas about where is the problem I’ll be very grateful

Thank you, Have a nice day

Hi, I still have tried it yet but can you please explain how to do a multipart-data method? a simple example for the register method with a profile image would be great!
Thank you for all these tutorials,especially for image caching!

Ravi, what are advantages/disadvantages of Slim framework over other more popular solutions like Restlet and Spring? Why did you chose Slim? Thank you

Your download code button isn’t working 🙁

I appreciate the tutorial. Using the mysql native driver really caused me fits though. I couldn’t (and still can’t) get it working under MAMP or AMPPS, so I re-wrote all the database handler stuff using PDO.

Hello,

Thank you for the tutorial Ravi.

Is there somebody succeed to run the code on LAMP ?
If you have advice to do it, I would be grateful… sorry if it’s stupid but I’m a noob :s

Bye

Hi Ravi,

Thanks for the tutorial, helped me a great deal.

For those struggling with get_result error in php.
index.php:

/**
* Listing all tasks of particual user
* method GET
* url /tasks
*/
$app->get(‘/tasks’, ‘authenticate’, function() {
global $user_id;

$response = array();
$db = new DbHandler();

// fetching all user tasks
$result = $db->getAllUserTasks($user_id)

;

if (!$result)

throw new Exception(“Database Error [{$this->database->errno}] {$this->database->error}”);

if ($result != NULL) {
$response[“error”] = false;

$response[“tasks”] = array();

// looping through result and preparing tasks array
foreach ($result as $task)
{
$tmp = array();
$tmp[“id”] = $task[“id”];

$tmp[“task”] = $task[“task”];
$tmp[“status”] = $task[“status”];
$tmp[“createdAt”] = $task[“created_at”];

array_push($response[“tasks”], $tmp);
}
echoRespnse(200, $response);
}
else
{
$response[“error”] = true;

$response[“message”] = “The requested resource doesn’t exists”;
echoRespnse(404, $response);
}
});

DB_Handler.php:

public function getAllUserTasks($user_id) {
$stmt = $this->conn->prepare(“SELECT t.id, t.task, t.status, t.created_at from tasks t, user_tasks ut WHERE t.id = ut.task_id AND ut.user_id = ?”);

$stmt->bind_param(“i”, $user_id);
$tasks = array();
if ($stmt->execute())
{
$stmt->bind_result($id, $task, $status, $created_at);

while($stmt->fetch())
{
$tmp = array();

$tmp[“id”] = $id;
$tmp[“task”] = $task;
$tmp[“status”] = $status;

$tmp[“created_at”] = $created_at;

array_push($tasks, $tmp);
}
}
$stmt->close();
return $tasks;
}

Hi Ravi,

Thanks a lot for your work. It is helping me and a lot of people.

Actually, I am developing an app to upload a file from android phone to a remote server which needs authentication. UploadToServer.php file is present in that server which helps in receiving the file from the phone and stores in the server in required path. But to run this php file from the URL in the app, authentication must be given to the app.

I would like to know how to provide this authentication (login details) to the URL (to run php file in server) present in my android app. Normally in various blogs, I can only see examples without authentication.

Thanks you very much,
Raj Bharath

Hi ravi,wonderful work,could you tell me how to deploy rest api in the market ,means where from to buy domain,,any help would be great..

I want to use a REST api (for example the above api) in my php script for my website.How do I call them for registering users like in forms using $_POST ?

public static class Webservice_ValidUser {
//private static final String URL = “http://api.ogoing.com/user.asmx?op=ValidUser”;
private static final String URL = urlmain+”user.asmx?op=ValidUser_New”;
private static final String SOAP_ACTION_NEW = “http://www.ogoingapi.com/ValidUser_New”;
/**
* Getting Contact information
*
* @param attendeeCredentials
* @param inSeqNum
* @return GetAttendeesContactInfoResponse
*/
public static JSONObject callWebServiceJson(String UserName, String Password, String DeviceId) {
JSONObject jsonObj = null;

String ValidLogin = “”
+ “”
+ “” + “”
+ “” + UserName + “” + “”
+ Password + “” + “” + portal
+ “” + “” + DeviceId + “”
+”android”
+ “” + “” + “”;

DefaultHttpClient httpClient = new DefaultHttpClient();
String envoloper = String.format(ValidLogin);
// request parameters
HttpParams params = httpClient.getParams();
HttpConnectionParams.setConnectionTimeout(params, 10000);
HttpConnectionParams.setSoTimeout(params, 15000);
// set parameter
HttpProtocolParams.setUseExpectContinue(httpClient.getParams(),true);
// POST the envelope
HttpPost httppost = new HttpPost(URL);
// add headers
// Set Method Action
httppost.setHeader(“soapaction”, SOAP_ACTION_NEW);
httppost.setHeader(“Content-Type”, “text/xml; charset=utf-8”);
String response = “”;
try {
// the entity holds the request
HttpEntity entity = new StringEntity(envoloper);
httppost.setEntity(entity);
// Response Handler
ResponseHandler responseHandler = new ResponseHandler() {
@Override
public String handleResponse(HttpResponse response)
throws ClientProtocolException, IOException {
// get response entity
HttpEntity entity = response.getEntity();
// read the response as byte array
StringBuffer out = new StringBuffer();
byte[] b = EntityUtils.toByteArray(entity);
// write the response byte array to a string buffer
out.append(new String(b, 0, b.length));
return out.toString();
}
};
// Getting the response
response = httpClient.execute(httppost, responseHandler);
// Sending the Response to parsing class
String stt[] = response.split(“”);
String stt2[] = stt[1].split(“”);
Log.i(“”, “stt” + stt);
Log.i(“”, “stt2” + stt2);
String my_string = stt2[0];

Spanned abc = Html.fromHtml(Html.fromHtml(my_string).toString());
String my_final_string = abc.toString();

jsonObj = new JSONObject(my_final_string);
String uname = jsonObj.getString(“UserName”);
Log.i(“uname” + uname, “my_string” + my_string);
} catch (Exception exc) {
exc.printStackTrace();
}
return jsonObj;
}

try

{

HttpClient httpclient = new DefaultHttpClient();

HttpPost httppost = new HttpPost(“http://vmss.co.in/smarttransport/getdetail.php”);

MultipartEntity data_to_send = new MultipartEntity(

HttpMultipartMode.BROWSER_COMPATIBLE);

data_to_send.addPart(“journeyId”, new StringBody(journeyId));

data_to_send.addPart(“delete”, new StringBody(“1”));

httppost.setEntity(data_to_send);

HttpResponse response = httpclient.execute(httppost);

HttpEntity entity = response.getEntity();

is = entity.getContent();

result=is.toString();

if(result != null)

{

flag = true;

}

}catch(Exception e)

{

Log.e(“log_tag”, “Error in http connection”+e.toString());

}

if(flag == true)

{

try

{

System.out.println(“1″);

BufferedReader reader = new BufferedReader(new InputStreamReader(is,”iso-8859-1”),8);

System.out.println(“2”);

sb = new StringBuilder();

System.out.println(“3”);

sb.append(reader.readLine() + “n”);

String line=”0″;

while ((line = reader.readLine()) != null)

{

sb.append(line);

}

is.close();

result=sb.toString();

System.out.println(“else “+result);

}catch(Exception e)

{

}

}

return null;

}

Simply superb tutorial..keep it up man!!! you helped me manier times before…thank you so much 🙂

Many thanks.

Hi, Ravi or Anyone.
Does anyone knows where i can find a good tutorial on how to consume (use) this restfull api from my android application?

thanks a lot @Ravi Tamada:disqus

Hai sir,
Could you plse tell me where i get example api’s for doing jsonparsing.

Ravi, I’ve a doubt. Why 3 tables?.

Can i add a new column to `tasks` named `user_id` which refers to the user’s id who made the task (FK). ?? Is that a bad approach ??

great article, very helpful! thank you

Anyone got this working in LAMP?BTW very helpful tutorial

Hi, great tutorial, thanks!

Where is the one for the android implementation?

how show the users from database in Advanced Rest Client

please help need index.php for registration and login

How can I get solve my problem of api key is missing

Please help. I get this error while listing user’s tasks :-
PHP Fatal error: Call to undefined method mysqli_stmt::get_result()