<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8" />
<title>Panel administratora</title>
<link rel="stylesheet" href="styl4.css" />
</head>
<body>
<h3>Portal Społecznościowy - panel administratora
</h3>
<?php
$con = mysqli_connect('localhost', 'root', '', 'dane4');
$kw1 = "SELECT id, imie, nazwisko, rok_urodzenia, zdjecie FROM osoby LIMIT 30;";
$res1 = mysqli_query($con, $kw1);
while($tab = mysqli_fetch_row($res1)) {
$wiek = DATE("Y") - $tab[3];
echo "$tab[0]. $tab[1] $tab[2], $wiek
<br/>";
}
?>
<a href="settings.html">Inne ustawienia
</a>
<h4>Podaj id użytkownika
</h4>
<form acti method="post">
<input type="number" name="nr" />
</form>
<?php
if(!empty($_POST['nr'])) {
$nr = $_POST['nr'];
$kw2 = "SELECT osoby.imie, osoby.nazwisko, osoby.rok_urodzenia, osoby.opis, osoby.zdjecie, hobby.nazwa FROM osoby INNER JOIN hobby ON osoby.Hobby_id = hobby.id WHERE osoby.id = $nr;";
$res2 = mysqli_query($con, $kw2);
while($tab = mysqli_fetch_row($res2)) {
echo "
<h2>$nr. $tab[0] $tab[1]
</h2>
<img src='$tab[4]' alt='$nr' />
<p>Rok urodzenia: $tab[2]
</p>
}
}
mysqli_close($con);
?>
Stronę wykonał: Wilk Bartłomiej oraz Franciszek Rubin
</body>
</html>
css
body {
margin: 0;
font-family: Helvetica;
}
#baner,
#stopka {
background: #AF4448;
color: white;
text-align: center;
height: 20px;
clear: both;
}
#lewy,
#prawy {
background: #FFA4A2;
height: 650px;
width: 50%;
float: left;
}
h4 {
margin: 0;
}
button {
background: #AF4448;
color: white;
padding: 5px;
margin: 10px;
}
h3 {
margin: 0;
}
{"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"}