[OpenLayers-Users] WKT in MySQL
Kusum
kusum at infobase.in
Fri Apr 25 03:24:57 EDT 2008
try this code.....
var features1 = [];
var g = wkt.read("the data goes here");
features1.push(g);
vectors.addFeatures(features1);
--------------------------------------------------
From: "petey1815" <lootens.pieter at gmail.com>
Sent: Friday, April 25, 2008 12:45 PM
To: <users at openlayers.org>
Subject: Re: [OpenLayers-Users] WKT in MySQL
>
> Thanks for the info, my knowledge of javascript is rather limited atm.
>
> I've included the quotes (tried ", as well '), but now javascripts throws
> that vectors is empty or not an object...
>
> Is there a way to find out the line number in the actual html? As i can't
> seem to relate the javascript error lines to the actual html.
>
>
> mpriour wrote:
>>
>> ok so the problem is that you do not have your WKT enclosed in quotes.
>> Thus it is being read as if it is a javascript function and when it hits
>> the first comma in the WKT string, the javascript engine gets confused.
>> So wrap the WKT strings in quotes and it should.
>> Also, a hint for performance improvement when you do get it working, is
>> to
>> only declare the features variable once and then reassign it's value, or
>> to just directly load them into the vector layer via:
>> vectors.addFeatures(WKT.read("A WKT string"));
>>
>>
>> petey1815 wrote:
>>>
>>> http://www.nabble.com/file/p16891470/error.jpg
>>>
>>> From javascript, line number is 72, but i can't really see anything
>>> wrong
>>> there... Page is available here
>>>
>>> www.icoe.be/NW/PHP/LGEMap.php
>>>
>>> thx
>>> Pieter
>>>
>>>
>>>
>>> mpriour wrote:
>>>>
>>>> Are you getting the ')' expected area from javascript or PHP?
>>>> Do you know approximately where (which line or from which function) the
>>>> error is occuring?
>>>> Such information would greatly simplify helping you debug this.
>>>> Matt Priour
>>>>
>>>>
>>>> petey1815 wrote:
>>>>>
>>>>> Hi all,
>>>>>
>>>>> I'd like some help on the following. I'm trying to get a table from my
>>>>> MySql database that contains WKT formatted strings formed as
>>>>> (POLYGON((x1 y1,x2 y2,...,xn yn)) to show up on a vector feature map
>>>>> as
>>>>> polygons. I've inserted the code below, using php to loop throught the
>>>>> table & create a polygon for each line in the table. I'm getting ')'
>>>>> expected errors & i truly have no idea what could be wrong. I've also
>>>>> inserted some of the generated code by the php loop. Any pointers will
>>>>> be greatly appreciated.
>>>>>
>>>>> thx
>>>>> Pieter
>>>>>
>>>>> Code: <script type="text/javascript">
>>>>> var map, vectors, drawControls, wkt;
>>>>>
>>>>> function init(){
>>>>> map = new OpenLayers.Map('map');
>>>>> var wms = new OpenLayers.Layer.WMS( "OpenLayers WMS",
>>>>> "http://labs.metacarta.com/wms/vmap0?", {layers:
>>>>> 'basic'});
>>>>>
>>>>> var options = {maxResolution: 'auto',maxExtent: new
>>>>> OpenLayers.Bounds(0.5, 0.5, 4125, 3300),numZoomLevels: 6};
>>>>>
>>>>> var graphic = new OpenLayers.Layer.Image(
>>>>> 'NTW2 Campaign Map',
>>>>>
>>>>> 'C:/victory/rules/LGE/La_Guerre_Map_new.jpg',
>>>>> new OpenLayers.Bounds(0.5, 0.5, 4125,
>>>>> 3300),
>>>>> new OpenLayers.Size(4125,3300),
>>>>> options);
>>>>>
>>>>> vectors = new OpenLayers.Layer.Vector("Vector
>>>>> Layer",{layers: 'basic'} );
>>>>>
>>>>> map.addLayers([graphic, vectors]);
>>>>> map.addControl(new OpenLayers.Control.LayerSwitcher());
>>>>> map.addControl(new OpenLayers.Control.MousePosition());
>>>>>
>>>>> wkt = new OpenLayers.Format.WKT();
>>>>>
>>>>> map.setCenter(new OpenLayers.LonLat(179, 179), 0);
>>>>>
>>>>> }
>>>>>
>>>>> function toggleControl(element) {
>>>>> for(key in drawControls) {
>>>>> var control = drawControls[key];
>>>>> if(element.value == key && element.checked) {
>>>>> control.activate();
>>>>> } else {
>>>>> control.deactivate();
>>>>> }
>>>>> }
>>>>> }
>>>>>
>>>>>
>>>>> <?php
>>>>>
>>>>> $query="SELECT * from WKT";
>>>>> $result = mysql_query($query)or die(mysql_error());
>>>>>
>>>>> While(list($ID,$Region)=mysql_fetch_row($result))
>>>>> {
>>>>> echo "var features = wkt.read$Region);
>>>>> vectors.addFeatures(features);
>>>>> ";
>>>>>
>>>>> }
>>>>> ?>
>>>>>
>>>>>
>>>>>
>>>>> </script>
>>>>>
>>>>> code generated by the PHP loop:
>>>>>
>>>>>
>>>>>
>>>>> var features = wkt.read(POLYGON((792.626629351515 1810.98291830077,
>>>>> 794.560304290807 1812.01421160173, 802.681739035836 1810.98291830077,
>>>>> 813.768142021113 1806.98665675956, 827.819513246638 1806.98665675956,
>>>>> 837.874622930959 1809.04924336148, 846.898439314324 1814.97917984197,
>>>>> 856.953548998645 1817.04176644389, 866.879747020347 1818.07305974484,
>>>>> 878.99744330658 1819.1043530458, 890.083846291857 1819.1043530458,
>>>>> 900.138955976178 1818.07305974484, 915.09270884004 1814.07679820364,
>>>>> 925.147818524361 1809.04924336148, 935.202928208682 1802.99039521836,
>>>>> 949.254299434207 1795.90025377429, 961.37199572044 1790.87269893213,
>>>>> 969.364518802849 1781.84888254876, 978.388335186214 1773.85635946635,
>>>>> 986.509769931243 1764.83254308299, 989.474738171491 1754.77743339867,
>>>>> 989.474738171491 1744.72232371435, 992.43970641174 1734.66721403003,
>>>>> 991.537324773403 1722.67842940641, 990.506031472447 1712.62331972209,
>>>>> 991.537324773403 1702.56821003777, 991.537324773403 1691.48180705249,
>>>>> 986.509769931243 1681.42669736817, 987.412151569579 1670.34029438289,
>>>>> 993.470999712696 1660.41409636119, 1001.4635227951 1653.32395491712,
>>>>> 1010.61625084109 1642.23755193184, 1019.64006722445 1635.27632215039,
>>>>> 1033.69143844998 1635.27632215039, 1043.7465481343 1635.27632215039,
>>>>> 1053.80165781862 1630.24876730823, 1061.79418090103 1621.22495092487,
>>>>> 1068.75541068248 1609.10725463863, 1072.88058388631 1597.11847001502,
>>>>> 1072.88058388631 1583.96948042783, 1071.84929058535 1571.98069580422,
>>>>> 1071.84929058535 1559.86299951798, 1071.84929058535 1548.90550819533,
>>>>> 1070.8179972844 1537.81910521005, 1070.8179972844 1527.76399552573,
>>>>> 1070.8179972844 1516.67759254045, 1070.8179972844 1502.62622131493,
>>>>> 1068.75541068248 1490.63743669131, 1068.75541068248 1479.55103370603,
>>>>> 1068.75541068248 1469.49592402171, 1065.79044244224 1458.53843269906,
>>>>> 1062.82547420199 1448.48332301474, 1061.79418090103 1438.42821333041,
>>>>> 1055.73533275791 1429.40439694705, 1042.71525483334 1429.40439694705,
>>>>> 1030.59755854711 1429.40439694705, 1020.54244886279 1432.3693651873,
>>>>> 1007.52237093822 1439.45950663137, 998.498554554856 1448.48332301474,
>>>>> 986.509769931243 1452.47958455594, 975.423366945966 1459.44081433739,
>>>>> 966.399550562601 1467.56224908242, 954.281854276368 1475.55477216483,
>>>>> 945.258037893003 1482.6449136089, 940.230483050842 1492.5711116306,
>>>>> 934.171634907726 1500.69254637563, 924.245436886024 1504.68880791684,
>>>>> 914.190327201703 1511.65003769829, 906.068892456675 1519.77147244332,
>>>>> 898.076369374266 1528.79528882668, 890.083846291857 1539.88169181196,
>>>>> 885.958673088033 1550.83918313462, 881.060029908492 1561.9255861199,
>>>>> 881.060029908492 1573.01198910517, 873.969888464419 1586.03206702974,
>>>>> 868.942333622259 1597.11847001502, 862.883485479142 1605.11099309743,
>>>>> 854.890962396733 1620.19365762391, 847.800820952661 1628.18618070632,
>>>>> 843.804559411456 1638.24129039064, 840.839591171208 1648.29640007496,
>>>>> 839.808297870252 1659.38280306024, 845.867146013368 1667.37532614265,
>>>>> 843.804559411456 1677.43043582697, 833.749449727135 1672.40288098481,
>>>>> 821.760665103522 1674.46546758672, 816.733110261361 1683.48928397008,
>>>>> 825.756926644726 1689.5481321132, 835.812036329047 1689.5481321132,
>>>>> 845.867146013368 1694.44677529274, 843.804559411456 1706.56447157897,
>>>>> 835.812036329047 1712.62331972209, 825.756926644726 1717.65087456425,
>>>>> 815.701816960405 1726.67469094762, 807.709293877996 1735.69850733098,
>>>>> 798.685477494631 1745.7536170153, 797.654184193675 1758.77369493987,
>>>>> 794.560304290807 1769.86009792515, 792.626629351515 1780.94650091043,
>>>>> 789.661661111266 1795.90025377429, 792.626629351515
>>>>> 1810.98291830077)));
>>>>> vectors.addFeatures(features);
>>>>> var features = wkt.read(POLYGON((986.509769931243 1764.83254308299,
>>>>> 978.388335186214 1773.85635946635, 979.41962848717 1781.84888254876,
>>>>> 985.478476630287 1789.97031729379, 1000.56114115677 1789.97031729379,
>>>>> 1013.58121908134 1789.97031729379, 1025.57000370495 1790.87269893213,
>>>>> 1035.62511338927 1794.99787213595, 1043.7465481343 1802.99039521836,
>>>>> 1053.80165781862 1810.98291830077, 1065.79044244224 1817.04176644389,
>>>>> 1075.84555212656 1826.06558282725, 1085.90066181088 1830.06184436846,
>>>>> 1097.88944643449 1830.06184436846, 1107.94455611881 1829.0305510675,
>>>>> 1117.99966580313 1824.13190788796, 1126.12110054816 1818.07305974484,
>>>>> 1136.04729856986 1808.01795006052, 1143.13744001394 1800.02542697811,
>>>>> 1153.19254969826 1791.90399223308, 1163.24765938258 1782.88017584972,
>>>>> 1172.27147576594 1777.85262100756, 1182.32658545026 1770.8913912261,
>>>>> 1191.35040183363 1763.80124978203, 1202.43680481891 1756.84002000058,
>>>>> 1215.45688274347 1749.74987855651, 1225.5119924278 1742.65973711243,
>>>>> 1237.50077705141 1733.63592072907, 1248.58718003669 1726.67469094762,
>>>>> 1256.5797031191 1717.65087456425, 1265.73243116508 1710.56073312018,
>>>>> 1274.75624754844 1704.50188497706, 1285.7137388711 1694.44677529274,
>>>>> 1285.7137388711 1684.52057727104, 1277.72121578869 1674.46546758672,
>>>>> 1275.65862918678 1660.41409636119, 1274.75624754844 1650.35898667687,
>>>>> 1271.66236764558 1640.30387699255, 1271.66236764558 1625.22121246607,
>>>>> 1271.66236764558 1613.10351617984, 1268.69739940533 1600.08343825527,
>>>>> 1268.69739940533 1588.09465363165, 1267.66610610437 1574.94566404446,
>>>>> 1266.63481280342 1564.89055436014, 1265.73243116508 1550.83918313462,
>>>>> 1265.73243116508 1539.88169181196, 1265.73243116508 1529.82658212764,
>>>>> 1264.70113786412 1519.77147244332, 1258.64228972101 1507.65377615709,
>>>>> 1253.61473487885 1498.62995977372, 1253.61473487885 1488.5748500894,
>>>>> 1252.58344157789 1477.61735876674, 1252.58344157789 1465.49966248051,
>>>>> 1252.58344157789 1455.44455279619, 1247.55588673573 1445.38944311187,
>>>>> 1237.50077705141 1442.42447487162, 1226.54328572875 1443.45576817257,
>>>>> 1218.42185098372 1449.38570465307, 1206.43306636011 1452.47958455594,
>>>>> 1195.34666337483 1452.47958455594, 1185.29155369051 1452.47958455594,
>>>>> 1172.27147576594 1452.47958455594, 1161.18507278067 1452.47958455594,
>>>>> 1150.22758145801 1452.47958455594, 1141.07485341202 1445.38944311187,
>>>>> 1131.14865539032 1438.42821333041, 1123.02722064529 1431.33807188634,
>>>>> 1111.03843602168 1430.30677858539, 1099.9520330364 1430.30677858539,
>>>>> 1089.89692335208 1430.30677858539, 1079.84181366776 1431.33807188634,
>>>>> 1068.75541068248 1431.33807188634, 1055.73533275791 1429.40439694705,
>>>>> 1061.79418090103 1438.42821333041, 1062.82547420199 1448.48332301474,
>>>>> 1065.79044244224 1458.53843269906, 1068.75541068248 1469.49592402171,
>>>>> 1068.75541068248 1479.55103370603, 1068.75541068248 1490.63743669131,
>>>>> 1070.8179972844 1502.62622131493, 1070.8179972844 1516.67759254045,
>>>>> 1070.8179972844 1527.76399552573, 1070.8179972844 1537.81910521005,
>>>>> 1071.84929058535 1548.90550819533, 1071.84929058535 1559.86299951798,
>>>>> 1071.84929058535 1571.98069580422, 1072.88058388631 1583.96948042783,
>>>>> 1072.88058388631 1597.11847001502, 1068.75541068248 1609.10725463863,
>>>>> 1061.79418090103 1621.22495092487, 1053.80165781862 1630.24876730823,
>>>>> 1043.7465481343 1635.27632215039, 1033.69143844998 1635.27632215039,
>>>>> 1019.64006722445 1635.27632215039, 1010.61625084109 1642.23755193184,
>>>>> 1001.4635227951 1653.32395491712, 993.470999712696 1660.41409636119,
>>>>> 987.412151569579 1670.34029438289, 986.509769931243 1681.42669736817,
>>>>> 991.537324773403 1691.48180705249, 991.537324773403 1702.56821003777,
>>>>> 990.506031472447 1712.62331972209, 991.537324773403 1722.67842940641,
>>>>> 992.43970641174 1734.66721403003, 989.474738171491 1744.72232371435,
>>>>> 989.474738171491 1754.77743339867, 986.509769931243
>>>>> 1764.83254308299)));
>>>>> vectors.addFeatures(features);
>>>>> var features = wkt.read(POLYGON((794.560304290807 1812.01421160173,
>>>>> 792.626629351515 1810.98291830077, 781.02457971576 1819.1043530458,
>>>>> 771.485116681917 1826.19449448987, 777.415053162414 1836.89416248729,
>>>>> 791.724247713178 1838.18327911348, 771.485116681917 1845.27342055756,
>>>>> 760.785448684498 1852.36356200163, 750.08578068708 1846.43362552113,
>>>>> 738.096996063466 1846.43362552113, 728.686444692243 1854.8128835914,
>>>>> 719.1469816584 1864.35234662524, 710.767723588132 1876.21221958624,
>>>>> 698.907850627138 1884.5914776565, 689.368387593295 1897.61155558107,
>>>>> 677.508514632301 1898.77176054465, 664.359525045112 1898.77176054465,
>>>>> 653.659857047694 1908.31122357849, 651.339447120543 1921.46021316568,
>>>>> 657.26938360104 1932.1598811631, 667.969051598458 1938.0898176436,
>>>>> 680.989129523028 1941.69934419694, 671.578578151804 1949.94969060459,
>>>>> 660.749998491766 1955.87962708509, 647.729920567197 1961.80956356558,
>>>>> 633.420726016432 1964.25888515535, 639.350662496929 1976.11875811635,
>>>>> 645.409510640046 1988.10754273996, 659.589793528191 1991.58815763069,
>>>>> 673.898988078955 1986.81842611377, 685.758861039949 1979.72828466969,
>>>>> 697.747645663563 1979.72828466969, 709.607518624557 1979.72828466969,
>>>>> 721.467391585551 1982.04869459685, 733.327264546545 1990.42795266711,
>>>>> 745.316049170158 1992.74836259426, 756.015717167577 1982.04869459685,
>>>>> 764.266063575225 1972.63814322562, 776.254848198838 1961.80956356558,
>>>>> 788.114721159832 1953.55921715794, 799.974594120826 1953.55921715794,
>>>>> 813.123583708015 1951.10989556817, 826.143661632585 1951.10989556817,
>>>>> 840.452856183349 1952.39901219436, 853.601845770538 1948.78948564101,
>>>>> 863.012397141762 1941.69934419694, 869.071245284878 1952.39901219436,
>>>>> 864.301513767957 1965.41909011893, 864.301513767957 1979.72828466969,
>>>>> 864.301513767957 1992.74836259426, 861.852192178186 2005.89735218145,
>>>>> 859.531782251035 2020.20654673222, 859.531782251035 2033.22662465679,
>>>>> 858.37157728746 2045.2154092804, 864.301513767957 2055.91507727782,
>>>>> 876.161386728951 2055.91507727782, 888.021259689945 2055.91507727782,
>>>>> 901.170249277134 2049.98514079732, 905.939980794055 2036.83615121013,
>>>>> 907.100185757631 2024.97627824914, 917.799853755049 2019.04634176864,
>>>>> 929.659726716043 2014.27661025172, 942.808716303232 2010.66708369837,
>>>>> 954.668589264226 2007.05755714503, 964.208052298069 1999.96741570096,
>>>>> 977.228130222639 1997.51809411119, 991.537324773403 2003.5769422543,
>>>>> 1004.68631436059 2005.89735218145, 1018.86659724874 2008.2177621086,
>>>>> 1032.01558683593 2004.73714721788, 1042.71525483334 1996.35788914761,
>>>>> 1052.25471786719 1988.10754273996, 1051.09451290361 1973.7983481892,
>>>>> 1049.80539627742 1961.80956356558, 1043.87545979692 1951.10989556817,
>>>>> 1041.55504986977 1939.25002260717, 1041.55504986977 1927.39014964618,
>>>>> 1042.71525483334 1915.53027668518, 1042.71525483334 1902.38128709799,
>>>>> 1041.55504986977 1885.75168262008, 1041.55504986977 1871.44248806931,
>>>>> 1041.55504986977 1858.42241014475, 1043.87545979692 1846.43362552113,
>>>>> 1049.80539627742 1834.57375256014, 1055.86424442053 1822.71387959914,
>>>>> 1053.80165781862 1810.98291830077, 1043.7465481343 1802.99039521836,
>>>>> 1035.62511338927 1794.99787213595, 1025.57000370495 1790.87269893213,
>>>>> 1013.58121908134 1789.97031729379, 1000.56114115677 1789.97031729379,
>>>>> 985.478476630287 1789.97031729379, 979.41962848717 1781.84888254876,
>>>>> 978.388335186214 1773.85635946635, 969.364518802849 1781.84888254876,
>>>>> 961.37199572044 1790.87269893213, 949.254299434207 1795.90025377429,
>>>>> 935.202928208682 1802.99039521836, 925.147818524361 1809.04924336148,
>>>>> 915.09270884004 1814.07679820364, 900.138955976178 1818.07305974484,
>>>>> 890.083846291857 1819.1043530458, 878.99744330658 1819.1043530458,
>>>>> 866.879747020347 1818.07305974484, 856.953548998645 1817.04176644389,
>>>>> 846.898439314324 1814.97917984197, 837.874622930959 1809.04924336148,
>>>>> 827.819513246638 1806.98665675956, 813.768142021113 1806.98665675956,
>>>>> 802.681739035836 1810.98291830077, 794.560304290807
>>>>> 1812.01421160173)));
>>>>> vectors.addFeatures(features);
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
> --
> View this message in context:
> http://www.nabble.com/WKT-in-MySQL-tp16852122p16891948.html
> Sent from the OpenLayers Users mailing list archive at Nabble.com.
>
> _______________________________________________
> Users mailing list
> Users at openlayers.org
> http://openlayers.org/mailman/listinfo/users
More information about the Users
mailing list