-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathcreate_db.php
69 lines (63 loc) · 2.02 KB
/
create_db.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
<html>
<?php
//$db_user="root";//userName
//$db_pass="usbw";//password
//$db_serv="localhost:3307";//hostName
//$db_name="komax";//dbName
//$mysqli= new mysqli($db_serv, $db_user, $db_pass, $db_name);
//$mysqli->set_charset("utf8");
include('connect.php');
if (mysqli_connect_errno()){
printf("Impossible connect to database, error N ", mysqli_connect_error());
exit;
}
echo("connect". "<p>");
$sql = "CREATE TABLE IF NOT EXISTS `komax` (
`ID` int(11) NOT NULL,
`nomer` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`misce` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`cycle` int(11) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Дата',
PRIMARY KEY ( `id` )
)";
$sql1 = "ALTER TABLE `komax` ADD UNIQUE KEY `ID` (`ID`);";
$sql2 = "ALTER TABLE `komax` MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;";
if ($mysqli->query($sql) === TRUE) {
echo "Table created successfully" . "<br>";
if ($mysqli->query($sql1) === TRUE){
if ($mysqli->query($sql2) === TRUE){
$sql = "CREATE TABLE IF NOT EXISTS `komaxupd` (
`ID` int(11) NOT NULL,
`nomer` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`misce` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`cycle` int(11) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Дата',
PRIMARY KEY ( `id` )
)";
$sql1 = "ALTER TABLE `komaxupd` ADD UNIQUE KEY `ID` (`ID`);";
$sql2 = "ALTER TABLE `komaxupd` MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;";
$mysqli->query($sql);
$mysqli->query($sql1);
$mysqli->query($sql2);
echo "Table modifice successfully"."<br>";
}
else {
echo "Error creating table: " . $mysqli->error;
}
}
else {
echo "Error creating table: " . $mysqli->error;
}
} else {
echo "Error creating table: " . $mysqli->error;
}
?>
<form action="" method="POST">
<input type="submit" name="Btn" value="OK"/>
</form>
<?php
if (isset($_POST['Btn']))
header('Location: adminka.php');
exit;
?>
</html>