01KVvKe1

1<?php
2//Create Data base if not exists
3	$servername = "localhost";
4	$username = "root";
5	$password = "";
6
7	// Create connection
8	$conn = new mysqli($servername, $username, $password);
9	// Check connection
10	if ($conn->connect_error) {
11	    die("Connection failed: " . $conn->connect_error);
12	}
13
14	// Create database
15	$sql = "CREATE DATABASE espdemo";
16	if ($conn->query($sql) === TRUE) {
17	    echo "Database created successfully";
18	} else {
19	    echo "Error creating database: " . $conn->error;
20	}
21
22	$conn->close();
23
24	echo "<br>";
25//Connect to database and create table
26	$servername = "localhost";
27	$username = "root";
28	$password = "";
29	$dbname = "espdemo";
30
31	// Create connection
32	$conn = new mysqli($servername, $username, $password, $dbname);
33	// Check connection
34	if ($conn->connect_error) {
35	    die("Connection failed: " . $conn->connect_error);
36	}
37
38	
39	// sql to create table
40	$sql = "CREATE TABLE logs (
41	id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
42	station VARCHAR(30),
43	status VARCHAR(30),
44	remark VARCHAR(50),
45	`Date` DATE NULL,
46	`Time` TIME NULL, 
47	`TimeStamp` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
48	)";
49
50	if ($conn->query($sql) === TRUE) {
51	    echo "Table logs created successfully";
52	} else {
53	    echo "Error creating table: " . $conn->error;
54	}
55
56	$conn->close();
57?>