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