<?php
require_once "NTK/NTK.php";
require_once "DataBase/database.php";
$db = new Database();
$db->connectToDb();
?>
<html>
<head>
<title> Index </title>
<body>
<?php
while (true) {
if (!($result = mysql_query("SELECT bill_ext FROM " . $db->assistant_table . ""))) {
if (!($result2 = mysql_query("ALTER TABLE " . $db->assistant_table . " ADD bill_ext VARCHAR( 64 ) NOT NULL"))) {
echo "Fehler: " . mysql_error();
break;
} else {
echo "Tabelle 'Mitarbeiter' erneuert<br>";
}
}
if (!($result = mysql_query("SELECT anmerkung FROM " . $db->product_table . ""))) {
if (!($result2 = mysql_query("ALTER TABLE " . $db->product_table . " ADD anmerkung VARCHAR( 64 ) NOT NULL"))) {
echo "Fehler: " . mysql_error();
break;
} else {
echo "Tabelle 'Produkte' erneuert<br>";
}
