<HTML>
<HEAD>
<TITLE>Re: [mapserver-users] RE: Highlight</TITLE>
</HEAD>
<BODY>
<FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
<BR>
<BR>
On 4/14/09 9:30 AM, "Jay Kapalczynski" <<a href="jkapalczynski@ci.maple-grove.mn.us">jkapalczynski@ci.maple-grove.mn.us</a>> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>Thanks for the help and response….I think I am getting closer…<BR>
<BR>
I set up another php page…this page is getting the PID values sent to it via a session, I am using frames in this page<BR>
It was the only way I could get the queries to work, the table to build…etc<BR>
You can see the “session” code below…I echo it and all the correct PIDs are displayed so I know that I have passed to correctly.<BR>
I added your code example…<BR>
<BR>
<B>Note: the PID string is a comma delimited string of PID values<BR>
</B> <BR>
I am pointing the frame to the PHP page and I get this, but no image. So part of my code is working….<BR>
<BR>
</SPAN></FONT><FONT FACE="Times New Roman"><SPAN STYLE='font-size:12pt'>String:0711922340036,0711922340038,0711922340039<BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'> Are your PIDs strings? If so, you will need your PIDs to have quotes around them when you query. </SPAN><FONT SIZE="2"><SPAN STYLE='font-size:10pt'>$qlayer->queryByAttributes(“PID”,”PID IN (‘0711922340036’,’0711922340038’,’0711922340039’)”,MS_MULTIPLE); Note the double quotes.<BR>
</SPAN></FONT></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>But that’s it….there is no jpeg…<BR>
Again I am very green to this….this is my first attempt to actually return an image… here…<BR>
<BR>
I tried to add this : for my reference library for the ms_newMapObj but I get errors…<BR>
So I went back to the GeoMOOSE libraries…(As see below)<BR>
No errors but no image<BR>
<BR>
<BR>
</SPAN></FONT><FONT SIZE="2"><FONT FACE="Consolas, Courier New, Courier"><SPAN STYLE='font-size:10pt'>dl('php_mapscript.so');<BR>
</SPAN></FONT></FONT><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'> <BR>
I am going to try and post this on their site but help is hard to find…<BR>
Anyone else out here on the MapServer page mess around with GeoMOOSE…<BR>
<BR>
THANK YOU MOEN for your help it is very appreciated..<BR>
<BR>
<BR>
</SPAN><FONT SIZE="2"><SPAN STYLE='font-size:10pt'><?php<BR>
session_start();<BR>
$varPIDValue = $_SESSION["PIDString"];<BR>
<BR>
// Echo the session values <B>THIS GIVES ME A COMMA DELIMITED STRING OF PID VALUES<BR>
// MAYBE I HAVE TO EXPLODE THEM FIRST?<BR>
</B>echo "String:".$varPIDValue;<BR>
</SPAN></FONT></FONT></BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><FONT SIZE="2"><SPAN STYLE='font-size:10pt'>You probably will want to comment this out, otherwise it will be output as text before the html and you won’t have proper html. If you find the error logs you can use<BR>
error_log("String:".$varPIDValue); to output it to the error logs instead of the standard output.<BR>
</SPAN></FONT></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><FONT SIZE="2"><SPAN STYLE='font-size:10pt'> <BR>
error_reporting(E_ERROR | E_PARSE);<BR>
</SPAN></FONT></FONT></BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><FONT SIZE="2"><SPAN STYLE='font-size:10pt'> Find out where these errors are being logged. On unix they are usually /var/logs/apache2/error_log or /var/logs/httpd/error_log.<BR>
</SPAN></FONT></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><FONT SIZE="2"><SPAN STYLE='font-size:10pt'># Include the GeoMOOSE PHP Library Utilities<BR>
include('Configuration.php');<BR>
include('geomoose_php_util.php');<BR>
<BR>
<BR>
<BR>
$map = ms_newMapObj('/ms4w/apps/GeoMOOSE/Maple_Grove_GeoMoose/select.map');<BR>
$map->selectOutputFormat('jpeg');<BR>
</SPAN></FONT></FONT></BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><FONT SIZE="2"><SPAN STYLE='font-size:10pt'>This should be before the draw.<BR>
</SPAN></FONT></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><FONT SIZE="2"><SPAN STYLE='font-size:10pt'>$qlayer = $map->$map->getLayerByName('parcels');<BR>
</SPAN></FONT></FONT></BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><FONT SIZE="2"><SPAN STYLE='font-size:10pt'>You have $map twice here. Should be $qlayer =$map->getLayerByName('parcels');<BR>
</SPAN></FONT></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><FONT SIZE="2"><SPAN STYLE='font-size:10pt'>$test = $qlayer->queryByAttributes('PID','PID IN ($PIDString)',MS_MULTIPLE);<BR>
</SPAN></FONT></FONT></BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><FONT SIZE="2"><SPAN STYLE='font-size:10pt'>Assign above to variable so you can compare it with MS_SUCCESS if($test == MS_SUCCESS) and check your error log for errors.<BR>
</SPAN></FONT></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><FONT SIZE="2"><SPAN STYLE='font-size:10pt'>$img = $map->drawQuery();<BR>
</SPAN></FONT></FONT><FONT FACE="Times New Roman"><SPAN STYLE='font-size:12pt'><BR>
//</SPAN></FONT><FONT SIZE="2"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'>header('Content-Type: image/jpeg');<BR>
</SPAN></FONT></FONT><FONT FACE="Times New Roman"><SPAN STYLE='font-size:12pt'>//</SPAN></FONT><FONT SIZE="2"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'>$img->saveImage("");<BR>
</SPAN></FONT></FONT></BLOCKQUOTE><FONT SIZE="2"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'>You don’t need the 2 prior lines if you are saving the image to a file and loading it via an image tag like you are below.<BR>
</SPAN></FONT></FONT><BLOCKQUOTE><FONT SIZE="2"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'>$image_url=$img->saveWebImage();<BR>
?> <BR>
<BR>
<HTML><BR>
<HEAD><BR>
<TITLE>Displaying a map</TITLE><BR>
</HEAD><BR>
<BR>
<BODY><BR>
<IMG SRC=<?php echo $img; ?> ><BR>
</BODY><BR>
</HTML><BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<B>From:</B> Moen, Paul T. [<a href="mailto:pmoen@nd.gov">mailto:pmoen@nd.gov</a>] <BR>
<B>Sent:</B> Monday, April 13, 2009 3:22 PM<BR>
<B>To:</B> Jay Kapalczynski<BR>
<B>Cc:</B> <a href="mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><BR>
<B>Subject:</B> Re: [mapserver-users] RE: Highlight<BR>
</SPAN></FONT></FONT><FONT FACE="Times New Roman"><SPAN STYLE='font-size:12pt'> <BR>
</SPAN></FONT><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>
<B>I am messing around with this….does any of this map sense?<BR>
</B>Yes, you have many errors. Check the error logs for php to help debugging with syntax.<BR>
<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>
Won’t work because it requires a string, so you would need $map = ms_newMapObj(‘/ms4w/apps/GeoMOOSE/Maple_Grove_GeoMoose/select.map’);<BR>
<BR>
$qlayer = $map->$map->getLayerByName(parcels);<BR>
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>
<BR>
$qlayer->queryByAttributes('PID','(<B>$PIDString</B>)',MS_MULTIPLE);<BR>
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>
<BR>
$img = $map->drawQuery();<BR>
Should set the output format to jpeg<BR>
$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>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>
<B>Is this all that I need code wise?<BR>
</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>
<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>> <<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</SPAN></FONT></FONT><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
</SPAN></FONT></BLOCKQUOTE>
</BODY>
</HTML>