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