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

[Harris Sontanu]

Hai armin,

Just discovered the mail archive and I found this mail. After read it I
found that I have the same problem with Chris Beaart and I can't find the
solution. Can you help me? I'm using pmapper 4


Armin Burger wrote:
> 
> 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
>> 
> 
> 
> PK����Av5—è);£��\
> �����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)åÊbœrõðõ¿oƒá$¤...@j*ügxà�È
> ÿž2)wNʂå%ÞД6x\ñ΅”!§Š5ä,g)‹©t´Ð㼁5ठ\HŽ˜°Œñ'ØÐMJYÌñS󃈢0Æ©
> ºs|ô!(/üÀ› a...@¿!«in>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
> ,zvlq1$¥”]9�...@j:ñ˜jAqŒ"ËÏ粵·´uý¦;öî£uö uÒ©ïdÔÞTkܬÊ8™þ—]U÷0ÊõÃ,ÍNŒ-alÐDíۘÝÜÎ1ŒÚåÑ0úÍ
> ƒô=1†Ð­2j1ì 1Ø �...@f¿aº6
> Ù¸¾9Õ}ຄsÆXÙòh:;wÍ&Ãm®Yž“^àòÑZÛP¥òj”°“‹çŠð­&é%%!áßH$XhZ¢œ
> „sÔ¬ÞBé²gWgg´ôä¤Ý}훹])¢eØä7    '¢â9Rž'1ŸàMÇÄÖ
> ú
> ‘´$ÿ—óTy›Õ9>ú¶÷î´S*x—TR&¨å^ò�f
> QxÇkC=”–«¿¾¹M¶ÃH¢>%Æû‹
PK����Av5¢‰¿&��ô
> �����digitizedlg.phtmlÍXín¹ýoÀïÀNSȃÇMkK2’ØÎë]¶Eë,j†’ˆp†ÓÊÙ¸Ø7Ú·è‹õòsȑFRº?²2l‹äááåå%ï!Å¢Øß+É¿—´$ž'ä
> ¢yµ½”Ω Ï¤…èð¼•ð,ãùf̜ñ)f•íïõzïúÈèòæýÍÛۛû›«»Ÿ~|¯yX
> ÂðþÞe/”û?£!êô;çH~ü–—ªåeçܯ<Q•'ó=iw”$¡å9±yó...@§
> NÕôJ5½ªIU­c
> j
~¥�...@**¸í¤
> ‡ô‰+œ-4LÑȜ̱Cڂ!®¥„Á¯"q£¨–ÇÜôj2ëÖê¿¿©føoø2žbF…s½-?Îx)�...@¯ð¶Ð
> 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%À|Ôó3~–gЬmr=�...@×Õ©Žˆ�¤j\{Šž€khù ¼z‡µ›'�ÚJ‡*‰»
> O)£
ÒoðìÃËrÕD]Y[Iª¤¤«îñê
> 6)ag©®­«vha...@w[3‚Õà‡iià”á¤m®op„=‚‡ŸÒ)£|^â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? œad­JÙ
> ĨÈx„pfçc¹!�ŒÆ4%9oþu%×!i›Ú...@ðÊ6w7 y
q¯£Œà9)#”ƒ‡†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ŽÜà&†î_Û#wÊ...@åuiiÐpå¦k!x.õ;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:§ ²?¸Mh
> RJm¯6#&y’ŽnÃﾤŠ¸ÁÈk¸çwÏ=œ›‰ªt4†i‘›kÛí�...@ã{Í4frØ%lŽ‹¶\®snîoþ…
> ¹Û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Îk
> Rß�ݓöØäöPK����
> Av5%ÚýEÞ���G
�����digitize.jseŽÏŠÂ0Æï‚ï0䠕F­{‘°—^ö²,øÑÄt
> JMë²ï¾M»ÂÂÎá†ùÍ7ßín¯×I۠ˆOÙhU´=…Q‡
> |-0Ö...@£ú
€åm%’Œš±Óͺß{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
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Add-point-in-MySQL-database-tp7527310p22638211.html
Sent from the pmapper users mailing list archive at Nabble.com.


------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users