Update of /cvsroot/firebug/firebug/web/gmaps
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv24193
Modified Files:
db_render_xml.php
Log Message:
we have labels now.
Index: db_render_xml.php
===================================================================
RCS file: /cvsroot/firebug/firebug/web/gmaps/db_render_xml.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** db_render_xml.php 8 Jun 2005 22:29:42 -0000 1.2
--- db_render_xml.php 8 Jun 2005 22:40:48 -0000 1.3
***************
*** 42,45 ****
--- 42,51 ----
}
+ $cols = pg_numrows($stat);
+ for($i=0; $i < $cols; $i++) {
+ $header=pg_fetch_row($stat, $i);
+ $labels[$i]=$header[0];
+ }
+
$statement = "SELECT * FROM $tblname";
$stat = @pg_exec($dbh,$statement);
***************
*** 79,84 ****
foreach ($row as $key => $value) {
! print "$key"; //$value\n";
! switch($key) {
case "latitudedegree":
$latdeg=$value;
--- 85,90 ----
foreach ($row as $key => $value) {
! // print "$key"; //$value\n";
! switch($labels[$key]) {
case "latitudedegree":
$latdeg=$value;
***************
*** 90,94 ****
$longdeg=$value;
break;
! case "longitudeminutes":
$longmin=$value;
break;
--- 96,100 ----
$longdeg=$value;
break;
! case "longitudeminute":
$longmin=$value;
break;
***************
*** 101,107 ****
$long = $longdeg + ($longmin/60.0);
! //print "$lat,$long";
! print("<point lat=\"$lat\" lng=-\"$long\"/>\n");//, $lat, $long);// or perr("db_render_xml", "1");
printf("<icon image=\"%s\" class=\"local\"/>\n", $imgs[0]);
print("<info>") or perr("db_render_xml","4");
--- 107,113 ----
$long = $longdeg + ($longmin/60.0);
! print "$lat,$long";
! print("<point lat=\"$lat\" lng=\"-$long\"/>\n");//, $lat, $long);// or perr("db_render_xml", "1");
printf("<icon image=\"%s\" class=\"local\"/>\n", $imgs[0]);
print("<info>") or perr("db_render_xml","4");
|