[mapserver-users] Problem with postgis querybypoint in mapserver-php

[Alexandre Busquets]

Try to implement these code changes in your code


$qlayer->set('template', 'none');
$qlayer->set('status', MS_ON);

$map->setExtent($minX, $minY, $maxX, $maxY );
$map->setSize($WIDTH, $'HEIGHT');
$map->preparequery();

[...]
 for ($i = 0; $i < $numResults; $i++) {
  $resultat = $qlayer->getResult($i);
  $shape = $qlayer->getShape($resultat->tileindex, $resultat->shapeindex);
  $dades[]=$shape->values;
[...]



2010/6/11 Guillermo Tamburini Beliveau <guitambe at topo.upv.es>:
> Hi,
>
> I'm trying to recover the line of an ancient subject that I wrote to the list!
> It is about a problem with the querybypoint method in php in mapserver with
> postgis layers. If you want to see it, please take a look below (previous
> message).
> I unsubscribed the list because my main reason was to get a response to my
> doubt, and nobody response me. But now, browsing the net, I've seen that a user
> responded!
> Please if you have more information about my problem, reply me because I haven't
> resolved it yet.
>
> And please, excuse me for using your user name in the subject, I couldn't send
> you an e-mail.
>
> Previous message -----------------------------------------------------------
>
> Hi,
>
> I would like to know if some body knows the reason of a strange problem that I'm
> having with the php-mapscript methods for the query methods in the postgis
> layers.
>
> Indistinctly for querybypoint or querbyrectangle, my code (different versions of
> it), works perfectly with shapes, but it always fails with the postgis layers.
> When calling to the shapeindex member of the ResultCacheMemberObj obtained, it
> always returns 0, as is contrary to what happends with the shapes, where it
> always returns the correct shapeindex.
>
>    Then it is impossible to acces to the desidered feature.
>
>    May I have to add more columns to the select of the .map file for getting
> the
>    features atributes like in the example (I don't think so)?
>
>        DATA "geom FROM puntos using unique gid"
>    #    DATA "geom FROM (select gid , nombre, tramo, geom from puntos) as foo
> using
>    unique geom"
>    #    DATA "geom FROM (select * from puntos) as foo using unique gid"
>
>    Or there is some paramter in the configuration files of mapserver or php
> that I
>    have to change.
>
>    There is the code of the function:
>
>    function CercaPunto($point,$map,$radius) {
>
>          $qlayer = $map->getLayerByName('trazado');
>         $qlayer->set("tolerance",$radius);
>         @$qlayer->queryByPoint($point, MS_MULTIPLE, $radius);
>         $numResults = $qlayer->getNumResults();
>         if ($numResults != 0) {
>              for ($i = 0; $i < $numResults; $i++) {
>                  $query_result = $qlayer->getResult($i);
>                   $Lista_ele[$i] = $query_result->shapeindex; // Here is the
> error
>    with postgres
>              }
>         } else {
>              $valido =0;
>              $Lista_ele = "";
>         }
>         return $Lista_ele;
>    } // end CercaPunto
>
>
>    Thank you very much.
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>