double check between postgis and queryByAttribute

theresia freska frezzz_54 at YAHOO.COM
Tue Mar 20 19:57:02 PDT 2007


hello, can someone pls check my code? just wonder if i use too much resource. seems like i do double check here, between postgis and queryByAttribute.
does mapserver do this kind of check in the queryByAttribute? if yes, how can i access it?
thank you.

if ($_POST['mode'] == "itemnquery") {
  $qstring = $_POST['qstring'];
  $inputLayer = array('Highway', 'Street');
 
  //check whether the query layers are active or not
  if (array_intersect($inputLayer, $listLayer) != $inputLayer) {
   echo "<script language='Javascript'>alert('Query layer is not active.')</script>";
  } else {
   //if yes, check if user's input returns >1 name
   if ($_POST['qstring']) {
 
    $conn = pg_connect("host=".$host." dbname=".$database." user=".$user." password=".$password) or die ("Error connect!");
    $result = pg_query("select distinct road, class from tbRoad where road like '%$qstring%'");
 
    $m = 0;
    while ($row = pg_fetch_row($result)) {
     $res[$m] = $row;
     $m++;
    }
 
    $result_table = makeTable($res);
 
    //if it returns only 1 name, display the query map
    if (count($res)==1) {
 
     for ($k=0; $k<count($inputLayer); $k++) {
      $qLayer = $map->getLayerByName($inputLayer[$k]);
      $qry = "road LIKE '%" . $qstring . "%'";
      @$qLayer->queryByAttributes("road", $qry, MS_MULTIPLE);
 
      $showquery = TRUE;
      drawQueryRes();
     }
 
    }
 
   } else {
    echo "<script language='Javascript'>alert('Please fill the appropriate field.')</script>";
   }
  }
}

 
---------------------------------
It's here! Your new message!
Get new email alerts with the free Yahoo! Toolbar.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20070320/a70b0cf6/attachment.htm>


More information about the MapServer-users mailing list