<?php
$verbindung=mysqli_connect('10.163.55.221','omvkodi','mypass','kodivideo',3306);
$query1=mysqli_query($verbindung,'
CREATE TABLE test1 (
test1_id INT AUTO_INCREMENT PRIMARY KEY,
Name VARCHAR(50) NOT NULL
)
');
$query2=mysqli_query($verbindung,'
INSERT INTO test1 (Name)
VALUES ("Harald");
');
$query3=mysqli_query($verbindung,'
SELECT * FROM test1;
');
if (is_object($query3))
{
	echo '
	<html><head><title>SQL Ergebnis</title></head>
	<body>Namensliste<br/>
	<table border="1">
	';
	while ($zeile = mysqli_fetch_array($query3))
	{
		echo '<tr><td>'.$zeile[0].'</td>';
		echo '<td>'.$zeile[1].'</td></tr>';
	}
	echo '
	</table>
	</html>
	';
}
$query4=mysqli_query($verbindung,'
DROP TABLE test1;
');
?>