Re: [pmapper-users] Add point in MySQL database

[Armin Burger]

just discovered that mails with zip attachments seem not to pass through 
the mail filters of Sourceforge. Another try: rename the file from *.txt 
to *.zip. Also as suggestion for future postings.

armin


<<<<
"Hi all,
I'm sorry for the late answer. This mail would answer to Tiziano's mail
(points
of interest and PEAR). As attachmanet you can find four files that improved
pmapper with the possibility to insert new points in a postgis table.
Armin sent
to me and I modified for my aims (it works of sure on pmapper 1.9.5, pmapper
2.1.2 and now pmapper 3.0.0-beta1).

I have the following configuration in pmapper 3.0.0-beta1:
/var/www/html/pmapper-3.0.0-beta1/digitizedlg.phtml
/var/www/html/pmapper-3.0.0-beta1/incphp/digitize.php
/var/www/html/pmapper-3.0.0-beta1/incphp/xajax/x_digitize.php
/var/www/html/pmapper-3.0.0-beta1/javascript/digitize.js

digitizedlg.phtml: modify the insert-page
digitize.php: change the connection to postgres (dbname, dbowner,
dbpassword,
port ...)
digitize.js: change the width and the height of the insert-page

I modified the following file to create the insert-button:

1) /var/www/html/pmapper-3.0.0-beta1/config/default/php_config.php:
in the "$buttons = array" I added:
"digitize"    => array(_p("Digitize"), "0"),

2) /var/www/html/pmapper-3.0.0-beta1/javascript/pmapper.js
in the "Function for state buttons (CLICKED TOOLS:..." I added
|| tdid == 'digitize' ||

3) I change the name of the "coords_off" button to "digitize_off" button
in the
/var/www/html/pmapper-3.0.0-beta1/images/buttons/default folder

4) In the map file  I set the connection to postggis in the following way

LAYER
  CONNECTIONTYPE postgis
  NAME "siti3"
  CONNECTION "user=youruser password=yourpassword dbname=yourdbname
host=localhost port=5432"
  DATA "geometry from (select
oid,geometry..-your_table's_field_here-...,id from
siti3) as newtable using unique OID"
  TYPE POINT
  TOLERANCE 10
  TOLERANCEUNITS pixels
  PROJECTION
    "init=epsg:26591"
  END
  ....

I hope to be usefull.
if you need more help please tell me.
bye
Ale"

 >>>>

armin

Chris Beaart wrote:
I have already created a MySQL database and a table with some fields such as
x and y. In my map-file I added some lines, so I can visualize the MySQL
records as a point layer. Now I like to create a new tool. With this new
tool I would like to click somewhere in the map, retrieve de x,y-coordinates
and add the values in the MySQL database.

 

Can somebody please help me.

 

Thanks,

Chris Beaart.

 

-------------------------------------------------------------------------
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
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users


PKAv5—è);£\
digitize.php•Vño£6þ½RÿØÒ±ît“Ön½µ
»‹Ô#]“ÜZU'ä€ÖScVÒÓýï{lL&-‘ã÷½Ïï=?æ×÷ER ã#Nž+ÊIÀò 
ۚ]ýó–s~|T’²¤,J¹°åŒ‰µ­eË5¼ý>Uy(ÀÍ®E·ŒæÂ~C³¸ÞNћE4$Í «r9(0)[EMAIL 
PROTECTED]    ÿž2)wNʂå%ÞД6x\ñ΅”!§Š5ä,g)‹©t´Ð㼁5ठ
\HŽ˜°Œñ'ØÐMJYÌñS󃈢0Æ© ºs|ô!(/üÀ› [EMAIL 
PROTECTED]>Xç¦Yl"ÍE\>§ÖyoÈqÖ^Èó0!Ì4Vgã|1ämڊ—²)D™K«ZûÌuáYçý»
ÛUq)\]/üÏÞÝ
ÝÎï½tï> Õ}º¼Ek¾Zv+5{`.#%u‘²zYÓÎ⨘렠5`z‡Ç¿(ãvßxªŒFV¼…w¿’¸`é-—ó…ÿhµs–¦‚Íœ‘Tà{
   
kV†ëÚú‚NŒš×ûN;NÛ=§­vê\3\ü5Œf^h$’žf>îaBãDìÒÕ
ÄXΪ<²wÂEß#Ûn+é6;ßõù:N_ÍÃ*àØjŽÇp
 yÌû€ú‘Ù¾w½’Í0»B—þ
Ý­}ôçÚ»{è˙Á·²?Àøβ©…=¹]Ìý•ÝeÙêL¦?ýüî—SÇ82pJ¤ïÜ_Êþ—] omÅ<í¤¦šVf´ÈìHŒ!0­¼˜â¢¥e
 ,[EMAIL PROTECTED]:ñ˜jAqŒ"ËÏ粵·´uý¦;öî£uö uÒ©ïdÔÞTkܬÊ8™þ—]U÷0ÊõÃ,[EMAIL 
PROTECTED]:;wÍ&Ãm®Yž“^àòÑZÛP¥òj”°“‹çŠð­&é%%!áßH$XhZ¢œ    
„sÔ¬ÞBé²gWgg´ôä¤Ý}훹])¢eØä7      '¢â9Rž'1ŸàMÇÄÖ
ú
‘´$ÿ—óTy›Õ9>ú¶÷î´S*x—TR&¨å^òfQxÇkC=”–«¿¾¹M¶ÃH¢>%Æû‹
PKAv5¢‰¿&ôdigitizedlg.phtmlÍXín¹ýoÀïÀNSȃÇMkK2’ØÎë]¶Eë,j†’ˆp†ÓÊÙ¸Ø7Ú·è‹õòsȑFRº?²2l‹äááåå%ï!Å¢Øß+É¿—´$ž'ä
 ¢yµ½”Ω Ï¤…èð¼•ð,ãùf̜ñ)f•íïõzïúÈèòæýÍÛۛû›«»Ÿ~|¯yX
ÂðþÞe/”û?£!êô;çH~ü–—ªåeçܯ<Q•'[EMAIL PROTECTED]
NÕôJ5½ªIU­c
[EMAIL PROTECTED]
‡ô‰+œ-4LÑȜ̱Cڂ!®¥„Á¯"q£¨–ÇÜôj2ëÖê¿¿©føoø2žbF…s½-?Îx)[EMAIL PROTECTED] 
uàjYrFŠÑxµ÷j<ÏS<ŸSÍîJk¤$¯¬3\ÉùÞ
uxêÑÍ÷ŽŠR9Ë9á/gœñ9uS…ÊljÂOó’-˜   
^PlüéJµ‰”ðœÓTj¾‡€”W•fPߜٲmÓæO˜£ëb€ª
éëVS‚”%~~ÖÃØB€x"e…s¡9l
ÒR2£9DÍ4¾˜¼¿zxŒ¼Êèg˜¡yˆþ³¿'ö‚fó_¾ÔUQuùV‘5¸ãû¨šqšÖ&h„­Òlr!õ²Å6ֆ$<¥
      Q«è‘èÚz8ç–9    ²¦F˜€Ùu»*×͌'*܂Ql%À|[EMAIL PROTECTED]'ÚJ‡*‰»
O)£
ÒoðìÃËrÕD]Y[Iª¤¤«îñê6)[EMAIL PROTECTED])£|^âYî7Ôì%NùYÈlkÎ!Á 
LRýN½€Ë     ‚¥¸|kÂ7–D,Ëz_¾À.ú 
wсޞ±ÝE±Ý(±Ùqøq3ºc?xcŸq‡qiqNq/q±¿ì±·²ñÊêōµ‰CßǞscçÀÃðP¹íï
¾{øáVý¿zs)ÿ3šB%aè_©„ˆ-J2F‚dЯ{U² 
)žÈtÞMª*BâKA$àѓeÉ$¨`dt½ÌSÈ_pÀ#u2ƒC*JJ’zȞüíøòŸ12.ç4F'@ͯ¤¿~¦©X¨2Ïo9N‡Ñg
‰äswƓeup!I÷§£#hÿ)g
Á’“²[`\t3\\—8#ݒdü‰ÜÉTTT+;Àrt¤f‚§`¾³|ü—%WÕ0zûþ´ýz<~ˆFQÂo:º‡ºË7èþæa
“LGð§”$‹¤+FÒû­_ZÉ3gfi®Çw? [EMAIL PROTECTED])#”ƒ‡†6¡ 
ÆœF#Õëzüãz7¾ß
£?OûÓi-“¯øz’b¤"¢ÃèaÅ]FaƯOm¯XïéH5‚“Ł“ÆWö¥Žäß)yvIÓ~H²àè 
ðB:Y’áÇHÂ?F¶× §›GJüÛ®¿Ú¯ƞAOÛ;r>Uk¾Æñò€Ùàx¹j¯«$m½Þ×^WG“êÛÖO'ïF7{’u6vu9Ýô~½Ã)ééús
ÆçÖf¸SYþE­Dƒ'vÙáŃöÄæ ÐÚF'
8™xÅÁܵêÙmښ÷ÛÌ[•d2ôæ¥má+5/Ot8¸ëZg…-pŽÓp»ùÇéÀ?ÂQÑ
_/츧ajwÔkíB«7VÏV'Rwsš¾‰àÚì6OL5¼&=™Ûpó$7J8«†¯_£’®†ýS¹4½e•jµ¶ë™^Ëw³B'æÌsZoã
]«zÛý՚º‘sá¸sò
      /vKþÝlI£(WŒm(«ÒM÷¿éÞY·ê²nÖmUVø
w,® »Å/ôùCîw_¼oŽÜà&[EMAIL 
PROTECTED];F“O ÿ—ÓŒŠƒÃóÿG8k[ù§Èx/ïBö8ÚapÂf݄ñŠü.œ'„9#Þäù’1ì[òûUì׉Ý
6—©…ÅY¯§”ЂW¢·œ6ÛÑI÷¸{|4%÷{
Š®Vû°ªs"†ÑdÊpþ©iø1|f³hôÝÕí;R«‹FèéMS’[ÿè)ëžÁ…}ópu1Z]¨°»{®²
}uóëɛKxɑïbgzGèûŽ»“QÿðLÞß/T&uG¤c^}©<ˆ¤’LeçD
ð¡Žã½YírͱS4Og[ö¥»z´ÐÔOM¦ÝÄmŽz£ÛJ¢Ä}‡~ÅÛJaE~‹{ìÛ暍Â?ds‚k8›tê¾m–õ£á6•n¡Ñêxƒ§J[xü—ÇmlVq¶P9Aºgƒ8´\Áóåv?i
Øê*ó¸¹Õ[­êËyË{
ÝÆÖ*®Üž©ŸH·q9ÝÔBU¿¡nµj£œª·søÖºõ˜ñ¥LÛQ¼Ånc4Ê«…˾¨ncÙ 
K,Uðä»æðñ”‡)"ËÑ:
`RÉ»]¦´EèÄÔ3LA¦       
rM­å'£«»»ñÝ ßÐÇÜSmb3O’o5ûøy§+óŽiÊäeÍ0ƒËÏT’Z%wéÎT“<¥³s™ôTnT%›eþ”ï úaT¿Îڟÿ
PK
Av5V–ûå.
Ø
x_digitize.phpu_kÂ0Åßý— DÁÙm:§ ²?¸MhRJm¯6#&[EMAIL 
PROTECTED]
¹ÛIqb S+C'»›'+Z+šºiGI&ì‚ë$l—¥s˜NIÞk‰üÚ   
\]?ÿŒ¯Ú±m¼S­y‰…÷:®ÓcŽ,žÇñÃ˳K¡yÖ†¦«ô—ß<{xæ%ê.™IaQ؋äSá,66R<gbE•kƒvL`gþ%nf…Gh´µðƒ\¿aa3‹Úõ
        ä{O`#5¼>-î“d    ¾Xt݄
•túm%Ë!-ٖYö…K—ö½çGÎkRßݓöØäöPK
Av5%ÚýEÞG
digitize.jseŽÏŠÂ0Æï‚ï0䠕F­{‘°—^ö²,øÑÄt 
JMë²ï¾M»ÂÂÎá†ùÍ7ßín¯×I۠ˆOÙhU´=…Q‡
|[EMAIL PROTECTED]
ͺß{iÜCžóéÐÆP¬Å¯ùzsz1Âóô!ÓDL·‡ù嶦ðÿ`քV¸´Ëyòb„V»®F¿‘òüތ¹VBÞÐÊ.{³ÃjÊÍH9u
      %       
ElY}¬h+Qµ‘ÕUECäñ˜uÔˀO~Ñ2áêÖîóŠälËÅ÷PK
Av5—è);£\

 digitize.phpPK
Av5¢‰¿&ô
 
Ídigitizedlg.phtmlPK

Av5V–ûå.
Ø

 "x_digitize.phpPK

Av5%ÚýEÞG

 |
digitize.jsPKîƒ-------------------------------------------------------------------------
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
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users