· 4 years ago · May 22, 2021, 07:16 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 $conn = new mysqli($host, $username, $password);
16
17 if ($conn->connect_error) {
18 die("Connection failed: " . $conn->connect_error . "!");
19 }
20 echo "Connected successfully!<br>";
21
22 $conn->set_charset('utf8');
23
24 $sql = "DROP DATABASE IF EXISTS myDB";
25 $conn->query($sql);
26
27 $sql = "CREATE DATABASE myDB COLLATE utf8_general_ci";
28 if ($conn->query($sql) === TRUE) {
29 echo "Database created successfully!<br>";
30 } else {
31 die("Error creating database: " . $conn->error);
32 }
33
34 $sql = "USE myDB";
35 if ($conn->query($sql) === TRUE) {
36 echo "Database selected successfully!<br>";
37 } else {
38 die("Error selecting database: " . $conn->error . "!");
39 }
40
41 $sql = "CREATE TABLE student (
42 id INT(9) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
43 facnumber INT(10) NOT NULL,
44 firstname VARCHAR(30) NOT NULL,
45 lastname VARCHAR(30) NOT NULL,
46 gender VARCHAR(5) NOT NULL,
47 city VARCHAR(20) NOT NULL
48 )";
49
50 if ($conn->query($sql) === TRUE) {
51 echo "Table student created successfully!<br>";
52 } else {
53 die("Error creating table: " . $conn->error . "!");
54 }
55
56 //Insert
57 $sql = "INSERT INTO student (facnumber,firstname, lastname, gender,city)
58 VALUES ('1901682042','Стоян','Костов','мъж','Асеновград')";
59 $sql = "INSERT INTO student (facnumber,firstname, lastname, gender,city)
60 VALUES ('1901562303','Иван','Петров','мъж','София')";
61 $sql = "INSERT INTO student (facnumber,firstname, lastname, gender,city)
62 VALUES ('1901682042','Десислава','Иванова','жена','Варна')";
63 $sql = "INSERT INTO student (facnumber,firstname, lastname, gender,city)
64 VALUES ('1901682042','Стоян','Костов','мъж','Асеновград')";
65 $sql = "INSERT INTO student (facnumber,firstname, lastname, gender,city)
66 VALUES ('1901682042','Стоян','Костов','мъж','Асеновград')";
67 $sql = "INSERT INTO student (facnumber,firstname, lastname, gender,city)
68 VALUES ('1901682042','Стоян','Костов','мъж','Асеновград')";
69 $sql = "INSERT INTO student (facnumber,firstname, lastname, gender,city)
70 VALUES ('1901682042','Стоян','Костов','мъж','Асеновград')";
71 $sql = "INSERT INTO student (facnumber,firstname, lastname, gender,city)
72 VALUES ('1901682042','Стоян','Костов','мъж','Асеновград')";
73 $sql = "INSERT INTO student (facnumber,firstname, lastname, gender,city)
74 VALUES ('1901682042','асд','Костов','мъж','Асеновград')";
75
76 if ($conn->query($sql) === TRUE) {
77 echo "New record created successfully";
78 } else {
79 echo "Error: " . $sql . "<br>" . $conn->error;
80 }
81 //log
82 // "<h1>" . $row["id"] . $row["name"]. "</h1>"
83
84 echo "<br>Всички записи са:<br>";
85 $sql = "SELECT * FROM student";
86 $result = $conn->query($sql);
87 if ($result->num_rows > 0) {
88 while ($row = $result->fetch_assoc()) {
89 echo $row["id"] . ": " . $row["facnumber"] . " " . $row["firstname"] . " - " . $row["lastname"] . ", " . $row["gender"] ."," . $row["city"] ."<br>";
90 }
91 } else {
92 echo "No results...<br>";
93 }
94
95 ?>
96</body>
97
98</html>