I am trying to get something like this:
[{
"id": "1",
"url": {
"small": "http://website/images/image.jpg",
"large": "http://website/images/image.jpg"
},
}]
My code is:
<?php
defined('DS') ? null : define('DS', DIRECTORY_SEPARATOR);
define('SITE_ROOT', "www.website.net/images/");
$con = mysqli_connect('localhost','test','test','test');
$sql="SELECT * FROM images";
$result=mysqli_query($con,$sql);
$response=array();
while ($row = mysqli_fetch_array($result)) {
$turl = SITE_ROOT.$row['id'].".jpg";
$url = str_replace("\/", "\\", $turl);
$json_Array[] = array('id'=>$row[id],'url'=>array('small'=>$url.$row[src],'large'=>$url.$row[src]));
}
echo(json_encode($json_Array));
mysqli_close($con);
?>
But after JSON Encoding, this is what I get:
[{
"id":"1",
"url":{
"small":"www.website.net\/images\/1.jpg",
"large":"www.website.net\/images\/1.jpg"
}
},
{"id":"2",
"url":{
"small":"www.website.net\/images\/2.jpg",
"large":"www.website.net\/images\/2.jpg"}
}]
I want the URL like www.website.net/images/1.jpg. I even tried using:
$turl = SITE_ROOT.$row['id'].".jpg";
$url = str_replace("\/", "\\", $turl);
But still getting those /. Any kind of help in this regard would be appreciated.