· 8 years ago · Dec 01, 2017, 03:02 PM
1<?php
2require_once('connect.php');
3$conn = new mysqli($servername, $username, $password);//Připojenà do PHPmyAdmin
4if (!$conn)
5{
6 die('Disconnected: '.mysql_error());
7}
8?>
9<html>
10<head>
11<title>Main_Page</title>
12<meta charset="UTF-8">
13<link rel="stylesheet" type="text/css" href="style.css">
14</head>
15<body>
16<H1>VÃtej te na naÅ¡Ã stránce!</H1>
17<form action="login.php">
18 <input type="submit" name="login_go_to" value="Přihlásit">
19</form>
20<form action="kosik.php">
21 <input type="submit" name="kosik_go_to" value="KoÅ¡Ãk">
22</form>
23<h2>NabÃdka Výrobků</h2><br>
24<?php
25$db_select = mysqli_select_db($conn,'shop');
26if($db_select)
27{
28echo"<form method = 'POST' action = '".$_SERVER['PHP_SELF']."' name='tridic'>
29 Kategorie: <select name='filtrat'>";
30$sql = "SELECT category FROM shop.products";
31$result = $conn->query($sql);
32 if ($result->num_rows > 0) {
33 while($row = $result->fetch_assoc()) {
34 echo "<option value=".$row["category"].">".$row["category"]."</option>";
35 }
36 echo "</select>";
37 echo "<input type='submit' value = 'TÅ™Ãdit'></form>";
38 }
39}
40else if (!$db_select)
41{
42 $sql = "CREATE DATABASE shop";
43 if (mysqli_query($conn, $sql))
44 {
45 echo "Databáze vytvořená.<br>";
46 }
47 $sql = "CREATE TABLE IF NOT EXISTS shop.products (id INT(3) AUTO_INCREMENT PRIMARY KEY, name VARCHAR(20) NOT NULL,category VARCHAR(20), description VARCHAR(20), cost VARCHAR(10) NOT NULL,currency VARCHAR(5) NOT NULL, image VARCHAR(500))";
48 if (mysqli_query($conn, $sql))
49 {
50 echo "Tabulka produktů vytvořená. $sql<br>";
51 $sql = "INSERT INTO shop.products (name,category, description, cost, currency, image) VALUES ('notebook Acer F15','elektronika', 'Just notebook', '200', '£', 'https://im9.cz/iR/importprodukt-orig/8d3/8d30f64391b4c9ca8e1c8d3a787b3efa--mmf250x250.jpg')";
52 $sql2 = "INSERT INTO shop.products (name,category, description, cost, currency, image) VALUES ('Toust','jÃdlo', 'Chutné a dobré', '2', '£', 'http://www.toastovanie.sk/cs/toustrady/extra-stavnaty-toust/treti-toust.png')";
53 if (mysqli_query($conn, $sql)&&mysqli_query($conn, $sql2))
54 {
55 echo "Do tabulky produkty bylz přidány 2 záznamy.<br>";
56
57 }
58 }
59 $sql = "CREATE TABLE IF NOT EXISTS shop.user_login(id INTEGER PRIMARY KEY AUTO_INCREMENT UNIQUE, username VARCHAR(15) UNIQUE, password VARCHAR(15) UNIQUE)";
60 if (mysqli_query($conn, $sql))
61 {
62 $sql = "INSERT INTO shop.user_login(username, password) VALUES ('Admin', 'Main')";//Admin úÄet
63 mysqli_query($conn, $sql);
64 echo "Tabulka loginů je vytvoÅ™ená se základnÃm uživatelem, Admin s heslem:Main.<br>";
65 }
66 $sql = "CREATE TABLE IF NOT EXISTS shop.kosik(id INTEGER PRIMARY KEY AUTO_INCREMENT UNIQUE,pocet_kusu INT(10),id_veci INT(3) UNIQUE, id_uzivatele VARCHAR(15) UNIQUE,FOREIGN KEY(id_veci) REFERENCES shop.products(id))";
67 if (mysqli_query($conn, $sql))
68 {
69 echo "Tabulka kosik byla vytvořená.<br>";
70 }
71 else
72 echo "KoÅ¡Ãk se nevytvoÅ™il. $sql";
73 $sql = "CREATE TABLE IF NOT EXISTS shop.zaznamy(id INTEGER PRIMARY KEY AUTO_INCREMENT UNIQUE, objednavka_jmeno VARCHAR(15) UNIQUE, objednavka_prijmeni VARCHAR(15) UNIQUE, objednavka_datum_narozeni VARCHAR(15),objednavka_bydliste VARCHAR(15),objednavka_telefon VARCHAR(15), objednavka_platba VARCHAR(15), id_produktu INT(3))";
74 if (mysqli_query($conn, $sql))
75 {
76 echo "Tabulka záznamy je vytvořená.<br>";
77 }
78 else
79 echo "$sql";
80 $sql = "CREATE TABLE IF NOT EXISTS shop.kupujici(id INTEGER PRIMARY KEY AUTO_INCREMENT UNIQUE,jmeno VARCHAR(20),prijmeni VARCHAR(20) UNIQUE, datum_narozeni VARCHAR(15),bydliste VARCHAR(50),telefon VARCHAR(15),typ_plat VARCHAR(7))";
81 if (mysqli_query($conn, $sql))
82 {
83 echo "Tabulka kupujici byla vytvořená.<br>";
84 }
85 else{
86 echo "kupujici se nevytvořil. $sql";
87
88 echo "<br>Pokud se vytvoÅ™ily vÅ¡echny tabulky produkty, v nÄ›m jeden produkt, login s adminem, koÅ¡Ãk a kupujici, tak se pÅ™ihlaÅ¡te a zaÄnete pÅ™idávat data.";
89}
90}
91
92if($db_select){
93 //$sql = "INSERT INTO shop.products(name, description, cost, image) VALUES ('Bicycle','You can ride on it', '500$', 'https://im9.cz/iR/importprodukt-orig/428/4280003c2abe33bd0da6198953d88d52.jpg')";
94 //mysqli_query($conn, $sql);
95 if(isset($_SERVER['PHP_SELF'])&&isset($_POST['filtrat']))
96 {
97 $sql = "SELECT * FROM shop.products WHERE category='".$_POST['filtrat']."'";
98 $result = $conn->query($sql);
99 if ($result->num_rows > 0) {
100 while($row = $result->fetch_assoc()) {
101 echo "<ul><li>ID: " . $row["id"]. " </li> <li> Jméno: " . $row["name"]." </li> <li> Popis: ". " " . $row["description"]. " </li> <li> Cena: ". $row["cost"] . " ". $row["currency"] . " </li> <li> Obrázek: <img src=". $row["image"] ."></li></ul><a href='?id_data=".$row['id']."'><button>Do koÅ¡Ãku</button></a><br>";
102 }
103 }
104 }
105 else{
106 $sql = "SELECT * FROM shop.products";
107 $result = $conn->query($sql);
108 if ($result->num_rows > 0) {
109 while($row = $result->fetch_assoc()) {
110 echo "<ul><li>ID: " . $row["id"]. " </li> <li> Jméno: " . $row["name"]." </li> <li> Popis: ". " " . $row["description"]. " </li> <li> Cena: ". $row["cost"] . " ". $row["currency"] . " </li> <li> Obrázek: <img src=". $row["image"] ."></li></ul><a href='?id_data=".$row['id']."'><button>Do koÅ¡Ãku</button></a><br>";
111 }
112}
113}
114}
115if(isset($_GET['id_data'])) {
116 $sql = "INSERT INTO shop.kosik (id_veci, pocet_kusu) VALUES ('".$_GET["id_data"]."','1')";
117 //echo "$sql";
118 if (mysqli_query($conn, $sql))
119 {
120 echo "Položka byla pÅ™idána do koÅ¡Ãku.<br>";
121 }
122 else
123 {
124 echo "Položka je již v koÅ¡Ãku.";
125 }
126 }
127?>
128</body>
129</html>