- <html>
- <style>
- .table, td, th {
- border: 1px solid black;
- border-collapse: collapse;
- }
- tr:nth-child(even) {
- background: lightgray;
- }
- td {
- padding: 5px;
- }
- </style>
- <table>
- <?php
- $Host = '127.0.0.1';
- $DBase = 'oswiata';
- $FUser = 'root';
- $FPass = '';
- function polacz($host, $dbase, $user, $pass) {
- @$pol = mysql_connect($host, $user, $pass);
- if (!$pol) {
- echo 'Bład polaczenia z Serwerem Bazy Danych';
- exit();
- } else {
- @mysql_select_db($dbase);
- if (mysql_errno()) {
- echo mysql_errno() . ': ' . mysql_errno();
- echo mysql_error();
- exit();
- }
- }
- return $pol;
- }
- $idpol = polacz($Host, $DBase, $FUser, $FPass);
- @$wyniki = mysql_db_query($DBase, "SELECT * FROM studenci WHERE nazwisko like 'K%'", $idpol);
- if ($wyniki) {
- echo "<table class='table'>";
- $i = 0;
- echo "<tr>";
- echo "<th>Numer</td>";
- echo "<th>Nazwisko</td>";
- echo "<th>Data</td>";
- echo "<th>Plec</td>";
- echo "</tr>";
- while ($row = mysql_fetch_row($wyniki)) {
- $i++;
- echo "<tr>";
- echo "<td>", $row[0], "</td>";
- echo "<td> <a href=zad2.php?id=$row[0]>", $row[1],"</a></td>";
- echo "<td>", $row[2], "</td>";
- echo "<td>", $row[3], "</td>";
- echo "</tr>";
- }
- echo "</table>";
- } else
- echo "Brak wynikow!";
- ?>
- </table>
- </html>
- <html>
- <head>
- <style>
- .table, td, th {
- border: 1px solid black;
- border-collapse: collapse;
- }
- tr:nth-child(even) {
- background: lightgray;
- }
- td {
- padding: 5px;
- }
- #form--add {
- display: none;
- }
- </style>
- </head>
- <body>
- <?php
- $Host = '127.0.0.1';
- $DBase = 'oswiata';
- $FUser = 'root';
- $FPass = '';
- function polacz($host, $dbase, $user, $pass) {
- @$pol = mysql_connect($host, $user, $pass);
- if (!$pol) {
- echo 'Blad polaczenia z Serwerem Bazy Danych';
- exit();
- } else {
- @mysql_select_db($dbase);
- if (mysql_errno()) {
- echo mysql_errno() . ': ' . mysql_errno();
- echo mysql_error();
- exit();
- }
- }
- return $pol;
- }
- $id = $_GET['id'];
- $idpol = polacz($Host, $DBase, $FUser, $FPass);
- if(@!is_null($_POST['ocena'])) {
- $id = $_POST['id'];
- $ocena = $_POST['ocena'];
- $query = "INSERT INTO oceny (nr_stud, ocena) VALUES ($id, $ocena)";
- @$results = mysql_db_query($DBase, $query, $idpol);
- echo "<p>Dodano nowa ocene</p>";
- }
- if(@!is_null($_POST['nowaocena'])) {
- $id = $_GET['id'];
- $przedm = $_POST['przedm'];
- $ocena = $_POST['nowaocena'];
- $query = "UPDATE oceny SET ocena=$ocena WHERE nr_stud=$id AND nr_przedm=$przedm";
- @$results = mysql_db_query($DBase, $query, $idpol);
- echo "<p>Zedytowano ocene</p>";
- }
- if(@!is_null($_POST['usun_oc'])) {
- $id = $_GET['id'];
- $przedm = $_POST['przedm'];
- $ocena = $_POST['usun_oc'];
- $query = "Delete from oceny WHERE nr_stud=$id AND nr_przedm=$przedm AND ocena=$ocena";
- @$results = mysql_db_query($DBase, $query, $idpol);
- echo "<p>Usunieto ocene</p>";
- }
- $query = "SELECT * FROM oceny WHERE nr_stud=" . $id;
- @$results = mysql_db_query($DBase, $query, $idpol);
- if ($results) {
- $i = 0;
- echo "<table>";
- echo "<tr>";
- echo "<th>Nr studenta</td>";
- echo "<th>Nr przedmiotu</td>";
- echo "<th>Data zaliczenia</td>";
- echo "<th>Termin</td>";
- echo "<th>Zaliczenie egzaminu</td>";
- echo "<th>Ocena</td>";
- echo "<th>Akcje</th>";
- echo "</tr>";
- while ($wiersz = mysql_fetch_row($results)) {
- echo "<tr>";
- echo "<td>", $wiersz[0], "</td>";
- echo "<td>", $wiersz[1], "</td>";
- echo "<td>", $wiersz[2], "</td>";
- echo "<td>", $wiersz[3], "</td>";
- echo "<td>", $wiersz[4], "</td>";
- echo "<td>", $wiersz[5], "</td>";
- echo "<td>"
- . "<form action='zad2.php?id=$id' method='POST'>"
- . "<input type='hidden' name='id' value=$id>"
- . "<input type='hidden' name='przedm' value=$wiersz[1]>"
- . "<label>Edytuj ocenę</label> <input type='text' name='nowaocena' maxlength='1'>"
- . "<input type='submit' value='Edytuj'>"
- . "</form>"
- ."<form action='zad2.php?id=$id' method='POST'>"
- ."<input type='hidden' name='id' value=$id>"
- . "<input type='hidden' name='przedm' value=$wiersz[1]>"
- . "<input type='hidden' name='usun_oc' value=$wiersz[5]>"
- . "<input type='submit' value='Usun'>"
- . "</form>"
- . "</td>";
- echo "</tr>";
- }
- echo "</table>";
- } else {
- echo "Brak wynikow!";
- }
- echo "<form action='zad2.php?id=$id' method='POST'>"
- . "<input type='hidden' name='id' value=$id>"
- . "<label>Dodaj ocenę</label> <input type='text' name='ocena' maxlength='1'>"
- . "<input type='submit' value='Dodaj ocene'>"
- . "</form>";
- ?>
- </body>
- </html>