Export MySQL to Json

SET SESSION group_concat_max_len = 100000000;  // IMPORTANT

SELECT
  CONCAT("[",
   GROUP_CONCAT(
       CONCAT("{ \"Menue\":  \" ",  Menue  , " \" "),
       CONCAT(", \"Text_D\": \" ",  Text_D), " \"}")
       ,"]")
AS json FROM menu ;

Privat SQL only for me

// SET SESSION group_concat_max_len = 100000000;
// SELECT
//	CONCAT("[",
//	GROUP_CONCAT(
//	CONCAT("{\"Menue\":\"",Menue,"\""),
//	CONCAT(",\"Text_D\":\"",Text_D,"\""),
//	CONCAT(",\"Beschreibung_D\":\"",Beschreibung_D,"\""),
//	CONCAT(",\"Sort\":\"",Sort,"\""),
//	CONCAT(",\"Gruppe\":\"",Gruppe,"\""),
//	CONCAT(",\"Preis3\":\"",Preis3,"\""),
//	CONCAT(",\"WarenGruppe\":\"",WarenGruppe,"\""),
//	CONCAT(",\"Extra\":\"",Extra,"\""),
//	CONCAT(",\"WGruppenText\":\"",waren_gruppen.Text,"\""),
//	CONCAT(",\"Sabu_Sabu\":\"",Sabu_Sabu,"\""),
//	CONCAT(",\"Ipad_Zeitzone\":\"",Ipad_Zeitzone,"\""),
//	CONCAT(",\"ShabuShabu_AH\":\"",ShabuShabu_AH,"\""),
//	CONCAT(",\"ShabuShabu_ALK\":\"",ShabuShabu_ALK,"\""),
//	CONCAT(",\"ShabuShabu_ALK_Preis\":\"",ShabuShabu_ALK_Preis,"\""),
//	CONCAT(",\"Text_D\":\"",Text_D),"\"}")
// ,"]")
// AS json FROM menu  INNER JOIN waren_gruppen ON menu.WarenGruppe = waren_gruppen.Firma ; ;

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 i < data.length
    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

Export whith PHP

<?php
header('Access-Control-Allow-Origin: *');


    mysql_connect("localhost", "root", "here_root_passwort");
    mysql_select_db("databank_name");      
    
    $res = mysql_query("SELECT Menue,.................... ShabuShabu_ALK_Preis FROM menu INNER JOIN waren_gruppen ON menu.WarenGruppe = waren_gruppen.Firma ;");
    $records = array();
    while($obj = mysql_fetch_object($res)) {
        $records []= $obj;
    }
    file_put_contents("d:\\backup\data.json", json_encode($records));
?>