Export MySQL to Json: Difference between revisions
Jump to navigation
Jump to search
Kaplanerkan (talk | contribs) No edit summary |
Kaplanerkan (talk | contribs) |
||
Line 14: | Line 14: | ||
== Datas.json == | == Datas.json saved as Array == | ||
<pre> | <pre> | ||
[ | [ | ||
Line 28: | Line 28: | ||
] | ] | ||
</pre> | </pre> | ||
== Parse the Result == | == Parse the Result == |
Revision as of 13:37, 4 October 2013
SET SESSION group_concat_max_len = 100000000; // IMPORTANT SELECT CONCAT("[", GROUP_CONCAT( CONCAT("{ \"Menue\": \" ", Menue , " \" "), CONCAT(", \"Text_D\": \" ", Text_D), " \"}") ,"]") AS json FROM menu ;
Datas.json saved as Array
[ {"Menue":"1", "TextD":"Sake"}, {"Menue":"2", "TextD":"Maguro"}, {"Menue":"3", "TextD":"Mutsu"}, {"Menue":"4", "TextD":"Izumidai"}, {"Menue":"5", "TextD":"Amaebi"}, {"Menue":"6", "TextD":"Ebi"}, {"Menue":"7", "TextD":"Kanikama"}, {"Menue":"8", "TextD":"Avocado"}, {"Menue":"9", "TextD":"Tamago"} ]
Parse the Result
Function Button1_onclick() $.getJSON("datas.json", gotResult) End Function Function gotResult(data) Dim speisen=[] For i=0 To 10 speisen[i]=[String(data[i].Menue),String(data[i].TextD)] Next End Function 'JavaScript ' var speisen=[]; ' $.getJSON("datas.json", function(data) { ' var i=0; ' for (i=0; i<10; i++){ ' speisen[i]=[String(data[i].Menue),String(data[i].TextD)]; ' } ' }); 'End JavaScript ' ANOTHER METHODS 'JavaScript '$.getJSON( "datas.json", function(data) { ' var items = []; ' $.each( data, function( key, val ) { ' items.push( "<li id='" + key + "'>" + val + "</li>" ); ' }); ' ' $( "<ul/>", { ' "class": "my-new-list", ' html: items.join( "" ) ' }).appendTo( "body" ); '}); ' ' 'End JavaScript