· 4 years ago · May 21, 2021, 07:00 PM
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 myDB";
28 $conn->query($sql);
29
30 $sql = "CREATE DATABASE myDB 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 myDB";
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 Persons
46 $sql = "CREATE TABLE Persons (
47 id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
48 name VARCHAR(40) NOT NULL,
49 family VARCHAR(40) NOT NULL,
50 job VARCHAR(30), salary FLOAT)";
51 if ($conn->query($sql) === TRUE) {
52 echo "Table Persons created successfully!<br>";
53 } else {
54 die("Error creating table: " . $conn->error . "!");
55 }
56
57 // Insert into db test 2 records
58 $sql = "INSERT INTO Persons (name, family, job, salary)
59VALUES ('Иван', 'Петров', 'снабдител', 1200.00)";
60 if ($conn->query($sql) === TRUE) {
61 echo "New record Иван Петров created successfully!<br>";
62 } else {
63 die("Error: " . $sql . $conn->error);
64 }
65
66 $sql = "INSERT INTO Persons (name, family, job, salary)
67VALUES ('Петър', 'Слабаков', 'разработчик', 3200.00)";
68 if ($conn->query($sql) === TRUE) {
69 echo "New record Петър Слабаков created successfully!<br>";
70 } else {
71 die("Error: " . $sql . $conn->error);
72 }
73
74 //"<h1>" . $row["id"] . $row["name"]. "</h1>" .
75
76 // Select
77 echo "<br>Всички записи са:<br>";
78 $sql = "SELECT * FROM Persons";
79 $result = $conn->query($sql);
80 if ($result->num_rows > 0) {
81 while ($row = $result->fetch_assoc()) {
82 echo $row["id"] . ": " . $row["name"] . " " . $row["family"] . " - " . $row["job"] . ", " . $row["salary"] . " лв.<br>";
83 }
84 } else {
85 echo "No results...<br>";
86 }
87
88 //update
89 $sql = "UPDATE Persons SET name = 'тест',family = 'тестов',job = 'градинар',salary=999 WHERE id=1";
90 $query = mysqli_query($conn, $sql);
91 if ($conn->query($sql) === TRUE) {
92 echo "Data successfully updated";
93 } else {
94 die("Error: " . $sql . $conn->error);
95 }
96 //log
97 echo "<br>Всички записи са:<br>";
98 $sql = "SELECT * FROM Persons";
99 $result = $conn->query($sql);
100 if ($result->num_rows > 0) {
101 while ($row = $result->fetch_assoc()) {
102 echo $row["id"] . ": " . $row["name"] . " " . $row["family"] . " - " . $row["job"] . ", " . $row["salary"] . " лв.<br>";
103 }
104 } else {
105 echo "No results...<br>";
106 }
107 //delete
108 $sql = "DELETE FROM Persons WHERE id=1";
109
110 if ($conn->query($sql) === TRUE) {
111 echo "Record deleted successfully";
112 } else {
113 die("Error deleting record: " . $sql . $conn->error);
114 }
115 //log
116 echo "<br>Всички записи са:<br>";
117 $sql = "SELECT * FROM Persons";
118 $result = $conn->query($sql);
119 if ($result->num_rows > 0) {
120 while ($row = $result->fetch_assoc()) {
121 echo $row["id"] . ": " . $row["name"] . " " . $row["family"] . " - " . $row["job"] . ", " . $row["salary"] . " лв.<br>";
122 }
123 } else {
124 echo "No results...<br>";
125 }
126
127 // mysqli_close($conn);
128 ?>
129</body>
130
131</html>