31TSAI/ProjektowanieBazDanych/projekt_ordv1.php

74 lines
2.5 KiB
PHP
Raw Permalink Normal View History

2023-09-18 14:23:43 +02:00
<!doctype html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="description"
content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Strona główna</title>
</head>
<body>
<h2 align="center">Baza danych Wylazowski, Klasa 5D2</h2>
<?php
$id_conn = mysqli_connect('localhost', 'root', '', 'baza_testowa');
2023-10-02 14:10:40 +02:00
$zapytanie = "SELECT ord.id,
customer.name,
DATE_FORMAT(ord.date_ordered,'%Y-%m-%d, %W') AS 'data',
CONCAT(emp.last_name, ' ', emp.first_name) AS 'sprzed',
CONCAT(szef.last_name, ' ', szef.first_name) AS 'szef',
ord.total,
IFNULL(item.item_id, 'B.D.') AS 'id',
IFNULL(product.name, 'Brak danych') AS 'prod',
IFNULL(item.quantity, '-----') AS 'ilosc',
IFNULL(item.price, '-----') AS 'cena'
FROM ord INNER JOIN customer ON customer.id = ord.customer_id
INNER JOIN emp ON emp.id = ord.sales_rep_id
JOIN emp as szef ON szef.id = emp.manager_id
LEFT OUTER JOIN item ON item.ord_id = ord.id
LEFT OUTER JOIN product ON product.id = item.product_id;";
2023-09-18 14:23:43 +02:00
$wynik = mysqli_query($id_conn, $zapytanie);
?>
<table cellspacing="0" cellpadding="0" border="1" style="width: 90%;" align="center">
<tbody align="center">
2023-09-25 14:17:44 +02:00
<tr bgcolor="#A000FF">
2023-09-18 14:23:43 +02:00
<td>ID</td>
<td>Nazwa Klienta</td>
<td>Data zamówienia</td>
<td>Sprzedawca</td>
2023-10-02 14:10:40 +02:00
<td>Szef</td>
2023-09-18 14:23:43 +02:00
<td>Wartość</td>
2023-10-02 14:10:40 +02:00
<td>ID</td>
2023-09-25 14:17:44 +02:00
<td>Nazwa produktu</td>
<td>Ilość</td>
2023-10-02 14:10:40 +02:00
<td>Cena</td>
2023-09-18 14:23:43 +02:00
</tr>
<?php
2023-09-25 14:17:44 +02:00
while ($row = mysqli_fetch_array($wynik)) {
2023-09-18 14:23:43 +02:00
echo '<tr><td>';
printf("%d", $row['id']);
echo '</td><td>';
printf("%s", $row['name']);
echo '</td><td>';
2023-10-02 14:10:40 +02:00
printf("%s", $row['data']);
2023-09-18 14:23:43 +02:00
echo '</td><td>';
2023-10-02 14:10:40 +02:00
printf("%s", $row['sprzed']);
2023-09-18 14:23:43 +02:00
echo '</td><td>';
2023-10-02 14:10:40 +02:00
printf("%s", $row['szef']);
2023-09-18 14:23:43 +02:00
echo '</td><td>';
printf("%s", $row['total']);
echo '</td><td>';
2023-10-02 14:10:40 +02:00
printf("%s", $row['id']);
2023-09-25 14:17:44 +02:00
echo '</td><td>';
2023-10-02 14:10:40 +02:00
printf("%s", $row['prod']);
2023-09-25 14:17:44 +02:00
echo '</td><td>';
2023-10-02 14:10:40 +02:00
printf("%s", $row['ilosc']);
2023-09-25 14:17:44 +02:00
echo '</td><td>';
2023-10-02 14:10:40 +02:00
printf("%s", $row['cena']);
2023-09-18 14:23:43 +02:00
echo '</td></tr>';
}
?>
</tbody>
</table>
</body>
</html>