-
Notifications
You must be signed in to change notification settings - Fork 0
/
teste1.php
executable file
·65 lines (44 loc) · 1.7 KB
/
teste1.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
<DOCTYPE! hmtl>
<html lang="PT-BR">
<head>
<meta charset="UTF-8">
<link href="default.css" rel="stylesheet" type="text/css" media="all">
<link href='http://fonts.googleapis.com/css?family=Abel' rel='stylesheet' type='text/css'>
<title>
NutriMapa
</title>
<script src="http://maps.googleapis.com/maps/api/js?key=AIzaSyCVJqGdm03cFzk8Ea6Cl_EFKRFD8nIHa2U&sensor=false">
</script>
<script>
function initialize()
{
var mapProp = {
center:new google.maps.LatLng(-30.034971, -51.209816),
zoom:13,
mapTypeId:google.maps.MapTypeId.ROADMAP
};
var map=new google.maps.Map(document.getElementById("googleMap")
,mapProp);
<?php
$db = new SQLite3('nutrimapa.sqlite') or die('Unable to open database');
$result = $db->query('SELECT * FROM enderecos;') or die('Query db failed1');
$idlocais = $db->query('SELECT locais.id,enderecos.lid, locais.nome, locais.url FROM locais,enderecos WHERE locais.id=enderecos.lid;') or die('Query db failed');
while ($row = $result->fetchArray()):
echo "var marker{$row['id']}=new google.maps.Marker({
position:new google.maps.LatLng({$row['latitude']},{$row['longitude']}),icon:'carrot_cartoonII.png'});";
echo "marker{$row['id']}.setMap(map); \n";
$row2= $idlocais->fetchArray();
?>
var infowindow<?=$row['id']?> = new google.maps.InfoWindow({
content:"<?=$row2['nome']?><br><?=$row['endereco']?><br><?=$row2['url']?>"
});
google.maps.event.addListener(marker<?=$row['id']?>, 'click', function() {
infowindow<?=$row['id']?>.open(map,marker<?=$row['id']?>);
});
<?php endwhile; ?>
}
google.maps.event.addDomListener(window, 'load', initialize);
</script>
<div id="googleMap" style="width:1400px;height:600px;"></div>
</body>
</html>