Differences

This shows you the differences between two versions of the page.

--- tecnica:gps_cartografia_gis:php_mapscript_recipes [2010/01/29 21:18] – niccolo
+++ tecnica:gps_cartografia_gis:php_mapscript_recipes [2010/02/26 23:46] (current) – niccolo
@@ Line 74: / Line 74: @@
 For inline images you can omit web paths, because no temporary images will be created.
+===== Make a query =====
+Open an existing map file and perform a **query by rectangle** on a layer, print results with a **template**.
+<code php>
+<?php
+$map = ms_newMapObj("/var/www/demo.map");
+$selrect = ms_newrectObj();
+$selrect->setextent(1681023, 4850413, 1681906, 4851167);
+$map->queryByRect($selrect);
+$buffer = $map->processquerytemplate(array(), false);
+print "<table border=\"1\">\n";
+print $buffer;
+print "</table>\n";
+?>
+</code>
+The **''$buffer''** variable contains one template instance for each record.
+The querable layer is definend in the ''**MAP.LAYER**'' section, and it requires a query template:
+<file>
+MAP
+  ...
+  LAYER
+    ...
+    TEMPLATE "query_template.html"
+    TOLERANCE 6
+    METADATA
+      DESCRIPTION    "Impianti Pubblicitari"
+      RESULT_FIELDS  "objectid,field1,field2"
+      RESULT_HEADERS "ID,Heading1,Heading2"
+    END
+  END
+END
+</file>
+This is an example for **''query_template.html''**:
+<code html>
+<!-- MapServer Template -->
+<tr><td>[item name=objectid]</td><td>[item name=field1]</td><td>[item name=field2]</td></tr>
+</code>
+This example does not use the template, it **iterates through the query results**:
+<code php>
+<?php
+$map = ms_newMapObj("/var/www/demo.map");
+$selrect = ms_newrectObj();
+$selrect->setextent(1681023.81515592, 4850413.68207817, 1681906.91185973, 4851167.76185515);
+$map->queryByRect($selrect);
+$layer = $map->getLayerByName('layer_name');
+$count = $layer->getNumResults();
+print "Query result count: " . $count . "<br>\n";
+print "<pre>\n";
+for ($i = 0; $i < $count; $i++) {
+    $qRes = $layer->getResult($i);
+    print_r($qRes);
+}
+print "</pre>\n";
+?>
+</code>