· 9 years ago · Sep 17, 2017, 02:28 AM
1<?php
2// dann mal daten aus dem Installformular bearbeiten
3
4$username = $_POST['username'];
5$password = $_POST['password'];
6$dbname = $_POST['dbname'];
7$forname = $_POST['forname'];
8$surname = $_POST['surname'];
9$mysqladmin = $_POST['mysqladmin'];
10$mysqlpassword = $_POST['mysqlpassword'];
11
12//Zustandsvariable für Scriptabbruch bei Fehlermeldungen
13$noerror = null;
14
15//Inhalt der MySql.php
16$content ="
17<?php
18mysql_connect(\'localhost\', '.$mysqladmin.', '.$mysqlpassword.') or die (mysql_error());
19mysql_select_db('.$dbname.')or die (mysql_error());
20?>';
21";
22
23// Verbindung zu MySQl Herstellen
24$connect = mysql_connect('localhost' , 'root' , 'test123');
25
26if(!$connect)
27{
28 $error = mysql_error();
29}
30
31// Datenbank anlegen
32
33$stmt ='DROP DATABASE IF EXISTS `'.$dbname.'`;';
34//Stmt ausführen
35$query = mysql_query($stmt);
36
37$stmt ='CREATE DATABASE IF NOT EXISTS `'.$dbname.'` DEFAULT CHARACTER SET latin1 COLLATE latin1_german1_ci;';
38
39// Stmt überprüfen
40$sql = mysql_query($stmt);
41if(!$sql){
42 $error = mysql_error();
43}
44else {
45 $noerror = '1';
46}
47
48$db = mysql_select_db($dbname);
49
50if(!$db) {
51 $error = mysql_error();
52} else {
53 $noerror = 1;
54}
55
56//Tabelle tblincidents anlegen
57
58$stmt ='
59 CREATE TABLE IF NOT EXISTS `tblincidents` (
60 `ID` int(11) NOT NULL AUTO_INCREMENT,
61 `userID` int(11) NOT NULL,
62 `headline` text COLLATE latin1_german1_ci NOT NULL,
63 `message` text COLLATE latin1_german1_ci NOT NULL,
64 `created` int(11) NOT NULL,
65 `modified` int(11) NOT NULL,
66 `status` enum(\'Critical\',\'Information\',\'Fixed\') COLLATE latin1_german1_ci NOT NULL,
67 PRIMARY KEY (`ID`)
68 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci ;
69';
70// Stmt ausführe und überprüfen
71$sql = mysql_query($stmt);
72if(!$sql){
73 $error = mysql_error();
74}
75else {
76 $noerror = '1';
77}
78
79
80$stmt ='
81 CREATE TABLE IF NOT EXISTS `tblusers` (
82 `ID` int(11) NOT NULL AUTO_INCREMENT,
83 `username` text CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,
84 `firstName` text CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,
85 `lastName` text CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,
86 `password` text CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,
87 PRIMARY KEY (`ID`)
88 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ;
89';
90// Stmt ausführe und überprüfen
91$sql = mysql_query($stmt);
92if(!$sql){
93 $error = mysql_error();
94}
95else {
96 $noerror = '1';
97}
98
99
100$stmt =' INSERT INTO `tblusers` (`username`, `firstName`, `lastName`, `password`) VALUES
101 ('.$username.', '.$forname.', '.$surname.', '.$password.');
102 ' ;
103
104// Stmt ausführe und überprüfen
105$sql = mysql_query($stmt);
106if(!$sql){
107 $error = mysql_error();
108}
109else {
110 $noerror = '1';
111}
112
113//Die mysql.php Datei anlegen
114if($noerror)
115{
116 $file = fopen ('mysql.php' , 'w');
117 fwrite( $file , $content);
118 }
119else {
120 $error = 'Das erstellen der mysql.php hat nicht funktioniert.' ;}
121
122?>
123
124<html>
125<head>
126<link rel="stylesheet" type="text/css" href="../CSS/style.css" />
127</head>
128<body>
129 <div id="headerContainer">
130 <div class="image">
131 <img height="100px" src="../images/logo.png" alt="Logo" /></a>
132 </div>
133 <div class="label">
134 <a href="../index.php">Klicken Sie hier zur Startseite</a>
135 </div>
136 </div>
137 <div id="installform">
138 <div id= "installtable">
139 <?php
140 if($noerror)
141 {
142 print('<span> Datenbank angelegt </span>') ; }
143 else {
144 print('<span> Anlegen der Datenbank fehlgeschlagen: '.$error.' </span>') ;}
145
146 ?>
147 </div>
148 </div>
149</body>
150</html>