How to store values from PHP variables to Javascript?

Question

I am new to web technologies and I want to create a web app that allows a user to click on a map and a form will pop up and it will allow him to enter certain information. That information is saved on a database. Now I don't know how to pull that information because I need to create markers on the map with the longitude and latitude as its position. I don't know how to pass values from php variables to javascript

<?php
    require_once("mysqli_connect.php");

    $query = "SELECT * FROM markeri";

    $response = @mysqli_query($dbc, $query);

    if($response){
        while($row = mysqli_fetch_array($response)){
            $naziv = $row['naziv'];
            $opis = $row['opis'];
            $email = $row['email'];
            $latitude = $row['latitude'];
            $longitute = $row['longitute'];


        }
    }

?>

This is the code for pulling data from the database. Now I need to create markers on the map with all the information from the database.

var marker = L.marker(e.latlng);
marker.addTo(mymap).bindPopup(form).openPopup();

<div id="form">
    </br>
    Naziv:</br>
    <h1 id="naziv"></h1></br></br>
    Opis problema:</br>
    <p id="opis"></p> </textarea></br>
    E-mail:</br>
    <h3 id="email"> </h3></br></br>
</div>

I am using the Leaflet API for interaction with the map. I need to create markers by replacing e.latlng(which is a JS array) with latitude and longitude pulled from the database with PHP and to make a marker at that position. I need to fill the information in the "form" above as well for each individual marker.

This is the table in the database:

Using Ajax? After save, do AJAX request to PHP which will return JSON you need. And then just populate data into HTML. — Mykola Borysyuk
– Mykola Borysyuk, Commented Nov 20, 2016 at 15:19
@MykolaBorysyuk How would you do that ? I don't know how to store the information that I looped through. — Gigaxel
– Gigaxel, Commented Nov 20, 2016 at 15:39

Mykola Borysyuk · Accepted Answer · 2016-11-20 15:47:29Z

1

if you have Jquery just do http://api.jquery.com/jquery.ajax/

$.ajax({
  method: "GET",
  url: "some.php"
})
.success(function(res) {
    //If all ok you will get Object as a responce
    console.log(JSON.parse(res));
});

Insode you some.php script $data is object that you need.

echo json_encode($data);

Now just in success handler. Loop and add elements into table, div,whatever using JQuery or pure JavaScript.

Looks like this. http://api.jquery.com/append/

$( "p" ).append( "<strong>Hello</strong>" );

You may want to check other methods. This is just example.

Hope this helps.

answered Nov 20, 2016 at 15:47

Mykola Borysyuk

3,4211 gold badge22 silver badges24 bronze badges

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

Collectives™ on Stack Overflow

How to store values from PHP variables to Javascript?

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

Related