Making Javascript array with PHP

Question

So i'm making a google embedded page where i need some pinpoints declared. I want to store these in a database and get them the way you'd also fill a table with php.

My code should produce this:

['Street', coordinates, coordinates, ID],
['Street', coordinates, coordinates, ID],
['Street', coordinates, coordinates, ID],
['Street', coordinates, coordinates, ID]
etc.

Right now i got this:

<script type="text/javascript">
    var locations = [
        <?php while ($row2 = mysqli_fetch_array($result2)) {
        echo '[' . $row2['Straat'] . ',' . $row2['Noorderbreedte'] . ',' . $row2['Westerlengte'] . ',' . $row2['ID'] . '],';
    }
        ?>

Can't workout how this should work or if there is an easier way to just get database objects via JS.

why don't you make a XHR request to get that that on page load instead of writing the object in HTML? — Tomahock
– Tomahock, Commented Apr 20, 2016 at 10:32
Well, i had no idea such thing existed. But if you say it's easier. I might take a look into it. — Pieter Schreurs
– Pieter Schreurs, Commented Apr 20, 2016 at 11:44

Uttam Kumar Roy · Accepted Answer · 2016-04-20 10:18:18Z

1

You can use this

// declare an array
$json_array = array();
while ($row2 = mysqli_fetch_array($result2)) {
        // add this code
        $json_array[] = array(
            "{$row2['Straat']}",
            "{$row2['Noorderbreedte']}",
            "{$row2['Westerlengte']}",
            $row2['ID']
        );
        //echo '[' . $row2['Straat'] . ',' . $row2['Noorderbreedte'] . ',' . $row2['Westerlengte'] . ',' . $row2['ID'] . '],';
    }
?>
<script type="text/javascript">
var locations = <?php echo json_encode($json_array);?>

answered Apr 20, 2016 at 10:18

Uttam Kumar Roy

2,0584 gold badges24 silver badges30 bronze badges

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

2 Comments

Pieter Schreurs Over a year ago

Not yet, can I declare the PHP part in the javascript itself with php tags? The database objects don't get displayed on the google maps

Pieter Schreurs Over a year ago

Okay, it picks up the array and places it now, except the first one.

u_mulder · Accepted Answer · 2016-04-20 10:14:46Z

1

There's no need to invent a wheel. json_encode function will do what you need:

PHP:

$locations = array();
while ($row2 = mysqli_fetch_array($result2)) {
    $locations[] = array(
        $row2['Straat'],
        $row2['Noorderbreedte'], 
        $row2['Westerlengte'],
        $row2['ID']
    );
}

JS:

var locations = <? echo json_encode($locations)?>;

answered Apr 20, 2016 at 10:14

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

Collectives™ on Stack Overflow

Making Javascript array with PHP

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related