$results=array() ; 

while($row = mysql_fetch_assoc($r)){
	$results[] = array('subject' => $row['subject'], 'description' => $row['description']) ;
}
		  
$ret= json_encode($results) ;
echo $ret;

jidez007: Try laravel php framework, its really easy creating an api with it.

spikesC:

Why framework when he doesn't even know how the basic works

spikesC:

Why framework when he doesn't even know how the basic works

Djangocode: @op Pls do take a look at this topic
www.brenelz.com/blog/how-to-create-a-simple-api-with-php-and-mysql/

phatjoe50:

I am a newbie in PHP. Maybe you can guide me with any resource that can help.

jidez007:
I don't tink its compulsory he learns all d basics b4 he can use laravel. E.g using Post::all() will return all d posts in d database as json being d default mode and there are many other easy syntax dat can b used.
Although I won't recommend diving in without knowing d basics of php including oop.

spikesC:

Search for OReilly RESTful Web Services

I have never read it but coming from Oreilly, it must be good.

Creating an api is basically same thing you've been doing with PHP except of course, the format response you're sending out, being json

{
users: [{
"id": "18",
"geTitle": "Gabe's Senior Painting Thesis",
"getDesc": "As a Studio Art major at Wesleyan",
"getAmount": "5600000",
"getDays": "23",
"getArticle": "As a Studio Art major at Wesleyan, I am about to begin work on my senior thesis in painting. !",
"url": "http://localhost/seeds/viewpost.php?id=18",
"time": "2014-10-09"
},

phatjoe50: Thanks guys I have eventually solved the issue, which was just a case of ignorance from me.

I was developing an API for a website and I forgot that every section of a website or blog has a corresponding link or url, which I neglected when developing my API.

Being so naughty I was calling the url which I didn't create in the API from my JAVA with the getString() method passing my url as the key like this getString("url". Absolutely nothing wrong with this only that I didn't create it in my API, LOL. It was after series of debugging today that I got to see the mistake.

My JSON output now look like this.

[code]


Before the JSON was without the "url" JSONObject.

Thanks for the help. Really Appreciate.

jidez007:
Becareful so u won't expose a user's password

jidez007:
Becareful so u won't expose a user's password

dhtml: Interesting. . . . .