<HTML>
<HEAD>
<TITLE>Re: [mapserver-users] RE: Highlight</TITLE>
</HEAD>
<BODY>
<FONT SIZE="2"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'><BR>
On 4/13/09 2:25 PM, "Jay Kapalczynski" <<a href="jkapalczynski@ci.maple-grove.mn.us">jkapalczynski@ci.maple-grove.mn.us</a>> wrote:<BR>
<BR>
</SPAN></FONT></FONT><BLOCKQUOTE><FONT SIZE="2"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'><B>I am messing around with this….does any of this map sense?<BR>
</B></SPAN></FONT></FONT></BLOCKQUOTE><FONT SIZE="2"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'>Yes, you have many errors. Check the error logs for php to help debugging with syntax.<BR>
</SPAN></FONT></FONT><BLOCKQUOTE><FONT SIZE="2"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'><B>// THE QUERY HAPPENS BEFORE THIS….JUST SHOWING THAT THE VARAIBLE HOLDING ALL THE PIS VALUES IS BELOW<BR>
</B> <BR>
//===============================================================<BR>
//===============================================================<BR>
// BUILD A COMMAN DELIMITED LIST<BR>
<BR>
// if something already in $PIDString, append a comma <BR>
if (isset($PIDString)) <BR>
$PIDString .= ','; <BR>
<BR>
// Append the new value <BR>
<B>$PIDString</B> .= $PID; <BR>
//===============================================================<BR>
//===============================================================<BR>
<BR>
} // end while <BR>
<BR>
<BR>
//===============================================================<BR>
//===============================================================<BR>
<BR>
$map = ms_newMapObj(/ms4w/apps/GeoMOOSE/Maple_Grove_GeoMoose/select.map);<BR>
</SPAN></FONT></FONT></BLOCKQUOTE><FONT SIZE="2"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'>Won’t work because it requires a string, so you would need $map = ms_newMapObj(‘/ms4w/apps/GeoMOOSE/Maple_Grove_GeoMoose/select.map’);<BR>
</SPAN></FONT></FONT><BLOCKQUOTE><FONT SIZE="2"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'><BR>
$qlayer = $map->$map->getLayerByName(parcels);<BR>
</SPAN></FONT></FONT></BLOCKQUOTE><FONT SIZE="2"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'>Won’t work because it requires a string and the layer in your mapfile is Parcels, so you would need $qlayer = $map->getLayerByName(‘Parcels’);<BR>
</SPAN></FONT></FONT><BLOCKQUOTE><FONT SIZE="2"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'><BR>
$qlayer->queryByAttributes('PID','(<B>$PIDString</B>)',MS_MULTIPLE);<BR>
</SPAN></FONT></FONT></BLOCKQUOTE><FONT SIZE="2"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'>Won’t work because it needs to know how to query for the PID as in $qlayer->queryByAttributes('PID','PID IN (<B>$PIDString</B>)',MS_MULTIPLE);<BR>
</SPAN></FONT></FONT><BLOCKQUOTE><FONT SIZE="2"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'><BR>
$img = $map->drawQuery();<BR>
</SPAN></FONT></FONT></BLOCKQUOTE><FONT SIZE="2"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'>Should set the output format to jpeg<BR>
</SPAN></FONT></FONT><BLOCKQUOTE><FONT SIZE="2"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'>$map->selectOutputFormat('jpeg');<BR>
<BR>
header('Content-Type: image/jpeg');<BR>
$img->saveImage("");<BR>
<BR>
<BR>
<B>Can I then test the jpeg in another window or something…<BR>
</B></SPAN></FONT></FONT></BLOCKQUOTE><FONT SIZE="2"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'>You could set up your php file to accept $_GET variables and pass in the PIDs like below. <BR>
<a href="http://yourserver.com/phpfilename.php?PID=1%2C2%2C3%2C4%2C5">http://yourserver.com/phpfilename.php?PID=1%2C2%2C3%2C4%2C5</a>, which should give you a png image after making changes above. <BR>
<BR>
</SPAN></FONT></FONT><BLOCKQUOTE><FONT SIZE="2"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'><B>Is this all that I need code wise?<BR>
</B></SPAN></FONT></FONT></BLOCKQUOTE><FONT SIZE="2"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'><B> </B>That should give you the basics. You will also need to load the php_mapscript library before any of the above functions will be recognized. Check out <a href="http://mapserver.org/mapscript/php/by_example.html">http://mapserver.org/mapscript/php/by_example.html</a>. There is an abundance of good documentation on <a href="http://mapserver.org">http://mapserver.org</a>.<BR>
</SPAN></FONT></FONT><BLOCKQUOTE><FONT SIZE="2"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'><B>HERE is the select.map file<BR>
</B> <BR>
MAP<BR>
NAME 'all layers'<BR>
SIZE 800 650<BR>
STATUS ON<BR>
EXTENT 427632.500000 4893613.330000 560300.922104 5015936.680000<BR>
UNITS METERS<BR>
<BR>
SYMBOLSET 'symbols/symbol.sym'<BR>
<BR>
TRANSPARENT TRUE<BR>
IMAGETYPE PNG<BR>
<BR>
QUERYMAP<BR>
STATUS ON<BR>
STYLE SELECTED<BR>
#STYLE HILITE<BR>
END<BR>
<BR>
WEB<BR>
IMAGEPATH "/ms4w/tmp/ms_tmp/"<BR>
IMAGEURL "/ms_tmp/"<BR>
#EMPTY '../geomoose/query_miss.html'<BR>
END<BR>
<BR>
<BR>
<BR>
LAYER # Parcels Polygon Layer<BR>
NAME 'Parcels'<BR>
DATA 'parcels/parcels.shp'<BR>
STATUS ON<BR>
TYPE POLYGON<BR>
<BR>
#TEMPLATE 'parcels/identify_parcels.html'<BR>
#FILTERITEM 'PID'<BR>
#FILTER /^%id%/<BR>
<BR>
METADATA<BR>
qstring_validation_pattern '.'<BR>
END<BR>
HEADER 'parcels/select_header.html'<BR>
TEMPLATE 'parcels/select_parcel.html'<BR>
FOOTER 'parcels/select_footer.html'<BR>
TOLERANCE 0<BR>
CLASS<BR>
SYMBOL 'plainline'<BR>
SIZE 3<BR>
COLOR -1 -1 -1<BR>
OUTLINECOLOR 255 255 0<BR>
END<BR>
END<BR>
<BR>
<B>From:</B> <a href="mapserver-users-bounces@lists.osgeo.org">mapserver-users-bounces@lists.osgeo.org</a> [<a href="mailto:mapserver-users-bounces@lists.osgeo.org">mailto:mapserver-users-bounces@lists.osgeo.org</a>] <B>On Behalf Of </B>Moen, Paul T.<BR>
<B>Sent:</B> Thursday, April 09, 2009 3:15 PM<BR>
<B>To:</B> <a href="mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><BR>
<B>Subject:</B> Re: [mapserver-users] RE: Highlight<BR>
<BR>
<BR>
If the database that you are querying has the same attributes as the shape file, you can query the Layer that points to the shape file and display the highlighted results on your map. I know nothing about GeoMOOSE but I know it can be done with php-mapscript. <BR>
<BR>
Regardless of what you are using, you need a map file layer for the shape file with the parcels.<BR>
You will then need to use php-mapscript to query that layer with something like<BR>
$map = ms_newMapObj(PATH TO YOU MAPFILE);<BR>
$qlayer = $map->$map->getLayerByName(NAME OF PARCEL LAYER);<BR>
$qlayer->queryByAttributes(‘PID’,’PID IN (1, 2,7,9,23,87)’,MS_MULTIPLE);<BR>
You will then need to create the output image from query using something like<BR>
$img = $map->drawQuery();<BR>
header('Content-Type: image/jpeg');<BR>
$img->saveImage("");<BR>
<BR>
I can’t give you specifics without knowing how GeoMOOSE works, so the best thing is to look at the documentation for GeoMOOSE if that is what you are using.<BR>
<BR>
On 4/9/09 2:17 PM, "Jay Kapalczynski" <<a href="jkapalczynski@ci.maple-grove.mn.us">jkapalczynski@ci.maple-grove.mn.us</a>> wrote:<BR>
Dang I misspoke…I am sorry…<BR>
<BR>
I am querying a Database for records, these records have a PID (unique Number).<BR>
These are the records that show up in the Table.<BR>
<BR>
As this happens I have to take the results and run the query against the parcels to get the features in the Shapefile, then highlight..<BR>
<BR>
If that makes any sense…<BR>
<BR>
If I am in a PHP file and have the records returned from the query (database)…what would I have to do next to take those records and run a query to highlight the parcels (PID to PID)?<BR>
<BR>
Can all of this be accomplished in the PHP file?<BR>
<BR>
Thanks…and sorry for my ignorance…<BR>
<BR>
<BR>
<BR>
<BR>
<B>From:</B> <a href="mapserver-users-bounces@lists.osgeo.org">mapserver-users-bounces@lists.osgeo.org</a> [<a href="mailto:mapserver-users-bounces@lists.osgeo.org">mailto:mapserver-users-bounces@lists.osgeo.org</a>] <B>On Behalf Of </B>Moen, Paul T.<BR>
<B>Sent:</B> Thursday, April 09, 2009 1:57 PM<BR>
<B>To:</B> <a href="mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><BR>
<B>Subject:</B> Re: [mapserver-users] RE: Highlight<BR>
<BR>
Set the mapfile QUERYMAP style to highlight <a href="http://mapserver.org/mapfile/querymap.html">http://mapserver.org/mapfile/querymap.html</a>. Draw the map using drawQuery() instead of draw().<BR>
<BR>
$img = $map->drawQuery();<BR>
header('Content-Type: image/jpeg');<BR>
$img->saveImage("");<BR>
<BR>
On 4/9/09 1:31 PM, "Jay Kapalczynski" <<a href="jkapalczynski@ci.maple-grove.mn.us">jkapalczynski@ci.maple-grove.mn.us</a>> wrote:<BR>
Basically what I have is a query that runs on a shapefile…<BR>
It returns the records into a table, which I then have the option to zoom to.<BR>
<BR>
I am looking for a bit more….after I run the query (php) I want the returned records to highlight in the map…<BR>
I can get the Unique identifier but don’t know if I can write some code in PHP to highlight those features<BR>
<BR>
I don’t even know where to start here…<BR>
<BR>
The query and returning records into the table, as well as, the zoom to work great…just need the highlight part<BR>
<BR>
Thanks<BR>
<BR>
<BR>
<BR>
<B>From:</B> Jay Kapalczynski <BR>
<B>Sent:</B> Thursday, April 09, 2009 1:03 PM<BR>
<B>To:</B> <a href="'mapserver-users@lists.osgeo.org">'mapserver-users@lists.osgeo.org</a> <<a href="mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>> <<a href="mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>> '<BR>
<B>Subject:</B> Highlight<BR>
<BR>
Any way to highlight a feature in my map in PHP?<BR>
<BR>
I can grab a unique identifier but can figure out how to highlight it…<BR>
<BR>
THanks<BR>
<BR>
<BR>
</SPAN></FONT></FONT></BLOCKQUOTE>
</BODY>
</HTML>