MYSQL 2 JSON with PHP Saved as JSON-File

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;
    }
?>