146 lines
7.3 KiB
PHP
146 lines
7.3 KiB
PHP
|
<?php
|
||
|
|
$conn = mysqli_connect("localhost", "root", "", "ksiegarnia");
|
||
|
|
mysqli_select_db($conn, "ksiegarnia");
|
||
|
|
?>
|
||
|
|
<!DOCTYPE html>
|
||
|
|
<html>
|
||
|
|
<head>
|
||
|
|
<meta charset='utf-8'>
|
||
|
|
<meta http-equiv='X-UA-Compatible' content='IE=edge'>
|
||
|
|
<title>Zadanie 8</title>
|
||
|
|
<meta name='viewport' content='width=device-width, initial-scale=1'>
|
||
|
|
<link rel="icon" href="/favicon.ico">
|
||
|
|
<link rel='stylesheet' type='text/css' media='screen' href='/assets/css/styl.css'>
|
||
|
|
<link rel='stylesheet' type='text/css' media='screen' href='/assets/css/blog.css'>
|
||
|
|
</head>
|
||
|
|
<body>
|
||
|
|
<header>
|
||
|
|
<h1>Zadanie 8</h1>
|
||
|
|
<nav>
|
||
|
|
<a href="./zad1.html">Zadanie 1</a>
|
||
|
|
<a href="./zad2.html">Zadanie 2</a>
|
||
|
|
<a href="./zad3.html">Zadanie 3</a>
|
||
|
|
<a href="./zad4.html">Zadanie 4</a>
|
||
|
|
<a href="./zad5.html">Zadanie 5</a>
|
||
|
|
<a href="./zad6.html">Zadanie 6</a>
|
||
|
|
<a href="./zad7.php">Zadanie 7</a>
|
||
|
|
<a href="./zad8.php">Zadanie 8</a>
|
||
|
|
</nav>
|
||
|
|
</header>
|
||
|
|
<main>
|
||
|
|
<h2>Autorzy</h2>
|
||
|
|
<article>
|
||
|
|
<h4>Dodaj autora</h4>
|
||
|
|
<?php
|
||
|
|
if ($_POST && isset($_POST["sub"]) && $_POST["sub"] == "dodajAutora") {
|
||
|
|
if (!isset($_POST["imie"]) || !isset($_POST["nazwisko"])) {
|
||
|
|
echo "<code style=\"color:red;\">Nie podano wystarczającej ilości danych!</code>";
|
||
|
|
} else {
|
||
|
|
$resp = mysqli_query($conn, "INSERT INTO `ksiegarnia`.`autorzy` (`Imie`, `Nazwisko`) VALUES ('".$_POST["imie"]."', '".$_POST["nazwisko"]."')");
|
||
|
|
if ($resp) {
|
||
|
|
echo "<code style=\"color:green;\">Dodano autora do bazy danych!</code>";
|
||
|
|
} else {
|
||
|
|
echo "<code style=\"color:red;\">Nie udało się dodać do bazy danych!!</code>";
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
<form method="post">
|
||
|
|
<input type="hidden" name="sub" value="dodajAutora">
|
||
|
|
<label for="imie">Imię</label><br>
|
||
|
|
<input type="text" name="imie" id="imie" required><br>
|
||
|
|
<label for="nazwisko">Nazwisko</label><br>
|
||
|
|
<input type="text" name="nazwisko" id="nazwisko" required><br>
|
||
|
|
<input type="reset" value="Resetuj dane">
|
||
|
|
<input type="submit" value="Dodaj autora">
|
||
|
|
</form>
|
||
|
|
</article>
|
||
|
|
<ul>
|
||
|
|
<?php
|
||
|
|
$resp = mysqli_query($conn, "SELECT * FROM autorzy");
|
||
|
|
while ($data = mysqli_fetch_array($resp))
|
||
|
|
{
|
||
|
|
echo "<li>Autor: ".$data["Imie"]." ".$data["Nazwisko"]."</li>";
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
<h2>Książki</h2>
|
||
|
|
<article>
|
||
|
|
<h4>Dodaj Książkę</h4>
|
||
|
|
<?php
|
||
|
|
if ($_POST && isset($_POST["sub"]) && $_POST["sub"] == "dodajKsiazke") {
|
||
|
|
if (!isset($_POST["autor"]) || !isset($_POST["nazwa"]) || !isset($_POST["rokwydania"]) || !isset($_POST["wydawnictwo"])) {
|
||
|
|
echo "<code style=\"color:red;\">Nie podano wystarczającej ilości danych!</code>";
|
||
|
|
} else if (!mysqli_query($conn, "SELECT * FROM `autorzy` WHERE (autorzy.IDAutor = ".$_POST["autor"].")")) {
|
||
|
|
echo "<code style=\"color:red;\">Autor nie istnieje!</code>";
|
||
|
|
} else {
|
||
|
|
$resp = mysqli_query($conn, "INSERT INTO `ksiegarnia`.`ksiazki` (`AutorID`, `Tytul`, `RokWydania`, `Wydawnictwo`) VALUES (".$_POST["autor"].", '".$_POST["nazwa"]."', ".$_POST["rokwydania"].", '".$_POST["wydawnictwo"]."')");
|
||
|
|
if ($resp) {
|
||
|
|
echo "<code style=\"color:green;\">Dodano książkę do bazy danych!</code>";
|
||
|
|
} else {
|
||
|
|
echo "<code style=\"color:red;\">Nie udało się dodać do bazy danych!!</code>";
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
<form method="post">
|
||
|
|
<input type="hidden" name="sub" value="dodajKsiazke">
|
||
|
|
<label for="autor">Autor</label><br>
|
||
|
|
<select name="autor" id="autor" required>
|
||
|
|
<option selected>Wybierz autora</option>
|
||
|
|
<?php
|
||
|
|
$resp = mysqli_query($conn, "SELECT * FROM autorzy");
|
||
|
|
while ($data = mysqli_fetch_array($resp))
|
||
|
|
{
|
||
|
|
echo "<option value=\"".$data["IDAutor"]."\">".$data["Imie"]." ".$data["Nazwisko"]."</option>";
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
</select><br>
|
||
|
|
<label for="nazwa">Nazwa książki</label><br>
|
||
|
|
<input type="text" name="nazwa" id="nazwa" required><br>
|
||
|
|
<label for="rokwydania">Rok Wydania</label><br>
|
||
|
|
<input type="number" name="rokwydania" id="rokwydania" required><br>
|
||
|
|
<label for="wydawnictwo">Wydawnictwo</label><br>
|
||
|
|
<input type="text" name="wydawnictwo" id="wydawnictwo" value=">w< bOwOks :3" readonly required><br>
|
||
|
|
<input type="reset" value="Resetuj dane">
|
||
|
|
<input type="submit" value="Dodaj książkę">
|
||
|
|
</form>
|
||
|
|
</article>
|
||
|
|
<table>
|
||
|
|
<thead>
|
||
|
|
<td>Autor</td>
|
||
|
|
<td>Tytuł</td>
|
||
|
|
<td>Rok Wydania</td>
|
||
|
|
<td>Wydawnictwo</td>
|
||
|
|
</thead>
|
||
|
|
<tbody>
|
||
|
|
<?php
|
||
|
|
$resp = mysqli_query($conn, "SELECT * FROM ksiazki LEFT JOIN autorzy ON ksiazki.AutorID = autorzy.IDAutor");
|
||
|
|
while ($data = mysqli_fetch_array($resp)) {
|
||
|
|
echo "<tr>";
|
||
|
|
echo " <td>".$data["Imie"]." ".$data["Nazwisko"]."</td>";
|
||
|
|
echo " <td>".$data["Tytul"]."</td>";
|
||
|
|
echo " <td>".$data["RokWydania"]."</td>";
|
||
|
|
echo " <td>".$data["Wydawnictwo"]."</td>";
|
||
|
|
echo "</tr>";
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
</tbody>
|
||
|
|
</table>
|
||
|
|
</main>
|
||
|
|
<footer>
|
||
|
|
Stronę wykonał: 213742069
|
||
|
|
<br>
|
||
|
|
<br>
|
||
|
|
<img class="banner" src="https://darksteveneq.nonamesoft.xyz/assets/banners/athens_acropolis_4793_images_trinitynow.gif" width="88">
|
||
|
|
<img class="banner" src="https://darksteveneq.nonamesoft.xyz/assets/banners/paws.gif" width="88" height="31">
|
||
|
|
<img class="banner" src="https://darksteveneq.nonamesoft.xyz/assets/banners/anythingbut.gif" width="88" height="31">
|
||
|
|
<img class="banner" src="https://darksteveneq.nonamesoft.xyz/assets/banners/itoddler.gif" width="88" height="31">
|
||
|
|
</footer>
|
||
|
|
</body>
|
||
|
|
</html>
|
||
|
|
|
||
|
|
<?php
|
||
|
|
mysqli_close($conn);
|
||
|
|
?>
|