Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- // dann mal daten aus dem Installformular bearbeiten
- $username = $_POST['username'];
- $password = $_POST['password'];
- $dbname = $_POST['dbname'];
- $forname = $_POST['forname'];
- $surname = $_POST['surname'];
- $mysqladmin = $_POST['mysqladmin'];
- $mysqlpassword = $_POST['mysqlpassword'];
- //Zustandsvariable für Scriptabbruch bei Fehlermeldungen
- $noerror = null;
- //Inhalt der MySql.php
- $content ="
- <?php
- mysql_connect('localhost', '$mysqladmin', '$mysqlpassword') or die (mysql_error());
- mysql_select_db('$dbname')or die (mysql_error());
- ?>';
- ";
- // Verbindung zu MySQl Herstellen
- $connect = mysql_connect('localhost' , $mysqladmin , $mysqlpassword);
- if(!$connect)
- {
- $error = mysql_error();
- }
- //Stmt ausführen
- $query = mysql_query($stmt);
- $stmt ='CREATE DATABASE IF NOT EXISTS `'.$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);
- 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';
- }
- //Die mysql.php Datei anlegen
- if($noerror)
- {
- $file = fopen ('mysql.php' , 'w');
- fwrite( $file , $content);
- }
- else {
- $error = 'Das erstellen der mysql.php hat nicht funktioniert.' ;}
- ?>
- <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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement