Gaston in principal the 'XY-Layer' function should do what you need. See
http://svn.pmapper.net/trac/wiki/DocManual#XYLayers You do not need to modify any code, just install PEAR and the DB module and define the connection string for "XYLAYER_PROPERTIES" using PEAR syntax, like ... "mssql://user:[EMAIL PROTECTED]:1433/database||..." Every map refresh or query connects to the DB and retrieves the updated point information. Armin Gaston Izaguirre wrote: > Hi All, > > I'm new to p.mapper and I'm migrating a little PHP/MapScript application > I've developed to the p.mapper framework, > in order to take advantage of the broad functionality and multiple > configurations that offers. > This task seems to be straightforward, but I have some doubts. > > In my application I'm using PHP functions, mssql_connect(), > mssql_select_db(), mssql_query(), mssql_fetch_array(), to get geographic > coordinates (lat, lon) that are dynamically stored in a MS SQL 2000 database > every 10 seconds. I get this info, convert to a point layer and display in a > map, over other static layers. And works fine. > > So, my question is, in the p.mapper framework is mandatory to modify my DB > connection functions and use PEAR for that stuff? > If not, is there someone to give me a hand on how to use my existing > functions for DB data retrieval? In which file must I put the functions? > > Thank you in advance, > Gaston. > > Great year for all of you. > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys - and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > pmapper-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/pmapper-users > ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ pmapper-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/pmapper-users
