JSON wont show mysql data correctly :using php

Question

i want to connect to a database server using php , and then echo the data as JSON so later i can use it in android but JSON shows / as \/ for example if http://www.google.com/ was in the database if shows it as

"http:\/\/www.google.com\/" .

i made connections and all and here is how i fetch the data

try {
    $stmt   = $db->prepare($query);
    $result = $stmt->execute($query_params);
}catch (PDOException $ex) {
    $response["success"] = 0;
    $response["message"] = "Database Error1. Please Try Again!";
    die(json_encode($response));
}
while($row = $stmt->fetch(PDO::FETCH_ASSOC))
$array[] = $row;
echo json_encode($array);

You must have added slashes before placing in the database, use php.net/manual/en/function.stripslashes.php — Jay Blanchard
– Jay Blanchard, Commented Jul 17, 2014 at 15:31
i use that after the while , on the row string , it say's u must use it on a string not an array , i dont know where to put it — user3469432
– user3469432, Commented Jul 17, 2014 at 15:37
either you're on a stone-age PHP with register_globals enabled, or you're double-escaping going into the DB or pulling out of the db. — Marc B
– Marc B, Commented Jul 17, 2014 at 15:39

jeroen · Accepted Answer · 2014-07-17 15:51:14Z

1

This is valid json and the correct way to encode it, see http://codepad.viper-7.com/6PbdmJ

When you decode it in for example javascript or php, you will get your original URL back:

javascript:

JSON.parse('"http:\/\/www.google.com\/"');

php:

var_dump(json_decode(json_encode('http://www.google.com/')));

edited Jul 17, 2014 at 15:51

answered Jul 17, 2014 at 15:45

jeroen

91.8k22 gold badges118 silver badges132 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:13:08Z

1

You need to decode you json ... run that PHP example and you will understand what i mean:

$encode = json_encode("https://www.google.com/");

echo $encode;

echo "<br />";

echo json_decode($encode,true);

so, if you sending encoded json, you should decode it in android to use it properly.

This link should help: How to parse JSON in Android

edited May 23, 2017 at 12:13

CommunityBot

11 silver badge

answered Jul 17, 2014 at 15:44

Angelo Berçacola

1737 bronze badges

Collectives™ on Stack Overflow

JSON wont show mysql data correctly :using php

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related