[Mapserver-users] Querybypoint success but noresult with PHP/Mapscript

[jose.quintal at cfe.gob.mx]

When I make a Querybypoint, SUCCESS returns but I do not obtain results.
That I will be making bad?


This it is the code where I obtain the points of Mysql to draw them with
Mapserver


//Conectando con Mysql
mysql_pconnect("dwa00","sist","sist") or die("No abrio el servidor");
mysql_select_db("mapas") or die("No selecciono la Base de Datos");
$sql="SELECT * from postes_Mer WHERE circuito = '$buscar' ";
$p=mysql_query($sql) or die("Error al Ejecutar la Consulta");


//Arma la consulta

//  get a layer object representing your pointlayer

$layerObj = $map->getLayerByName("postes");

// get a class object representing the first class in the layer
$classObj = $layerObj->getClass(0);

// create a new point object to hold the X Y data
 $pointObj = ms_newPointObj();

$i=0;
while($reg=mysql_fetch_array($p))
{
     $a=$reg['id'];
     $b=$reg['cor_x'];
     $c=$reg['cor_y'];

     //set the X Y values of the point object

     $pointObj->setXY($b,$c);
     $line = ms_newLineObj();
     $line ->add($pointObj);
     $shp = ms_newShapeObj(MS_SHAPE_POINT);
     $shp->add($line);

     $shp->{text} = $a;
     $shp->{index} = $i;
     if($layerObj->addFeature($shp) == -1){
             echo  "addFeature failed";
         }
     $point_lookup[$i] = $a;
     $i++;

     $pointObj->draw($map, $layerObj, $image, 0, $a);
 }




This it is the code where I make the Querybypoint

if ( isset($HTTP_POST_VARS["mapa_x"]) && isset($HTTP_POST_VARS["mapa_y"]) )
{
$nClickGeoX = GMapPix2Geo($mapa_x, 0, $dfWidthPix,
                                      $dfMinX, $dfMaxX, 0);
$nClickGeoY = GMapPix2Geo($$mapa_y, 0, $dfHeightPix,
                                              $dfMinY, $dfMaxY, 1);

  $ptClicked = ms_newPointObj();
  $ptClicked->setXY($nClickGeoX, $nClickGeoY);
  echo "X = " . $nClickGeoX .  " Y = " . $nClickGeoY;
  if ($info_pt == 1 )
  {
    $record = -1;

    $layerObj = $map->getLayerByName('postes');




   $queryresult = @$map->queryByPoint ($ptClicked,MS_SINGLE,1000);

   if ($queryresult == MS_SUCCESS)

     {
         echo "Query " . MS_SUCCESS;
       $results = $layerObj->{resultcache};
       $num_results = $results->{numresults};
         echo "Num results : " . $num_results;
  //   we only expect one result.
       $rslt = $layerObj->getResult(0);
  //    this is an index into the point lookup table.
       $record = $rslt->{shapeindex};
       $point_name = $point_lookup[$record];
        echo "Encontrado " .  $point_name;

    }
  }
}




This is de .map


MAP
  NAME "MER"
  STATUS ON
  EXTENT 217014 2.30865e+006 242281 2.33284e+006

  SIZE 800 600
  SHAPEPATH "c:/Php4/mapserver/webmap/shp/"
  SYMBOLSET "c:/Php4/mapserver/webmap/etc/symbols.sym"
  FONTSET "c:/Php4/mapserver/webmap/etc/fonts.txt"
  IMAGECOLOR 213 255 255
  TRANSPARENT OFF
  UNITS METERS
  INTERLACE ON
  IMAGETYPE PNG
  IMAGEQUALITY 150
  WEB


    IMAGEPATH "C:/tmp/ms_tmp/"
    IMAGEURL "/ms_tmp/"

  END

  QUERYMAP
    COLOR 255 255 0
    STYLE HILITE
  END
  LEGEND
    STATUS ON
    IMAGECOLOR 199 226 243
    TRANSPARENT TRUE
    INTERLACE TRUE
    POSITION LL
    KEYSIZE 18 2
    KEYSPACING 5 5

    LABEL
      TYPE BITMAP
      SIZE MEDIUM
      OFFSET 0 0
      BUFFER 0
      MINDISTANCE -1
      MINFEATURESIZE -1
      COLOR 0 0 89
      PARTIALS TRUE
      FORCE FALSE
    END
  END
  SCALEBAR
    STATUS ON
    COLOR 255 255 255
    OUTLINECOLOR 0 0 0
    BACKGROUNDCOLOR 0 0 0
    IMAGECOLOR 255 255 255
    TRANSPARENT FALSE
    UNITS KILOMETERS
    INTERVALS 5
    SIZE 300 5
    STYLE 0
    POSITION UC
    INTERLACE TRUE
    LABEL
      TYPE BITMAP
      SIZE SMALL
      OFFSET 0 0
      BUFFER 0
      MINDISTANCE -1
      MINFEATURESIZE -1
      COLOR 0 0 0
      PARTIALS TRUE
      FORCE FALSE
    END
  END

  LAYER
    NAME "MERTP"
    STATUS on
    DATA "Merida"
    TYPE LINE
    UNITS METERS
    SIZEUNITS PIXELS
    TOLERANCE 3
    TOLERANCEUNITS PIXELS

    CLASS
      NAME "Cd de Merida"
      SYMBOL 0
     COLOR 102 153 204
#      COLOR 255 255 223
      OUTLINECOLOR 51 153 204

      SIZE 1
      MINSIZE 1
      MAXSIZE 100
    END
  END

  LAYER
    NAME "MerText"
    STATUS on
    DATA "Mertext"
    TYPE POINT
    UNITS METERS
    SIZEUNITS PIXELS
    LABELITEM "NAME"
    LABELMINSCALE 5
    LABELMAXSCALE 30000
    TOLERANCE 3
    TOLERANCEUNITS PIXELS

    CLASS

      NAME "Nombre de Calles"
      SYMBOL 0
      COLOR 51 153 204
      SIZE 2
      MINSIZE 1
      MAXSIZE 100
      LABEL
        TYPE BITMAP
        SIZE SMALL
        POSITION CC
        OFFSET 0 0
        BUFFER 2
        MINDISTANCE -1
        MINFEATURESIZE -1
        COLOR 0 0 0
        PARTIALS TRUE
        FORCE FALSE
      END
    END
  END



LAYER
  NAME "postes"
  TYPE POINT
  STATUS on
  TOLERANCE 10
  LABELMINSCALE 10
  LABELMAXSCALE 60000
  TEMPLATE "postes.html"
  CLASS

    SYMBOL 'circle'
    COLOR 255 89 89
    SIZE 10
    MINSIZE 5
    MAXSIZE 2
    LABEL
     ANTIALIAS TRUE
     TYPE TRUETYPE
     FONT Arialn
     SIZE 8
     POSITION CL
     BUFFER 2
     MINDISTANCE -3
     MINFEATURESIZE -1
     COLOR 252 152 54
     PARTIALS TRUE
     FORCE FALSE
    END



  END


 END




END






Thanks

José Antonio Quintal Castillo
Sistemas
Comision Federal de Electricidad
Tel 9243128  O  9243136