<html>
<body>
<tt>Thomas,<br><br>
Here's some info to hopefully help you get to drawing your points.
You need a "dummy" layer in your map file and a point symbol
(many ways to draw a symbol - I show the use of a gif file defined in the
sysmbols.list file). The PHP I show is excerpts from a much larger
script, so I do not guarantee it will work exactly as written, but should
give you an idea of the basics steps so you can find your way to drawing
the point layer in php mapscript. This is also from php mapscript
that is a couple revs back, things may have changed slightly in some of
these commands, so be sure to verify them against current php mapscript
documentation.<br><br>
hth,<br><br>
Dan<br><br>
<br>
<< excerpts from map file >><br><br>
symbolset "./symbols/symbols.list"<br><br>
LAYER<br>
NAME 'Points'<br>
TYPE POINT<br>
STATUS ON<br>
CLASS<br>
name 'points'<br>
style<br>
SYMBOL 'point'<br>
end<br>
END<br>
END<br><br>
<br>
<< excerpt from symbol.list file >><br><br>
SYMBOL<br>
NAME 'point'<br>
TYPE PIXMAP<br>
IMAGE 'point.gif'<br>
END<br><br>
<br>
<< excerpt from php mapscript >><br><br>
/*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<br>
* Get the MAPSERVER MAP FILE and create NEW MAP OBJECT <br>
*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~*/<br>
$map = ms_newMapObj($mapPath.$mapFile);<br>
$image=$map->draw();<br>
$layer = $map->getLayerByName( "Points"
);<br><br>
$results = queryDBase( $dbaseInfo, $table, $where, $map
);<br><br>
// Loop through result of point query and:<br>
while ($line = mysql_fetch_array($results, MYSQL_ASSOC)) {<br>
$pt = ms_newPointObj();<br>
$pt->setXY( $line["longitude"],
$line["latitude"] );<br>
$pt->draw($map, $layer, $image, 0,
"");<br>
} //end while()<br><br>
$layer->draw($image);<br>
$image_url_PNG=$image->saveWebImage();<br><br>
<br>
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<br>
// queryDBase - query the database for point within the current
extent<br>
//<br>
// $dbaseInfo - array holding host, user, pwd, dbase, and table info for
the database query<br>
// $table - table to query for layer in database<br>
// $where - additional where clause info for the select query<br>
// $map - current map object to determine current map extents<br>
//<br>
// returns $result - the query results<br>
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<br>
function queryDBase( $dbaseInfo, $table, $where, $map ) {<br><br>
$lf = " \n";<br>
$method = "[queryDBase]";<br><br>
// Connect to mySQL database then select the database to
use.<br>
$link = mysql_connect($dbaseInfo["host"],
$dbaseInfo["user"], $dbaseInfo["pwd"] )<br>
or die("Could not connect to mySQL");<br>
mysql_select_db($dbaseInfo["dbase"])<br>
or die("Could not select
database");<br><br>
// Set query string - query for points only in current
extent<br>
$queryStr = "SELECT * FROM ".$table.<br>
" WHERE latitude < ".$map->extent->maxy.<br>
" AND latitude > ".$map->extent->miny.<br>
" AND longitude < ".$map->extent->maxx.<br>
" AND longitude > ".$map->extent->minx.<br>
<x-tab> </x-tab><x-tab> </x-tab>
$where;<br><br>
<x-tab> </x-tab>fwrite(
$file, $lf.$method."DEBUG: queryStr= ".$queryStr);<br><br>
// perform query, then close database link<br>
<x-tab> </x-tab>$result =
mysql_query($queryStr) or die("Query failed");<br>
<x-tab> </x-tab>$numRows =
mysql_num_rows( $result );<br>
<x-tab> </x-tab>mysql_close($link);<br><br>
<x-tab> </x-tab>return
$result;<br>
}<br><br>
<br><br>
<br>
</tt>At 03:41 AM 3/15/2005, you wrote:<br>
<blockquote type=cite class=cite cite><font face="arial" size=2>Hi
Dan,<br>
<br>
Firstly forgive me, I found your email in a post from 2003. <br>
<br>
Do you have any example of using PHP mapscript to retrieve a list of lat
longs from a mysql (or any) database and add as a layer to a map file
? My expertise is in c, .net and java, so a quick example will save
me tons of time.<br>
<br>
Many Thanks in advance.<br>
Thomas<br>
<br>
Ps<br>
This is the link I found.<br>
<a href="http://lists.gis.umn.edu/pipermail/mapserver-users/2003-April/003034.html" eudora="autourl">http://lists.gis.umn.edu/pipermail/mapserver-users/2003-April/003034.html</a></font></blockquote></body>
</html>