Hi, I'm creatingan applicationin php language.I'm usingPHP-MapScript,PostGISforqueryfor aqueryByPointthat Imustreturn informationformattedtext/html butthe query resultis 0.
Thisis the code:
<?php
require_once("includes/config.inc.php");
function pixelToGeo($map,$x,$y) {
# Convert x,y pixel values to georeferenced coords. Returns a
pointObj.
$minx = $map->extent->minx;
$miny = $map->extent->miny;
$maxx = $map->extent->maxx;
$maxy = $map->extent->maxy;
$dx = $maxx - $minx;
$dy = $maxy - $miny;
$width = $map->width;
$height = $map->height;
$dxpp = (double)$dx/$width;
$dypp = (double)$dy/$height;
$geox = $minx + $dxpp*$x;
$geoy = $maxy - $dypp*$y;
$pointObj = ms_newPointObj();
$pointObj->setXY($geox,$geoy);
return $pointObj;
}
function FindPoint($point,$map,$radius, $layerName) {
$qlayer = $map->getLayerByName($layerName);
$check=$qlayer->queryByPoint($point, MS_MULTIPLE, $radius);
$image=$map->drawQuery();
if($check == MS_FAILURE){
echo "<br><font size=4 color=red>There were no results</font><br>";
}else {
$qlayer->open();
$numResults = $qlayer->getNumResults();
echo "<br>Result Query= ".$numResults."<br>";
if ($numResults != 0) {
for ($i = 0; $i < $numResults; $i++) {
$query_result = $qlayer->getResult($i);
$shape = $qlayer->getShape($query_result->tileindex,
$query_result->shapeindex);
$Lista_ele[]=$shape->values;
}
} else {
$valido =0;
$Lista_ele = "";
}
$qlayer->close();
return $Lista_ele;
}
} // end FindPoint
$mapfile_image_width=$_GET["WIDTH"];
$mapfile_image_height=$_GET["HEIGHT"];
$folderCache=$_GET["idf"];
$layerName=$_GET["layer"];
$SRID=$_GET["SRS"];
$x=$_GET["X"];
$y=$_GET["Y"];
$BBOX=explode(",",$_GET["BBOX"]);
$ms_imagepath=DIR_FOLDER;
$ms_imageurl=URL_FOLDER;
$map = ms_newMapObj('');
$map->outputformat->set('driver','imagemap');
$map->outputformat->set('mimetype','text/html; driver=imagemap');
$map->set('width',$mapfile_image_width);
$map->set('height',$mapfile_image_height);
$map->web->set('imagepath',$ms_imagepath);
$map->web->set('imageurl',$ms_imageurl);
$latlongProj = ms_newProjectionObj("EPSG:".$SRID);
$utmProj = ms_newProjectionObj("EPSG:900913");
$poPoint = ms_newpointobj();
$poPoint->setXY($BBOX[0], $BBOX[1]);
$poPoint->project($utmProj, $latlongProj);
$xmin=$poPoint->x;
$ymin=$poPoint->y;
$poPoint = ms_newpointobj();
$poPoint->setXY($BBOX[2], $BBOX[3]);
$poPoint->project($utmProj, $latlongProj);
$xmax=$poPoint->x;
$ymax=$poPoint->y;
$map->setextent($xmin, $ymin, $xmax, $ymax);
echo "<br>BBOX = ".$xmin.", ".$ymin.", ".$xmax.", ".$ymax."<br>";
// Add the only one layer.
$layer = ms_newLayerObj($map);
$layer->setConnectionType(MS_POSTGIS);
$layer->set('name',$layerName);
$layer->set('type',MS_LAYER_POLYGON);
$layer->set('status', MS_ON);
$layer->set('connection', "host=xxx port=xxx dbname=xxx user=xxx
password=xxx");
$layer->set('data','the_geom from (select * from '.$layerName.') as foo
using unique gid using SRID='.$SRID);
$layer->set("template", "");
$layer->set("dump", "true");
// Add some colors.
$class = ms_newClassObj($layer);
$style = ms_newStyleObj($class);
$style->color->setRGB(0, 255, 255);
$style->outlinecolor->setRGB(255, 255, 0);
$image = $map->draw();
$map->preparequery();
$point = ms_newpointobj();
$point->setXY($x,$y);
$geo_point = pixelToGeo($map,$point->x,$point->y);
echo "POINT TO CLICK = ".$geo_point->x. " , ".$geo_point->y;
print_r( FindPoint($geo_point,$map,-1, $layerName));
?>
My result is:
BBOX = 2395177.6101675, 4571367.7734744, 2612958.1665649, 4679392.0513538
POINT TO CLICK = 2470361.0341494 , 4612710.2888501
There were no results
What's wrong?
Allthe examplesIfound onlineusinga mapfile,but Idon't have amap file.
Thanks
_________________________________________
*Andrea D'Aversa*
<<attachment: andrea_daversa.vcf>>
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
