iUBLF5he

1<?php
2$servername = "localhost";
3$username = "root";
4$password = "";
5$dbname = "resume";
6
7// Create connection
8$conn = mysqli_connect($servername, $username, $password, $dbname);
9// Check connection
10if (!$conn) {
11    die("Connection failed: " . mysqli_connect_error());
12}
13
14// sql to create table
15$sql_db = "CREATE DATABASE IF NOT EXISTS resume collate utf8mb4_unicode_ci";
16
17// sql to create table
18$sql_tbl_extra_curricula = "CREATE TABLE extra_curricular_activities (
19id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
20year VARCHAR(30) NOT NULL,
21activity VARCHAR(255) NOT NULL
22)";
23
24
25$sql_tbl_hobbies = "CREATE TABLE hobbies (
26    id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
27    hobby VARCHAR(30) NOT NULL
28    )";
29  
30$sql_tbl_language = "CREATE TABLE languages (
31    id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
32    language VARCHAR(105) NOT NULL,
33    level VARCHAR(105) NOT NULL
34    )";
35    
36$sql_tbl_expertise = "CREATE TABLE expertise (
37        id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
38        title VARCHAR(105) NOT NULL,
39        level INT(10) NOT NULL,
40        years_of_experience INT(10) NOT NULL 
41        )";      
42
43$sql_tbl_certifications = "CREATE TABLE certifications (
44    id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
45    title VARCHAR(105) NOT NULL,
46    year VARCHAR(105) NOT NULL
47    )";      
48
49
50
51if (mysqli_query($conn, $sql_tbl_language)) {
52    echo "Table  created successfully";
53} else {
54    echo "Error creating table: " . mysqli_error($conn);
55}
56
57mysqli_close($conn);
58?>