HgA8HJTV

1<?php
2
3// database connection
4
5$servername = "localhost";
6$username = "root";
7$password = "";
8$conn = new mysqli($servername, $username, $password);
9if ($conn->connect_error) {
10    die("Connection failed:" . $conn->connect_error);
11} 
12
13/***************************************************/
14//Create database for members
15
16$sql = "CREATE DATABASE IF NOT EXISTS members";
17if ($conn->query($sql) === TRUE) {
18    echo "Database members created successfully";
19} else {
20    echo "Error creating database members:" . $conn->error;
21}
22
23// make bopp the current db
24$dbname = "members";
25$conn = new mysqli($servername, $username, $password, $dbname);
26// Check connection
27if ($conn->connect_error) {
28    die("Connection failed:" . $conn->connect_error);
29} 
30// create empolyee table
31$sql = "CREATE TABLE IF NOT EXISTS empolyees (
32
33id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, 
34badge_num VARCHAR(30),
35fullname VARCHAR(30) ,
36firstname VARCHAR(30) NOT NULL,
37lastname VARCHAR(30) NOT NULL,
38gender VARCHAR(30) NOT NULL,
39birth_date VARCHAR(30) NOT NULL,
40department VARCHAR(30) NOT NULL,
41position VARCHAR(30),
42epc VARCHAR(30) NOT NULL,
43Image longblob,
44regist_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP
45)";
46
47if ($conn->query($sql) === TRUE) {
48    echo "Table empolyee created successfully";
49} else {
50    echo "Error creating table bopp:" . $conn->error;
51}
52
53/***************************************************/
54// ended connection
55/***************************************************/
56
57?>