<?php
$dbserver = 'localhost';
$dbuser = 'szelep';
$dbpass = '';
$dbtable = 'student';
$db = 'szelep';
?>
<?php $connect = mysql_connect($dbserver, $dbuser, $dbpass) or die ('Error connecting to mysql');

mysql_select_db($db, $connect);
?>
<?php
$vloz2='INSERT INTO student VALUES
("","'.$_POST['meno'].'","'.$_POST['priezvisko'].'","'.$_POST['adresa'].'","'.$_POST['mesto'].'","'.$_POST['email'].'","'.$_POST['nick'].'","'.$_POST['rocnik'].'","'.$_POST['trieda'].'")';

echo $vloz2;

?>


<?php $vysledok=mysql_query($vloz2, $connect);?>
<?php

$result = mysql_query("SELECT id_student, meno, priezvisko, adresa, mesto, email, nick, rocnik ,trieda FROM student");
echo "<table>";

    while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
     echo "<tr>";
     echo '<td>'.$row[0]."</td>";
     echo '<td>'.$row["meno"].'</td>';
     echo '<td>'.$row["priezvisko"].'</td>';
     echo '<td>'.$row["adresa"].'</td>';
     echo '<td>'.$row["mesto"].'</td>';
     echo '<td>'.$row["email"].'</td>';
     echo '<td>'.$row["nick"].'</td>';
     echo '<td>'.$row["rocnik"].'</td>';
     echo '<td>'.$row["trieda"].'</td>';
     echo '<td><a href="formulardb.php?id='.$row[0].'">Upravit</a></td>';

     echo "</tr>";
    }


    mysql_free_result($result);

    echo "</table>";

    echo '<td><a href="formulardb.php">Pridaj novy zaznam</a></td>';
mysql_close($connect);
?>