Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- output += '<li><a href="#detail" onclick="affichedetail()">'+ field.nom + '</a></li><li>'+field.dist+'KM</li><li><img src="' + './photo/' + field.photo + '" height="100" width="100"</img></li><li>Latitude:' + field.lat + '</li><li>Longitude:' + field.longitude + '</li><li>Aprés:' + delai2 + '</li>';
- // alert(var1);
- // alert(var2);
- });
- $('#mosquee').html(output).listview("refresh");
- // here we will handle errors and validation messages
- });
- <?php
- $con=mysqli_connect("localhost","root","","priere");
- // Check connection
- if (mysqli_connect_errno())
- {
- echo "Failed to connect to MySQL: " . mysqli_connect_error();
- }
- $result="";
- $valeur = $_GET['requete'];
- print("id="+$valeur);
- $result = mysqli_query($con,"SELECT lat,longitude FROM mosque where id=$valeur");
- while( $row = mysql_fetch_array( $result ) ) {
- $json[] = $row;
- }
- //json_encode( $json );
- echo json_encode($json);
- echo "<table border='1'>
- <tr>
- <th>lat</th>
- <th>Longitude</th>
- </tr>";
- while($row = mysqli_fetch_array($result))
- {
- echo "<tr>";
- echo "<td>" . $row['lat'] . "</td>";
- echo "<td>" . $row['longitude'] . "</td>";
- echo "</tr>";
- }
- echo "</table>";
- mysqli_close($con);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement