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