<?php
if ($_POST['zarejestruj']) {
header("Location: student.php");
}
?>
<?php session_start();?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="pl" xml:lang="pl">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2" />
<title>Logowanie</title>
<link rel="Stylesheet" type="text/css" href="style.css" />
</head>
<body>
<?php
if ($_POST['wyloguj']) {
session_unset();
}
if ($_POST['zaloguj']) {
$mysqli = new mysqli("localhost", "root", "", "ocena");
$query = "SELECT Admin FROM loginy WHERE Login = ? and Haslo = ?";
$stmt = $mysqli->prepare($query);
$stmt->bind_param("ss", $_POST['login'], $_POST['haslo']);
$stmt->execute();
$stmt->bind_result($administrator);
$istnieje = $stmt->fetch();
$mysqli->close();
if (!$istnieje){
echo "Błąd logowania";
} else {
$_SESSION['admin']=$administrator;
$_SESSION['login'] = $_POST['login'];
}
}
?>
<div id="naglowek">
</div>
<div id="prawo">
<p>
<form method="POST" action="logowanie.php">
<table>
<tr><td><h3>Logowanie </h3></td></tr>
<tr><td><input type="text" name="login"/></td></tr>
<tr><td>Login</td></tr>
<tr><td><input type="password" name="haslo"/></td></tr>
<tr><td>Hasło</td></tr>
</table>
<input type="submit" name="zaloguj" value="Zaloguj"/>
<input type="submit" name="wyloguj" value="Wyloguj"/><br>
<br/>
<input type="submit" name="zarejestruj" value="Zarejestruj się" />
</form>
</div>
</p>
<div id="lewo">
<br/>
<br/>
OCEŃ SWOJEGO WYKŁADOWCĘ
</div>
<div id="naglowek">
dfsfsf
</div>
</body>
</html>
uprawnienia.php
<?php
session_start();
if (!$_SESSION['login']) {
die("Jesteś niezalogowany");
}
?>
wykladowca.php
<?php include "uprawnienia.php"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="pl" xml:lang="pl">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-2" />
<title>Untitled</title>
</head>
<body>
<p>
<?php echo $_SESSION['Login']; ?>
<?php
$mysqli = new mysqli("localhost", "root", "", "ocena");
$query = "SELECT * FROM wykladowca WHERE Nazwisko = ?";
$stmt = $mysqli->prepare($query);
$stmt->bind_param("s", $_GET['n']);
$stmt->execute();
$stmt->bind_result($ID, $imie, $nazwisko, $tytul);
$stmt->fetch();
$mysqli->close();
?>
<h1>
Dane wykładowcy
</h1>
<form action="zapis_wykladowca.php" method="POST">
<table>
<tr> </tr>
<tr> </tr>
<input type="hidden" name="ID" value="<?php echo $ID?>"/>
<tr> <td><h3>Imię</h3></td> <td><input type="text" name="imie" value="<?php echo $imie?>"/>
</td><td><h3>Nazwisko<h3> </td><td><input type="text" name="nazwisko"/> </td> </tr>
<tr><td><h3> Tytuł naukowy: </h3></td> </tr>
<?php
$mysqli = new mysqli("localhost", "root", "", "ocena");
$query = "SELECT ID, Tytul FROM tytul";
$stmt = $mysqli->prepare($query);
$stmt->execute();
$stmt->bind_result($ID, $Tytul);
while ($stmt->fetch()) {
echo "<tr>";
echo "<td> <input type=\"radio\" name=\"tytulNaukowy\" value=\"$ID\" />$Tytul</td>";
echo "</tr>";
};
$mysqli->close();
?>
</table>
<input type="submit" value="Zapisz wykladowce"/>
</form>
</p>
</body>
</html>
zapis_wykladowca.php
<?php include "uprawnienia.php"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="pl" xml:lang="pl">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-2" />
<title>Untitled</title>
</head>
<body>
<p>
<?php
$mysqli = new mysqli("localhost", "root", "", "ocena");
if ($_POST['ID']) {
$query = "UPDATE wykladowca SET
imie=?, nazwisko=?, tytul=?
WHERE id=?";
$stmt = $mysqli->prepare($query);
$stmt->bind_param("ssdd",
$_POST['imie'],
$_POST['nazwisko'],
$_POST['tytulNaukowy'],
$_POST['ID']
);
}
else
{
$query = "INSERT INTO wykladowca (imie, nazwisko, Tytul)
VALUES (?, ?, ?)";
$stmt = $mysqli->prepare($query);
$stmt->bind_param("ssd",
$_POST['imie'],
$_POST['nazwisko'],
$_POST['tytulNaukowy']
);
}
$stmt->execute();
$mysqli->close();
?>
<h2>Zapisano </h2>
</p>
</body>
</html>
student.php
<?php session_start();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="pl" xml:lang="pl">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-2" />
<title>Untitled</title>
</head>
<body>
<p>
<?php echo $_SESSION['Login']; ?>
<?php
$mysqli = new mysqli("localhost", "root", "", "ocena");
$query = "SELECT * FROM student WHERE Nazwisko = ?";
$stmt = $mysqli->prepare($query);
$stmt->bind_param("s", $_GET['n']);
$stmt->execute();
$stmt->bind_result($ID, $imie, $nazwisko, $nrindeksu, $kierstud, $semestr, $login);
$stmt->fetch();
$mysqli->close();
?>
<h1>
Dane Studenta
</h1>
<form action="zapis_student.php" method="POST">
<table>
<tr> </tr>
<tr> </tr>
<input type="hidden" name="ID" value="<?php echo $ID?>"/>
<tr> <td><h3>Imię </h3></td> <td><input type="text" name="imie" value="<?php echo $imie?>"/></td>
<td><h3>Nazwisko <h3> </td><td><input type="text" name="nazwisko"/> </td> </tr>
<tr><td><h3> Nr indeksu </h3> <td><input type="text" name="nrindeksu"/> </td></td> </tr>
<tr><td><h3> Kierunek studiów </h3> <td><input type="text" name="kierstud"/> </td></td> </tr>
<tr><td><h3> Semestr </h3> <td><input type="text" name="semestr"/> </td></td> </tr>
<tr><td><input type="text" name="login"/></td></tr>
<tr><td>użytkownik</td></tr>
<tr><td><input type="password" name="haslo"/></td></tr>
<tr><td>hasło</td></tr>
</table>
<input type="submit" value="Zapisz studenta"/>
</form>
</p>
</body>
</html>
zapis_student.php
<?php session_start();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="pl" xml:lang="pl">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-2" />
<title>Untitled</title>
</head>
<body>
<p>
<?php
$mysqli = new mysqli("localhost", "root", "", "ocena");
if ($_POST['ID']) {
$query = "UPDATE loginy SET
Login=?, Haslo=?
WHERE Login=(SELECT Login FROM student WHERE Id=?)";
$stmt = $mysqli->prepare($query);
$stmt->bind_param("ssd",
$_POST['login'],
$_POST['haslo'],
$_POST['ID']
);
$stmt->execute();
$query = "UPDATE student SET
Imie=?, Nazwisko=?, NrIndeksu=?, Kierunek=?, Semestr=?, Login=?
WHERE Id=?";
$stmt = $mysqli->prepare($query);
$stmt->bind_param("ssdsdsd",
$_POST['imie'],
$_POST['nazwisko'],
$_POST['nrindeksu'],
$_POST['kierstud'],
$_POST['semestr'],
$_POST['login'],
$_POST['ID']
);
$stmt->execute();
}
else
{
$query = "INSERT INTO student (Imie, Nazwisko, NrIndeksu, Kierunek, Semestr, Login)
VALUES (?, ?, ?, ?, ?, ?)";
$stmt = $mysqli->prepare($query);
$stmt->bind_param("ssdsds",
$_POST['imie'],
$_POST['nazwisko'],
$_POST['nrindeksu'],
$_POST['kierstud'],
$_POST['semestr'],
$_POST['login']
);
$stmt->execute();
$query = "INSERT INTO loginy (Login, Haslo, Admin)
VALUES (?, ?, ?)";
$stmt = $mysqli->prepare($query);
$nieadmin="n";
$stmt->bind_param("sss",
$_POST['login'],
$_POST['haslo'],
$nieadmin
);
$stmt->execute();
}
$mysqli->close();
?>
<h2>Zapisano </h2>
</p>
</body>
</html>
style.css
#naglowek
{
background-color: #222222;
text-align: center;
color: #99FF33;
font-family: arial;
height: 100px;
}
#lewo {
float: left;
width: 70%;
background-color: #222222;
height: 400px;
font-size: 40pt;
font-family: arial;
color: #99FF33;
}
#prawo {
float: right;
width: 30%;
background-color: #99FF33;
height:400px;
}
#nagldol
{
background-color: #222222;
height:500px;
}
