· 9 years ago · May 10, 2017, 12:42 PM
1
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$conn = new mysqli($host, $username, $password);
10if (!$conn) { die("Connection failed: " . $conn->connect_error."!"); }
11else{
12echo "Connected successfully!<br>";
13}
14$conn->set_charset('utf8');
15$sql = "DROP DATABASE IF EXISTS Exam";
16$conn->query($sql);
17$sql = "CREATE DATABASE Exam COLLATE utf8_general_ci";
18if ($conn->query($sql) === TRUE) { echo "Database created successfully!<br>"; }
19else { die("Error creating database: " . $conn->error); }
20$sql = "USE Exam";
21if ($conn->query($sql) === TRUE) {echo "Database selected successfully!<br>"; }
22else { die("Error selecting database: " . $conn->error."!"); }
23$sql = "CREATE TABLE Students (
24id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
25FNumber VARCHAR(40) NOT NULL,
26FName VARCHAR(40) NOT NULL,
27Family VARCHAR(40) NOT NULL,
28Ocenka FLOAT)";
29
30if ($conn->query($sql) === TRUE) { echo "Table Students created successfully!<br>"; }
31else { die("Error creating table: " . $conn->error."!"); }
32// Insert into db test 5 records
33$sql = "INSERT INTO Students (FNumber, FName, Family, Ocenka)
34VALUES ('1501681032', 'Svetoslav','Ivanov',6.00)";
35if ($conn->query($sql) === TRUE) { echo "New record Svetoslav Ivanov created successfully!<br>"; }
36else { die("Error: " . $sql . $conn->error); }
37$sql = "INSERT INTO Students (FNumber, FName, Family, Ocenka)
38VALUES ('1501681032', 'Pesho','Pesho',3.00)";
39if ($conn->query($sql) === TRUE) { echo "New record Pesho Pesho created successfully!<br>"; }
40else { die("Error: " . $sql . $conn->error); }
41$sql = "INSERT INTO Students (FNumber, FName, Family, Ocenka)
42VALUES ('1501681032', 'Rado','Rado',4.00)";
43if ($conn->query($sql) === TRUE) { echo "New record Rado Rado created successfully!<br>"; }
44else { die("Error: " . $sql . $conn->error); }
45$sql = "INSERT INTO Students (FNumber, FName, Family, Ocenka)
46VALUES ('1501681032', 'Svetlin','Nakov',5.00)";
47if ($conn->query($sql) === TRUE) { echo "New record Svetlin Nakov created successfully!<br>"; }
48else { die("Error: " . $sql . $conn->error); }
49$sql = "INSERT INTO Students (FNumber, FName, Family, Ocenka)
50VALUES ('1501681032', 'Petar','Petrov',6.00)";
51if ($conn->query($sql) === TRUE) { echo "New record Petar Petrov created successfully!<br>"; }
52else { die("Error: " . $sql . $conn->error); }
53// Select all records
54echo "<br>Ð’Ñички запиÑи Ñа:<br>";
55$sql = "SELECT * FROM Students";
56$result = $conn->query($sql);
57if ($result->num_rows > 0) {
58 // output data of each row
59 while($row = $result->fetch_assoc()) {
60echo $row["id"].": ".$row["FNumber"]." ".$row["FName"]." ".$row["Family"]." - ".$row["Ocenka"]."
61лв.<br>";
62}
63} else { echo "No results...<br>"; }
64// Select samo programisti
65echo "<br>Разработчици Ñа:<br>";
66$sql = "SELECT * FROM Students WHERE FName = 'Petar'";
67$result = $conn->query($sql);
68if ($result->num_rows > 0) {
69 // output data of each row
70 while($row = $result->fetch_assoc()) {
71echo $row["id"].": ".$row["FNumber"]." ".$row["FName"]." ".$row["Family"]." - ".$row["Ocenka"]."
72лв.<br>";
73}
74} else { echo "No results...<br>"; }
75// S ocenka mejdu 2 i 6
76echo "<br>S ocenka mejdu:<br>";
77$sql = "SELECT * FROM Students WHERE Ocenka BETWEEN 2.00 AND 4.00";
78$result = $conn->query($sql);
79if ($result->num_rows > 0) {
80 // output data of each row
81 while($row = $result->fetch_assoc()) {
82echo $row["id"].": ".$row["FNumber"]." ".$row["FName"]." ".$row["Family"]." - ".$row["Ocenka"]."
83лв.<br>";
84}
85} else { echo "No results...<br>"; }
86$conn->close();
87?>
88</body>
89</html>