Encoding MySQL array result in JSON array notation

Question

$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]);

What code? And php or javascript? You should also dump the exact contents of your variables. — jeroen
– jeroen, Commented Jun 27, 2016 at 9:53
I am able to dump, but the dump will end up in [{datahere},{datahere}] , which is unable to be read by Javascript. My goal is to convert the SQL result in to a Javascript readable format, which is parsing it through a json_encode. But it is unable to be read due to the {} — Ctc
– Ctc, Commented Jun 27, 2016 at 9:54
var markers = <?php echo json_encode($markers); ?>;. But I don't think the way you are assigning values to position is going to work. — jeroen
– jeroen, Commented Jun 27, 2016 at 10:01

Dipanwita Kundu · Accepted Answer · 2016-06-27 10:34:03Z

1

Please try this way: Hopefully it will help:

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

echo json_encode($finalArray);

answered Jun 27, 2016 at 10:34

Dipanwita Kundu

1,6451 gold badge10 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

Encoding MySQL array result in JSON array notation

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest