· 8 years ago · Jun 03, 2018, 09:20 AM
1<?php
2 //Config
3 $servername = "localhost";
4 $username = "root";
5 $password = "";
6 //End config
7
8 if (isset ($_POST['ok'])) {
9 // Create connection
10 $conn = new mysqli($servername, $username, $password);
11
12 // Check connection
13 if ($conn->connect_error) {
14 die("Connection failed: " . $conn->connect_error);
15 }
16
17 // Create database
18 $sql =
19 "
20 CREATE DATABASE IF NOT EXISTS sitedb CHARACTER SET utf8 COLLATE utf8_hungarian_ci;
21
22 CREATE TABLE users (
23 `id` int(11) NOT NULL,
24 `user` varchar(50) COLLATE utf8_hungarian_ci NOT NULL,
25 `pass` varchar(50) COLLATE utf8_hungarian_ci NOT NULL,
26 `email` varchar(50) COLLATE utf8_hungarian_ci NOT NULL,
27 `rights` int(11) DEFAULT NULL
28 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
29 ";
30 if ($conn->query($sql) === TRUE) {
31 echo "Database created successfully!";
32 } else {
33 echo "Error creating database: " . $conn->error;
34 }
35
36 $conn->close();
37 }
38?>
39
40<!DOCTYPE html>
41<html>
42 <head>
43 <meta charset="UTF-8">
44 <title>Setup</title>
45 </head>
46
47 <body>
48 <p>
49 <?php
50 echo "<b>Current connection settings: </b><br>";
51 echo "<b>host:</b> ";
52 echo $servername;
53 echo "<br>";
54
55 echo "<b>username:</b> ";
56 echo $username;
57 echo "<br>";
58
59 echo "<b>password:</b> ";
60 echo $password;
61 echo "<br>";
62 ?>
63 </p>
64 <form method="POST" action="setup.php">
65 <input type="submit" name="ok" value="Install" >
66 </form>
67 </body>
68
69</html>