Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- AJAX-ul:
- <?php
- $servername = "sql203.byethost31.com";
- $username = "xxx";
- $password = "xxx";
- $dbname = "xxx";
- // Creaza conexiunea
- $conn = new mysqli($servername, $username, $password, $dbname);
- // Verifica conexiunea
- if ($conn->connect_error) {
- die("Conexiunea a esuat: " . $conn->connect_error);
- }
- $latitude = mysqli_real_escape_string($_GET['latitude']);
- $longitude = mysqli_real_escape_string($_GET['longitude']);
- echo $latitude;
- echo $longitude; //Verificare variabile trimise prin AJAX
- mysqli_query($conn, "UPDATE coord SET Latitude=$latitude" ) or die mysqli_error(); //Actualizare valori coordonate in db
- mysqli_query($conn, "UPDATE coord SET Longitude=$longitude" ) or die mysqli_error(); //Actualizare valori coordonate in db
- ?>
- JavaScript-ul:
- <p>Click the button to get your coordinates.</p>
- <button onclick="getLocation()" class="btn btn-default">Try It</button>
- <p id="demo"></p>
- <script>
- var x = document.getElementById("demo");
- function getLocation() {
- if (navigator.geolocation) {
- navigator.geolocation.getCurrentPosition(showPosition);
- } else {
- x.innerHTML = "Asigurati-va ca aveti GPS-ul pornit!";
- navigator.geolocation.getCurrentPosition(showPosition);
- }
- }
- function showPosition(position) {
- x.innerHTML = "Latitudine: " + position.coords.latitude +
- "<br>Longitudine: " + position.coords.longitude; //Verificare variabile
- }
- var latitude = "test"
- var longitude = "test"
- if (window.XMLHttpRequest) {
- xmlhttp = new XMLHttpRequest();
- xmlhttp.open("GET", "ajax.php?latitude=" + latitude + "&longitude=" + longitude , true);
- xmlhttp.send();
- return false;
- }
- //Transfer valori variabile din JS in PHP
- </script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement