i am having php file like this..
<?php
define('HOST','localhost');
define('USER','root');
define('PASS','123');
define('DB','123');
$mysqli = new mysqli(HOST,USER,PASS,DB);
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
$mysqli->query("SET NAMES 'utf8'");
//$sql="SELECT via,events,doc FROM profile";
$sql="SELECT via, doc FROM profile";
$result=$mysqli->query($sql);
while($e=mysqli_fetch_assoc($result)){
$output["response"][]=$e;
//json_encode($output) = str_replace("\/", '/', json_encode($output));/* not working*/
}
echo(json_encode($output));
$mysqli->close();
?>
it is giving response like this.
{"response":[{"via":"19156001882722","doc":"http:\/\/oursite\/propic_uploads\/58.png"},{"via":"sunil holla","doc":"propic_uploads\/Fantasia Painting(29).jpg"}]}
how can i get the above response like this.I mean how to replace the above response with this one.
{"response":[{"via":"19156001882722","doc":"http://oursite/propic_uploads/58.png"},{"via":"sunil holla","doc":"propic_uploads/Fantasia Painting(29).jpg"}]}
can anyone please help me to get this...