Untitled

<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['id'];


  $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>