CODEWITHSUNDEEP
phpmysqlarraysjson
Ctc
Ctc

Reputation: 801

Encoding MySQL array result in JSON array notation

$markers =array();
$getmap = $mysqli->query("SELECT `desc`,`lat`,`long` FROM map");
$i=0;
$markers = $getmap->fetch_all(MYSQLI_ASSOC);
echo $markers[1]["desc"];
echo $markers;

$markers = json_encode($markers);

How is it possible such that these will flow properly and it will be read by the JS?
var position = (markers[i][lat], markers[i][long]);

Upvotes: 0

Views: 75

Answers (1)

Dipanwita Kundu
Dipanwita Kundu

Reputation: 1667

Please try this way: Hopefully it will help:

foreach($markers as $i=>$arrMarkes)
{
   $finalArray[$i] =  $arrMarkes; 
}

echo json_encode($finalArray);

Upvotes: 1

Related Questions