MYSQL 2 JSON with PHP Saved as JSON-File: Difference between revisions
Jump to navigation
Jump to search
Kaplanerkan (talk | contribs) (Created page with "==Mysql2Json.php == PHP File save into APACHE-Server <pre> <?php header('Access-Control-Allow-Origin: *'); $host = "localhost"; $databasename = "kasse_sql"; $username ="ro...") |
Kaplanerkan (talk | contribs) No edit summary |
||
Line 46: | Line 46: | ||
} | } | ||
?> | ?> | ||
</pre> | |||
== Call From NSB-APPStudio == | |||
<pre> | |||
.............. | |||
.............. | |||
.............. | |||
Rem dont forget ";" | |||
cmdMYSQL = "MY MYSQL_PASSWORT;" | |||
Rem MySql SELECT Command | |||
cmdMYSQL += "Select Kellner, Passwort from Kellner;" | |||
Rem Filename to Save (look in mysql2json.php ) | |||
cmdMYSQL += "1;" | |||
Rem Ajax CMD | |||
req=Ajax("http://localhost/Kasse/mysql2json.php?t=" & cmdMYSQL ) | |||
Rem RESULT | |||
If req.status=200 Then | |||
console.log(req.responseText) | |||
................ | |||
................ | |||
................ | |||
................ | |||
................ | |||
</pre> | </pre> |
Revision as of 23:11, 23 December 2014
Mysql2Json.php
PHP File save into APACHE-Server
<?php header('Access-Control-Allow-Origin: *'); $host = "localhost"; $databasename = "kasse_sql"; $username ="root"; $x = $_GET['t']; $tmp = explode(";",$x); $password = $tmp[0]; $query = $tmp[1] ; $filename = $tmp[2]; $con = mysql_connect($host,$username,$password) or die(mysql_error()); mysql_select_db($databasename) or die(mysql_error()); $results = mysql_query($query); $records = array(); while($obj = mysql_fetch_object($results)) { $records []= $obj; } //echo json_encode($records); //file_put_contents("data.json", json_encode($records)); switch ($filename){ case 1: file_put_contents("Kellnerdaten.json", json_encode($records)); break; case 2: file_put_contents("ipadSpeisekarte.json", json_encode($records)); break; case 3: file_put_contents("ipadWarenGruppen.json", json_encode($records)); break; case 4: file_put_contents("ipadBelegung.json", json_encode($records)); break; default: echo "Filename was not 1-4"; break; } ?>
Call From NSB-APPStudio
.............. .............. .............. Rem dont forget ";" cmdMYSQL = "MY MYSQL_PASSWORT;" Rem MySql SELECT Command cmdMYSQL += "Select Kellner, Passwort from Kellner;" Rem Filename to Save (look in mysql2json.php ) cmdMYSQL += "1;" Rem Ajax CMD req=Ajax("http://localhost/Kasse/mysql2json.php?t=" & cmdMYSQL ) Rem RESULT If req.status=200 Then console.log(req.responseText) ................ ................ ................ ................ ................