Return to Question

deleted 8 characters in body

edited Feb 3, 2016 at 17:55

760k
186
1.4k
1.5k

theThe aim is to save user inputtedentered JSON into a database Now. Now, before somonebefore someone jumps at me. I, I know json, II know mysql and i KnowI know all the links inbetween.

The issue is, i: I need to safely store the ENTIRE JSON feed in a single cell in the table.

The background is, this: this function will be a temp fix for a tool, thatthat is needed asap but will require alota lot of time. theThe temp fix will allow the system to go live with minimal code.

Users will create a GOOGLE maps style here ( http://gmaps-samples-v3.googlecode.com/svn/trunk/styledmaps/wizard/index.html)

and have the JSON made for them

[ { "stylers": [ { "visibility": "off" } ] },{ "featureType": "water", "stylers": [ { "visibility": "on" } ] },{ "featureType": "transit.line", "elementType": "geometry.fill", "stylers": [ { "visibility": "on" }, { "hue": "#ff3300" }, { "color": "#ff0000" }, { "weight": 0.7 } ] },{ "featureType": "transit.station.rail", "stylers": [ { "visibility": "on" }, { "color": "#0000ff" }, { "weight": 4.6 } ] },{ } ]

The site will then just call the JSON and apply it using JquryjQuery later on. WhatWhat would my ''best practice'' method be at doing this.

the aim is to save user inputted JSON into a database Now, before somone jumps at me. I know json, I know mysql and i Know all the links inbetween

The issue is, i need to safely store the ENTIRE JSON feed in a single cell in the table.

The background is, this function will be a temp fix for a tool, that is needed asap but will require alot of time. the temp fix will allow the system to go live with minimal code.

Users will create a GOOGLE maps style here ( http://gmaps-samples-v3.googlecode.com/svn/trunk/styledmaps/wizard/index.html)

and have the JSON made for them

[ { "stylers": [ { "visibility": "off" } ] },{ "featureType": "water", "stylers": [ { "visibility": "on" } ] },{ "featureType": "transit.line", "elementType": "geometry.fill", "stylers": [ { "visibility": "on" }, { "hue": "#ff3300" }, { "color": "#ff0000" }, { "weight": 0.7 } ] },{ "featureType": "transit.station.rail", "stylers": [ { "visibility": "on" }, { "color": "#0000ff" }, { "weight": 4.6 } ] },{ } ]

The site will then just call the JSON and apply it using Jqury later on. What would my ''best practice'' method be at doing this.

The aim is to save user entered JSON into a database. Now, before someone jumps at me, I know json, I know mysql and I know all the links inbetween.

The issue is: I need to safely store the ENTIRE JSON feed in a single cell in the table.

The background: this function will be a temp fix for a tool, that is needed asap but will require a lot of time. The temp fix will allow the system to go live with minimal code.

Users will create a GOOGLE maps style here ( http://gmaps-samples-v3.googlecode.com/svn/trunk/styledmaps/wizard/index.html)

and have the JSON made for them

[ { "stylers": [ { "visibility": "off" } ] },{ "featureType": "water", "stylers": [ { "visibility": "on" } ] },{ "featureType": "transit.line", "elementType": "geometry.fill", "stylers": [ { "visibility": "on" }, { "hue": "#ff3300" }, { "color": "#ff0000" }, { "weight": 0.7 } ] },{ "featureType": "transit.station.rail", "stylers": [ { "visibility": "on" }, { "color": "#0000ff" }, { "weight": 4.6 } ] },{ } ]

The site will then just call the JSON and apply it using jQuery later on. What would my ''best practice'' method be at doing this.

Source Link

asked Feb 19, 2013 at 1:09

Mark Jones

Json into mysql

the aim is to save user inputted JSON into a database Now, before somone jumps at me. I know json, I know mysql and i Know all the links inbetween

The issue is, i need to safely store the ENTIRE JSON feed in a single cell in the table.

The background is, this function will be a temp fix for a tool, that is needed asap but will require alot of time. the temp fix will allow the system to go live with minimal code.

Users will create a GOOGLE maps style here ( http://gmaps-samples-v3.googlecode.com/svn/trunk/styledmaps/wizard/index.html)

and have the JSON made for them

[ { "stylers": [ { "visibility": "off" } ] },{ "featureType": "water", "stylers": [ { "visibility": "on" } ] },{ "featureType": "transit.line", "elementType": "geometry.fill", "stylers": [ { "visibility": "on" }, { "hue": "#ff3300" }, { "color": "#ff0000" }, { "weight": 0.7 } ] },{ "featureType": "transit.station.rail", "stylers": [ { "visibility": "on" }, { "color": "#0000ff" }, { "weight": 4.6 } ] },{ } ]

The site will then just call the JSON and apply it using Jqury later on. What would my ''best practice'' method be at doing this.

Collectives™ on Stack Overflow

Return to Question

Json into mysql