· 4 years ago · May 22, 2021, 07:06 AM
1<!DOCTYPE html>
2<html>
3
4<head>
5 <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
6</head>
7
8<body>
9
10 <?php
11 $host = "localhost";
12 $username = "root";
13 $password = "";
14
15 // Connect to MySQL server (without selecting DB)
16 $conn = new mysqli($host, $username, $password);
17
18 // Check connection
19 if ($conn->connect_error) {
20 die("Connection failed: " . $conn->connect_error . "!");
21 }
22 echo "Connected successfully!<br>";
23
24 // set UTF8 character set encoding for this connection
25 $conn->set_charset('utf8');
26
27 $sql = "DROP DATABASE IF EXISTS Students";
28 $conn->query($sql);
29
30 $sql = "CREATE DATABASE Students COLLATE utf8_general_ci";
31 if ($conn->query($sql) === TRUE) {
32 echo "Database created successfully!<br>";
33 } else {
34 die("Error creating database: " . $conn->error);
35 }
36
37 // Use database myDB
38 $sql = "USE Students";
39 if ($conn->query($sql) === TRUE) {
40 echo "Database selected successfully!<br>";
41 } else {
42 die("Error selecting database: " . $conn->error . "!");
43 }
44
45 // Create table Students
46 $sql = "CREATE TABLE Students (
47 id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
48 fnumber INT(11) NOT NULL,
49 fname VARCHAR(40) NOT NULL,
50 lname VARCHAR(40) NOT NULL,
51 gender VARCHAR(40) NOT NULL,
52 city VARCHAR(40) NOT NULL )";
53 if ($conn->query($sql) === TRUE) {
54 echo "Table Students created successfully!<br>";
55 } else {
56 die("Error creating table: " . $conn->error . "!");
57 }
58
59 // Create table Normativ
60 $sql = "CREATE TABLE Normativ (
61 id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
62 fnumber INT(11) NOT NULL,
63 fname VARCHAR(40) NOT NULL,
64 lname VARCHAR(40) NOT NULL,
65 normativ VARCHAR(40) NOT NULL )";
66 if ($conn->query($sql) === TRUE) {
67 echo "Table Normativ created successfully!<br>";
68 } else {
69 die("Error creating table: " . $conn->error . "!");
70 }
71
72 // Insert into db test 2 records
73 $sql = "INSERT INTO Students (fnumber, fname, lname, gender, city)
74VALUES ('1901682042', 'Иван', 'Петров', 'мъж', 'Асеновград')";
75 if ($conn->query($sql) === TRUE) {
76 echo "New record Иван Петров created successfully!<br>";
77 } else {
78 die("Error: " . $sql . $conn->error);
79 }
80
81 // Insert into db test 2 records
82 $sql = "INSERT INTO Normativ (fnumber, fname, lname, normativ)
83VALUES ('1901682042', 'Иван', 'Петров', '15 сек.')";
84 if ($conn->query($sql) === TRUE) {
85 echo "New record Норматив created successfully!<br>";
86 } else {
87 die("Error: " . $sql . $conn->error);
88 }
89
90 //"<h1>" . $row["id"] . $row["name"]. "</h1>" .
91
92 // Select
93 echo "<br>Всички записи са:<br>";
94 $sql = "SELECT * FROM Students";
95 $result = $conn->query($sql);
96 if ($result->num_rows > 0) {
97 while ($row = $result->fetch_assoc()) {
98 echo $row["id"] . ": " . $row["fname"] . " " . $row["lname"] . " - " . $row["gender"] . ", " . $row["city"];
99 }
100 } else {
101 echo "No results...<br>";
102 }
103
104// //update
105// $sql = "UPDATE Normativ SET name = 'тест',family = 'тестов',job = 'градинар',salary=999 WHERE id=1";
106// $query = mysqli_query($conn, $sql);
107// if ($conn->query($sql) === TRUE) {
108// echo "Data successfully updated";
109// } else {
110// die("Error: " . $sql . $conn->error);
111// }
112 //log
113 echo "<br>Всички записи са:<br>";
114 $sql = "SELECT * FROM Persons";
115 $result = $conn->query($sql);
116 if ($result->num_rows > 0) {
117 while ($row = $result->fetch_assoc()) {
118 echo $row["id"] . ": " . $row["name"] . " " . $row["family"] . " - " . $row["job"] . ", " . $row["salary"] . " лв.<br>";
119 }
120 } else {
121 echo "No results...<br>";
122 }
123
124 // mysqli_close($conn);
125 ?>
126</body>
127
128</html>