Untitled

<?php
// dann mal daten aus dem Installformular bearbeiten

$username = $_POST['username'];
$password = $_POST['password'];
$dbname   = $_POST['dbname'];
$forname = $_POST['forname'];
$surname  = $_POST['surname'];

$noerror = null;

// Verbindung zu MySQl Herstellen
$connect = mysql_connect('localhost' , 'root' , 'test123');

if(!$connect)
{
 $error = mysql_error();
}


// Datenbank anlegen

$stmt ='DROP DATABASE IF EXISTS `'.$dbname.'`;';
//Stmt ausführen
$query = mysql_query($stmt);

$stmt ='CREATE DATABASE `'.$dbname.'` DEFAULT CHARACTER SET latin1 COLLATE latin1_german1_ci;';

// Stmt überprüfen
$sql = mysql_query($stmt);
if(!$sql){
         $error = mysql_error();
}
else {
         $noerror = '1';
}

$db = mysql_select_db($dbname);

if(!$db) {
	$error = mysql_error();
} else {
	$noerror = 1;
}

//Tabelle tblincidents anlegen

$stmt ='
      CREATE TABLE IF NOT EXISTS `tblincidents` (
      `ID` int(11) NOT NULL AUTO_INCREMENT,
      `userID` int(11) NOT NULL,
      `headline` text COLLATE latin1_german1_ci NOT NULL,
      `message` text COLLATE latin1_german1_ci NOT NULL,
      `created` int(11) NOT NULL,
      `modified` int(11) NOT NULL,
      `status` enum(\'Critical\',\'Information\',\'Fixed\') COLLATE latin1_german1_ci NOT NULL,
      PRIMARY KEY (`ID`)
      ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci ;
';
// Stmt ausführe und überprüfen
$sql = mysql_query($stmt);
if(!$sql){
         $error = mysql_error();
}
else {
         $noerror = '1';
}


$stmt ='
         CREATE TABLE IF NOT EXISTS `tblusers` (
         `ID` int(11) NOT NULL AUTO_INCREMENT,
         `username` text CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,
         `firstName` text CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,
         `lastName` text CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,
         `password` text CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,
         PRIMARY KEY (`ID`)
         ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 ;
';
// Stmt ausführe und überprüfen
$sql = mysql_query($stmt);
die($sql);
if(!$sql){
         $error = mysql_error();
}
else {
         $noerror = '1';
}


$stmt =' INSERT INTO `tblusers` (`username`, `firstName`, `lastName`, `password`) VALUES
         ('.$username.', '.$forname.', '.$surname.', '.$password.');
         ' ;

// Stmt ausführe und überprüfen
$sql = mysql_query($stmt);
if(!$sql){
         $error = mysql_error();
}
else {
         $noerror = '1';
}


?>

<html>
<head>
<link rel="stylesheet" type="text/css" href="../CSS/style.css"  />
</head>
<body>
  <div id="headerContainer">
       <div class="image">
           <img height="100px" src="../images/logo.png" alt="Logo" /></a>
       </div>
       <div class="label">
            <a href="../index.php">Klicken Sie hier zur Startseite</a>
       </div>
  </div>
  <div id="installform">
         <div id= "installtable">
         <?php
                 if($noerror)
                 {
                         print('<span> Datenbank angelegt </span>') ; }
                 else {
                         print('<span> Anlegen der Datenbank fehlgeschlagen: '.$error.' </span>') ;}

         ?>
    </div>
  </div>
</body>
</html>