Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
- </head>
- <body>
- <?php
- $host="localhost"; $username="root"; $password="";
- // Connect to MySQL server (without selecting DB)
- $conn = new mysqli($host, $username, $password);
- // Check connection
- if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error."!"); }
- echo "Connected successfully!<br>";
- // set UTF8 character set encoding for this connection
- $conn->set_charset('utf8');
- // for testing purpose - drop the DB to recreate it again if exists - be careful with this!!!
- // това не бива да го има в реален код – опасно е, защото изтрива цялата база
- $sql = "DROP DATABASE IF EXISTS test";
- $conn->query($sql);
- // Create database test with collation UTF8 cyrillic – не забравяйте за collation, ако ползвате кирилица
- $sql = "CREATE DATABASE test COLLATE utf8_general_ci";
- if ($conn->query($sql) === TRUE) { echo "Database created successfully!<br>"; }
- else { die("Error creating database: " . $conn->error); }
- // Use database test
- $sql = "USE test";
- if ($conn->query($sql) === TRUE) {echo "Database selected successfully!<br>"; }
- else { die("Error selecting database: " . $conn->error."!"); }
- // Create table Persons
- $sql = "CREATE TABLE Persons (
- id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
- name VARCHAR(40) NOT NULL,
- family VARCHAR(40) NOT NULL,
- job VARCHAR(30),
- salary FLOAT)";
- if ($conn->query($sql) === TRUE) { echo "Table Persons created successfully!<br>"; }
- else { die("Error creating table: " . $conn->error."!"); }
- // Insert into db test 5 records
- $sql = "INSERT INTO Persons (name, family, job, salary)
- VALUES ('Иван', 'Петров', 'снабдител', 1200.00)";
- if ($conn->query($sql) === TRUE) { echo "New record Иван Петров created successfully!<br>"; }
- else { die("Error: " . $sql . $conn->error); }
- $sql = "INSERT INTO Persons (name, family, job, salary)
- VALUES ('Петър', 'Слабаков', 'разработчик', 3200.00)";
- if ($conn->query($sql) === TRUE) { echo "New record Петър Слабаков created successfully!<br>"; }
- else { die("Error: " . $sql . $conn->error); }
- $sql = "INSERT INTO Persons (name, family, job, salary)
- VALUES ('Анелия', 'Драганова', 'разработчик', 2200.00)";
- if ($conn->query($sql) === TRUE) { echo "New record Анелия Драганова created successfully!<br>"; }
- else { die("Error: " . $sql . $conn->error); }
- $sql = "INSERT INTO Persons (name, family, job, salary)
- VALUES ('Делчо', 'Атанасов', 'шеф', 5000.00)";
- if ($conn->query($sql) === TRUE) { echo "New record Делчо Атанасов created successfully!<br>"; }
- else { die("Error: " . $sql . $conn->error); }
- $sql = "INSERT INTO Persons (name, family, job, salary)
- VALUES ('Пенка', 'Алексиева', 'чистачка', 500.00)";
- if ($conn->query($sql) === TRUE) { echo "New record Пенка Алексиева created successfully!<br>"; }
- else { die("Error: " . $sql . $conn->error); }
- // Select all records
- echo "<br>Всички записи са:<br>";
- $sql = "SELECT * FROM Persons";
- $result = $conn->query($sql);
- if ($result->num_rows > 0) {
- // output data of each row
- while($row = $result->fetch_assoc()) {
- echo $row["id"].": ".$row["name"]." ".$row["family"]." - ".$row["job"].", ". $row["salary"]."
- лв.<br>";
- }
- } else { echo "No results...<br>"; }
- // Select само разработчиците
- echo "<br>Разработчици са:<br>";
- $sql = "SELECT * FROM Persons WHERE job = 'разработчик'";
- $result = $conn->query($sql);
- if ($result->num_rows > 0) {
- // output data of each row
- while($row = $result->fetch_assoc()) {
- echo $row["id"].": ".$row["name"]." ".$row["family"]." - ".$row["job"].", ". $row["salary"]."
- лв.<br>";
- }
- } else { echo "No results...<br>"; }
- // Select само заплата между 1000 и 3000 лв
- echo "<br>Със заплата между 1000 и 3000 лв са:<br>";
- $sql = "SELECT * FROM Persons WHERE salary BETWEEN 1000 AND 3000";
- $result = $conn->query($sql);
- if ($result->num_rows > 0) {
- // output data of each row
- while($row = $result->fetch_assoc()) {
- echo $row["id"].": ".$row["name"]." ".$row["family"]." - ".$row["job"].", ". $row["salary"]."
- лв.<br>";
- }
- } else { echo "No results...<br>"; }
- $conn->close();
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement