CODEWITHSUNDEEP
phpandroidmysql
Chaithanya RC
Chaithanya RC

Reputation: 115

How to pass field values from database hosted on a server to android app using php?

I have a database hosted on server whose field values have to be passed to my app. I would like to do with PHP. But people suggest me to use JSON too. Is JSON required? Please guide me how to pass the field values to android app.

Upvotes: 2

Views: 42

Answers (3)

Radu Lupaescu
Radu Lupaescu

Reputation: 47

JSON means JavaScript Object Notation and it's just a way of formatting your output in a standard way.

So, if you'd like to pass data from a database to an application, you'd need to implement a small API. This can be done using PHP. At this point, you can access data from your database using a browser and parametrizing your queries using url parameters.

PHP can render the data in a simple HTML table for example, but this is just a way of presenting your data. You can also use JSON.

This means that if you need the badges a user has earned, you'll use something like this:

<link_to_your_api>/index.php?method=getBadges&user=<user>

This in turn, will make a request to the database

<?php
    // 1. connect to database
    // 2. query for the information
    // 3. get the result as array

    $result = $db->getData();

    echo json_encode($result);
?>

This is just an example, hope it helps.

link to json documentation: http://www.json.org/

Upvotes: 1

RH-indra Poudel
RH-indra Poudel

Reputation: 31

Create REST api using any server side script PHP,nodejs or any you like which returns JSON response

call the rest api using http request which returns JSOn text

decode the JSON string to JSON object and use with your android code

Upvotes: 0

RafToTheK
RafToTheK

Reputation: 86

You pass the data to your app, when it makes a request to your PHP script. JSON is handy because you can package your data in a format, that is both well readable by humans and machines. You can use the gson library then, to process the JSON data in your app.

Upvotes: 1

Related Questions