<?php
$databasehost = "localhost";
$databasename = "xxxxxx";
$databaseusername ="xxxxxx";
$databasepassword = "xxxxxxx";
$con = mysqli_connect($databasehost,$databaseusername,$databasepassword,$databasename) or die(mysqli_error($con));
mysqli_select_db($con,$databasename) or die(mysqli_error());
mysqli_query($con,"SET CHARACTER SET utf8");
mysqli_query($con,"SET NAMES 'utf8'");
mysqli_set_charset ($con , "utf8");
$query = file_get_contents("php://input");
$sth = mysqli_query($con, $query);
if (mysqli_errno($con)) {
header("HTTP/1.1 500 Internal Server Error");
echo $query.'\n';
echo mysqli_error($con);
}
else
{
$sth = mysqli_query("SELECT Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday FROM tablename");
$rows = array();
while($r = mysqli_fetch_assoc($sth)) {
array_push($rows,$r);
}
print json_encode($rows);
}
mysqli_close($con);
?>