Android JSON Parsing | PHP Scripts and Validate JSON

Question

I have a database in phpmyadmin panel. And I want to see this databases as json format. When I paste my link to http://jsonlint.com/. It says Null. What's wrong with my php script?

<?php

$host = "**";
$user = "**";
$password = "**";
$db = "**";

$sql = "select * from product_info;";
$con = mysqli_connect($host,$user,$password,$db);

$result = mysqli_query($con,$sql);
$response = array();

while($row = mysqli_fetch_array($result)){
    array_push($response,array("name"=>$row[0],"email"=>$row[1],"mobile"=>$row[2]));
}

echo json_encode(array("server_response"=>$respose));
mysqli_close($con);

?>

Mathias Müller · Accepted Answer · 2016-02-14 16:38:23Z

0

You are missing a letter in the word "response" on the echo line. That's why you are getting NULL.

Replace

echo json_encode(array("server_response"=>$respose));

By this

echo json_encode(array("server_response"=>$response));

Also, you should set the header to application/json

header('Content-Type: application/json');

Final code should be:

header('Content-Type: application/json');

echo json_encode(array("server_response"=>$response));

edited Feb 14, 2016 at 16:38

Mathias Müller

22.7k13 gold badges62 silver badges78 bronze badges

answered Feb 14, 2016 at 16:34

dontanios

3332 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kaan Karaca Over a year ago

It's working now. Thank you very much for your attention. I have a question. Is there any PHP compiler for this spelling errors?

wogsland · Accepted Answer · 2016-02-14 16:26:58Z

0

You have a typo ($respose) in the line

echo json_encode(array("server_response"=>$respose));

which should be

echo json_encode(array("server_response"=>$response));

answered Feb 14, 2016 at 16:26

wogsland

9,53121 gold badges63 silver badges99 bronze badges

Collectives™ on Stack Overflow

Android JSON Parsing | PHP Scripts and Validate JSON

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related