- <html>
- <?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);
- $parzyste = 1;
- if( $wyniki )
- {
- echo "<table>" ;
- echo"<tr style='background-color:blue;'>";
- echo "<th>NR_STUD</th>";
- echo "<th>NAZWISKO</th>";
- echo "<th>DATA_UR</th>";
- echo "<th>PLEC</th>";
- echo "<th>NR_KIER</th>";
- echo "</tr> ";
- while($wiersz=mysql_fetch_row($wyniki))
- {
- if($parzyste % 2 == 0)
- {
- echo "<tr style='background-color:lime;'>";
- }else
- {
- echo "<tr style='background-color:yellow;'>";
- }
- echo "<td>", $wiersz[0],"</td>";
- echo "<td><a href='oceny.php?NR_STUD=",$wiersz[0],"'>",$wiersz[1],"</a></td>";
- echo "<td>", $wiersz[2],"</td>";
- echo "<td>", $wiersz[3],"</td>";
- echo "<td>", $wiersz[4],"</td>";
- echo "</tr>";
- $parzyste = $parzyste+1;
- }
- echo "</table>";
- }
- else
- echo "Brak";
- ?>
- <html>
- -----------------------------------------------
- oceny
- <html>
- <?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);
- $nr_stud=$_GET['NR_STUD'];
- $wyn="SELECT * FROM OCENY WHERE NR_STUD=" . $nr_stud;
- echo "<table>" ;
- echo"<tr style='background-color:blue;'>";
- echo "<th>NR_STUD</th>";
- echo "<th>NR_PRZED</th>";
- echo "<th>DATA_ZAL</th>";
- echo "<th>TERMIN</th>";
- echo "<th>ZAL_EGZ</th>";
- echo "<th>OCENA</th>";
- echo "</tr> ";
- @$wyniki=mysql_db_query($DBase, $wyn , $idpol);
- $parzyste = 1;
- while($wiersz=mysql_fetch_row($wyniki))
- {
- if($parzyste % 2 == 0)
- {
- echo "<tr style='background-color:lime;'>";
- }else
- {
- echo "<tr style='background-color:yellow;'>";
- }
- 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 "</tr>";
- $parzyste = $parzyste+1;
- }
- echo "</table>";
- ?>
- <html>