Consultar datos desde PHP con la api de Google maps
Publicado por OMAR EDUARDO (1 intervención) el 19/03/2018 22:29:24
Hola a todos, en este momento configuré la api de google maps para mostrar las coordenadas desde una base de datos en mysql, sin embargo en el código php que vuelca la base en xml introduzco la consulta select a todos los registros, pero quisiera que desde un formulario me trajera los datos, el código es el siguiente
api de google:
archivo php
api de google:
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
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
<body>
<div id="map"></div>
<script>
var customLabel = {
HOMICIDIO: {
label: ''
},
LESION: {
label: 'L'
} };function initMap() {
var map = new google.maps.Map(document.getElementById('map'), {
center: new google.maps.LatLng(4.436090, -75.180248),
zoom: 13.4
});
var infoWindow = new google.maps.InfoWindow;
// Change this depending on the name of your PHP or XML file
downloadUrl('http://localhost/trafico_estupef/navegador.php', function(data) {
var xml = data.responseXML;
var markers = xml.documentElement.getElementsByTagName('marker');
Array.prototype.forEach.call(markers, function(markerElem) {
var name = markerElem.getAttribute('name');
var address = markerElem.getAttribute('address');
var type = markerElem.getAttribute('type');
var point = new google.maps.LatLng(
parseFloat(markerElem.getAttribute('lat')),
parseFloat(markerElem.getAttribute('lng')));
var infowincontent = document.createElement('div');
var strong = document.createElement('strong');
strong.textContent = name
infowincontent.appendChild(strong);
infowincontent.appendChild(document.createElement('br'));
var text = document.createElement('text');
text.textContent = address
infowincontent.appendChild(text);
var icon = customLabel[type] || {};
var marker = new google.maps.Marker({
map: map,
position: point,
label: icon.label
});
var text = document.createElement('br');
text.textContent = address
infowincontent.appendChild(text);
var icon = customLabel[type] || {};
var marker = new google.maps.Marker({
map: map,
position: point,
label: icon.label
});
var text = document.createElement('text');
text.textContent = type
infowincontent.appendChild(text);
var icon = customLabel[type] || {};
var marker = new google.maps.Marker({
map: map,
position: point,
label: icon.label
});
marker.addListener('click', function() {
infoWindow.setContent(infowincontent);
infoWindow.open(map, marker);
});
});
});
}function downloadUrl(url, callback) {
var request = window.ActiveXObject ?
new ActiveXObject('Microsoft.XMLHTTP') :
new XMLHttpRequest;
request.onreadystatechange = function() {
if (request.readyState == 4) {
request.onreadystatechange = doNothing;
callback(request, request.status);
} };request.open('GET', url, true);
request.send(null);
}function doNothing() {}
</script>
<script async defersrc="https://maps.googleapis.com/maps/api/js?key=AIzaSyAM_LUNRmGzZqtIpXXLY_D0NlqYZ7aQPhY&callback=initMap">
</script>
<body>
</body>
</body>
</html>
archivo 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
<?php
require("conexion.php");
function parseToXML($htmlStr)
{$xmlStr=str_replace('<','<',$htmlStr);
$xmlStr=str_replace('>','>',$xmlStr);
$xmlStr=str_replace('"','"',$xmlStr);
$xmlStr=str_replace("'",''',$xmlStr);
$xmlStr=str_replace("&",'&',$xmlStr);
return $xmlStr;
}// Opens a connection to a MySQL server
$connection=mysql_connect ('localhost', $username, $password);
if (!$connection) {
die('Not connected : ' . mysql_error());
}// Set the active MySQL database
$db_selected = mysql_select_db($database, $connection);
if (!$db_selected) {
die ('Can\'t use db : ' . mysql_error());
}
$query = "Select * from hechos where hechos.fecha between '2018-03-01' AND '2018-03-31' and hechos.tipo_hecho= 'HOMICIDIO'";
$result = mysql_query($query);
if (!$result) {
die('Invalid query: ' . mysql_error());
}
header("Content-type: text/xml");
// Start XML file, echo parent node
echo '<markers>';
// Iterate through the rows, printing XML nodes for each
while ($row = @mysql_fetch_assoc($result)){
// Add to XML document node
echo '<marker ';
echo 'name="' . parseToXML($row['tipo_hecho']) . '" ';
echo 'address="' . parseToXML($row['barrio']) . '" ';
echo 'lat="' . $row['latitud'] . '" ';
echo 'lng="' . $row['longitud'] . '" ';
echo 'type="' . $row['tipo_arma'] . '" ';
echo '/>';}// End XML file
echo '</markers>';?>
Valora esta pregunta
0