· 9 years ago · May 10, 2017, 10:38 AM
1<!DOCTYPE html>
2<html>
3 <head>
4 <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
5 </head>
6<body>
7<?php
8$host="localhost"; $username="root"; $password="";
9// Connect to MySQL server (without selecting DB)
10$conn = new mysqli($host, $username, $password);
11// Check connection
12if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error."!"); }
13echo "Connected successfully!<br>";
14// set UTF8 character set encoding for this connection
15$conn->set_charset('utf8');
16// for testing purpose - drop the DB to recreate it again if exists - be careful with this!!!
17// това не бива да го има в реален код – опаÑно е, защото изтрива цÑлата база
18$sql = "DROP DATABASE IF EXISTS test";
19$conn->query($sql);
20// Create database test with collation UTF8 cyrillic – не забравÑйте за collation, ако ползвате кирилица
21$sql = "CREATE DATABASE test COLLATE utf8_general_ci";
22if ($conn->query($sql) === TRUE) { echo "Database created successfully!<br>"; }
23else { die("Error creating database: " . $conn->error); }
24// Use database test
25$sql = "USE test";
26if ($conn->query($sql) === TRUE) {echo "Database selected successfully!<br>"; }
27else { die("Error selecting database: " . $conn->error."!"); }
28// Create table Persons
29$sql = "CREATE TABLE Persons (
30id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
31name VARCHAR(40) NOT NULL,
32family VARCHAR(40) NOT NULL,
33job VARCHAR(30),
34salary FLOAT)";
35if ($conn->query($sql) === TRUE) { echo "Table Persons created successfully!<br>"; }
36else { die("Error creating table: " . $conn->error."!"); }
37// Insert into db test 5 records
38$sql = "INSERT INTO Persons (name, family, job, salary)
39VALUES ('Иван', 'Петров', 'Ñнабдител', 1200.00)";
40if ($conn->query($sql) === TRUE) { echo "New record Иван Петров created successfully!<br>"; }
41else { die("Error: " . $sql . $conn->error); }
42$sql = "INSERT INTO Persons (name, family, job, salary)
43VALUES ('Петър', 'Слабаков', 'разработчик', 3200.00)";
44if ($conn->query($sql) === TRUE) { echo "New record Петър Слабаков created successfully!<br>"; }
45else { die("Error: " . $sql . $conn->error); }
46$sql = "INSERT INTO Persons (name, family, job, salary)
47VALUES ('ÐнелиÑ', 'Драганова', 'разработчик', 2200.00)";
48if ($conn->query($sql) === TRUE) { echo "New record ÐÐ½ÐµÐ»Ð¸Ñ Ð”Ñ€Ð°Ð³Ð°Ð½Ð¾Ð²Ð° created successfully!<br>"; }
49else { die("Error: " . $sql . $conn->error); }
50$sql = "INSERT INTO Persons (name, family, job, salary)
51VALUES ('Делчо', 'ÐтанаÑов', 'шеф', 5000.00)";
52if ($conn->query($sql) === TRUE) { echo "New record Делчо ÐтанаÑов created successfully!<br>"; }
53else { die("Error: " . $sql . $conn->error); }
54$sql = "INSERT INTO Persons (name, family, job, salary)
55VALUES ('Пенка', 'ÐлекÑиева', 'чиÑтачка', 500.00)";
56if ($conn->query($sql) === TRUE) { echo "New record Пенка ÐлекÑиева created successfully!<br>"; }
57else { die("Error: " . $sql . $conn->error); }
58// Select all records
59echo "<br>Ð’Ñички запиÑи Ñа:<br>";
60$sql = "SELECT * FROM Persons";
61$result = $conn->query($sql);
62if ($result->num_rows > 0) {
63 // output data of each row
64 while($row = $result->fetch_assoc()) {
65echo $row["id"].": ".$row["name"]." ".$row["family"]." - ".$row["job"].", ". $row["salary"]."
66лв.<br>";
67}
68} else { echo "No results...<br>"; }
69// Select Ñамо разработчиците
70echo "<br>Разработчици Ñа:<br>";
71$sql = "SELECT * FROM Persons WHERE job = 'разработчик'";
72$result = $conn->query($sql);
73if ($result->num_rows > 0) {
74 // output data of each row
75 while($row = $result->fetch_assoc()) {
76echo $row["id"].": ".$row["name"]." ".$row["family"]." - ".$row["job"].", ". $row["salary"]."
77лв.<br>";
78}
79} else { echo "No results...<br>"; }
80// Select Ñамо заплата между 1000 и 3000 лв
81echo "<br>Ð¡ÑŠÑ Ð·Ð°Ð¿Ð»Ð°Ñ‚Ð° между 1000 и 3000 лв Ñа:<br>";
82$sql = "SELECT * FROM Persons WHERE salary BETWEEN 1000 AND 3000";
83$result = $conn->query($sql);
84if ($result->num_rows > 0) {
85 // output data of each row
86 while($row = $result->fetch_assoc()) {
87echo $row["id"].": ".$row["name"]." ".$row["family"]." - ".$row["job"].", ". $row["salary"]."
88лв.<br>";
89}
90} else { echo "No results...<br>"; }
91$conn->close();
92?>
93</body>
94</html>