<?php

    //Connecting to database
    $hostname = "localhost";
    $database = "test";
    $username = "root";
    $password = "";

    $login = mysql_connect($hostname, $username, $password) or trigger_error(mysql_error(),E_USER_ERROR);
    mysql_select_db($database);

        echo('<input type="text" name="Name"/>');
        echo('<input type="text" name="Klasse"/>');
        echo('<form method="post"><input type="submit" value="Einfügen" name="knopf" /></form>');
        $name = mysql_real_escape_string($_POST['Name']);
        $klasse = mysql_real_escape_string($_POST['Klasse']);
        $query = "INSERT INTO schüler(id,schüler,klasse) VALUES (NULL,'$name','$klasse')";
        if (isset( $_POST [ 'knopf' ]))
        {
            mysql_query($query) or die (mysql_error());
        }

        //Getting the data
        $sql = "SELECT id,schüler,klasse FROM schüler";
        $result = mysql_query($sql) or die(mysql_error());

        //Displays the data.
        while($rad=mysql_fetch_array($result))
        {
            echo  '<table width="100%">
                    <tr>
                    <td>
                    '.$rad['id'].' - '.$rad['schüler'].' - '.$rad['klasse'].'
                    </td></tr></table>';
        }
            if(mysql_num_rows($result) == 0)
            {
                echo '<b>No users to display!</b>';
            }

?>