<!DOCTYPE html>
<html lang="pl">
<head>
<meta charset="UTF-8">
<meta name="viewport" c initial-scale=1.0">
<link rel="stylesheet" href="style.css">
<title>Biblioteka publiczna</title>
</head>
<body>
<header><h1>Biblioteka w Książkowicach Wielkich</h1></header>
<aside>
<h3>Polecamy dzieła autorów:</h3>
<?php
$conn=mysqli_connect('localhost','root','','biblioteka');
if($conn)
{
$pyt=mysqli_query($conn,'SELECT imie, nazwisko FROM autorzy ORDER BY nazwisko');
echo "<ol>";
while ($result=mysqli_fetch_array($pyt))
{
echo "<li>".$result['imie']. " ".$result['nazwisko']."</li>";
}
echo "</ol>";
}
mysqli_close($conn);
?>
</aside>
<main>
<h3>ul. Czytelnicza 25, Książkowice Wielkie</h3>
<img src="biblioteka.png" alt="książki">
</main>
<section id="d1">
<h3>Dodaj czytelnika</h3>
<form method="POST" acti>
imię:<input type="text" name="imie"><br>
nazwisko:<input type="text" name="nazw"><br>
symbol:<input type="number" name="sym"><br>
<input type="submit" value="DODAJ" name="wprowadzono">
</form>
</section>
<section id="d2">
<?php
if(isset($_POST['wprowadzono']))
{
$imie = $_POST['imie'];
$nazwisko = $_POST['nazw'];
$kod = $_POST['sym'];
echo "Czytelnik ".$_POST['imie']." ".$_POST['nazw']." został(a) dodany do bazy danych";
$connn=mysqli_connect('localhost','root','','biblioteka');
if($connn)
{
mysqli_query($connn, "INSERT INTO czytelnicy(imie, nazwisko, kod) VALUES ('$imie','$nazwisko','$kod');");
}
mysqli_close($connn);
}
?>
</section>
Replies to biblioteka
Title |
Name |
Language |
UNIX |
When |
bibliotekacss |
css |
text |
1712126718 |
1 Month ago. |
{"html5":"htmlmixed","css":"css","javascript":"javascript","php":"php","python":"python","ruby":"ruby","lua":"text\/x-lua","bash":"text\/x-sh","go":"go","c":"text\/x-csrc","cpp":"text\/x-c++src","diff":"diff","latex":"stex","sql":"sql","xml":"xml","apl":"apl","asterisk":"asterisk","c_loadrunner":"text\/x-csrc","c_mac":"text\/x-csrc","coffeescript":"text\/x-coffeescript","csharp":"text\/x-csharp","d":"d","ecmascript":"javascript","erlang":"erlang","groovy":"text\/x-groovy","haskell":"text\/x-haskell","haxe":"text\/x-haxe","html4strict":"htmlmixed","java":"text\/x-java","java5":"text\/x-java","jquery":"javascript","mirc":"mirc","mysql":"sql","ocaml":"text\/x-ocaml","pascal":"text\/x-pascal","perl":"perl","perl6":"perl","plsql":"sql","properties":"text\/x-properties","q":"text\/x-q","scala":"scala","scheme":"text\/x-scheme","tcl":"text\/x-tcl","vb":"text\/x-vb","verilog":"text\/x-verilog","yaml":"text\/x-yaml","z80":"text\/x-z80"}