0Jmcf0QX

1<?php
2echo "FOOD";
3
4$servername = "mysql";
5$username = "root";
6$password = "123";
7$dbname = "foodmanager";
8
9// checking connection
10$conn = new mysqli($servername, $username, $password);
11// Check connection
12if ($conn->connect_error) {
13    die("Connection failed: " . $conn->connect_error);
14}
15
16// sql query with CREATE DATABASE
17$sql = "CREATE DATABASE IF NOT EXISTS " . $dbname . " DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci";
18
19// Performs the $sql query on the server to create the database
20if ($conn->query($sql) === TRUE) {
21  echo 'Database ' . $dbname . ' successfully created' . "<br>";
22}
23else {
24 echo ' Error: '. $conn->error;
25}
26
27//$conn->close();
28
29/*echo "<pre>";
30echo "DB:";
31print_r ($conn);
32echo "</pre>";*/
33
34$sql = "SHOW DATABASES";
35$conn = new mysqli($servername, $username, $password, $dbname) or die ('Error connecting to mysql: ' . mysqli_error($mysqli).'\r\n');
36$result = $conn->query($sql);
37if ($result === false) {
38    throw new Exception("Could not execute query: " . $conn->error);
39}
40
41$db_names = array();
42while($row = $result->fetch_array(MYSQLI_NUM)) { // for each row of the resultset
43    $db_names[] = $row[0]; // Add db name to $db_names array
44}
45echo "<pre>";
46echo "Database names: " . PHP_EOL . print_r($db_names, TRUE); // display array
47echo "</pre>";
48
49// sql code to create table
50$sql = "CREATE TABLE IF NOT EXISTS employees(
51        userId INT(4)  PRIMARY KEY,
52        firstname VARCHAR(30) NOT NULL,
53        lastname VARCHAR(30) NOT NULL
54        )";
55
56//$conn = new mysqli($servername, $username, $password, $dbname) or die ('Error connecting to mysql: ' . mysqli_error($conn).'\r\n');
57$result = $conn->query($sql);
58if ($conn->query($sql) === TRUE) {
59    echo "Table employees created successfully <br>";
60} else {
61    echo "Error creating table: " . $conn->error . "<br>";
62}
63
64$sql = "INSERT INTO employees (firstname, lastname)
65VALUES ('Анатолий', 'Варламов')";
66
67if ($conn->query($sql) === TRUE) {
68    echo "New record created successfully <br>";
69} else {
70    echo "Error: " . $sql . "<br>" . $conn->error . "<br>";
71}
72
73$sql = "CREATE TABLE IF NOT EXISTS menu(
74    dishId INT(10) PRIMARY KEY AUTO_INCREMENT,
75    name VARCHAR(30) NOT NULL,
76    price INT(30) NOT NULL,
77    date VARCHAR(30) NOT NULL
78    )";
79
80$result = $conn->query($sql);
81if ($conn->query($sql) === TRUE) {
82echo "Table menu created successfully". "<br>";
83} else {
84echo " Error creating table: " . $conn->error . "<br>";
85}
86
87$sql = "INSERT INTO menu (name, price, date)
88VALUES ('chicken', '100', curdate())";
89
90if ($conn->query($sql) === TRUE) {
91    echo "New record created successfully" . "<br>";
92} else {
93    echo " Error: " . $sql . "<br>" . $conn->error . "<br>";
94}
95
96$sql ="SELECT * FROM menu WHERE name = 'chicken'" ;
97$result=$conn->query($sql);
98//$result->fetch();
99
100echo "<pre>";
101print_r ($result);
102echo "</pre>";
103
104if ($result->num_rows > 0) {
105    // output data of each row
106    while($row = $result->fetch_assoc()) {
107        echo "ID: " . $row["dishId"] . "<br>" . " Name: " . $row["name"] ."<br>" . " Price: " . $row["price"] . "<br>" . " Date: " . $row["date"] . "<br>";
108    }
109}
110
111
112$sql = 'DROP TABLES employees, menu, orders';
113$result = $conn->query($sql);