<?php
// Anfang
include("xxx/var.php");
// Ende
$conn = new mysqli($dbhost,$dbusername,$dbpassword,$dbname);
$query = file_get_contents("php://input");
if ($conn->connect_error) {
header("HTTP/1.1 500 Internal Server Error");
echo $query.'\n';
echo mysqli_error();
}
else
{
if (isset($_GET["select"]) AND strpos($query,"SELECT ") >-1)
{
$result = $conn->query($query);
$rows = array();
while($r = $result->fetch_assoc()) {
$rows[] = $r;
}
print json_encode($rows);
}
elseif (isset($_GET["insert"]) AND strpos($query,"INSERT ") >-1)
{
$result = $conn->query($query);
print $conn->insert_id;
}
elseif (strpos($query,"DELETE ") >-1 OR (strpos($query,"UPDATE ") >-1))
{
if (strpos($query," WHERE ") >-1 AND (strpos($query,"=") >-1 ))
{
//". LIMIT 1" bewirkt das maximal 1 Datensatz gelöscht oder geändert werden kann.
$result = $conn->query($query . " LIMIT 1");
print $conn->affected_rows;
}
else
{
print "sql-command is wrong";
}
}
else
{
print "sql-command not found";
}
}
?>