<?php

$host='localhost';
$user='root';
$password='';
$basename='forum';
$base=mysql_connect($host,$user,$password);
mysql_select_db($basename);


    if(isset($_POST['submit']))
    {
            if(!empty($_POST['login']) and !empty($_POST['password']) and !empty($_POST['mail']))
                {
                    $login=$_POST['login'];
                    $password=md5($_POST['password']);
                    $mail=$_POST['mail'];
                    if(mysql_num_rows(mysql_query('SELECT login FROM users WHERE login="'.$login.'"')))
                        echo 'Uzytkownik o podanym loginie juz istnieje<BR><a href="register.php">Powrot do formularza</a>';
                    else{
                            $sql='INSERT INTO users(login,password,mail,created) values("'.$login.'","'.$password.'","'.$mail.'","'.date('Y-m-d H:i:s').'")';
                            if(mysql_query($sql))
                                echo 'Uzytkownik zarejestrowany<br><a href="login.php">Zaloguj sie</a>';

                            else
                            echo 'ups';
                        }
                }
    }
        else
        {
            echo ' <center><form action="register.php" method="POST">
                    <table>
                        <tr>
                            <td>Login: </td> <td> <input type="text" name="login"></td></tr>
                        <tr>
                            <td>Nowe haslo: </td><td><input type="password" name="password"></td></tr>
                        <tr>
                            <td>E-mail: </td><td><input type="text" name="mail"></td></tr>

                        <tr><td><input type="submit" name="submit" value="Zarejestruj"></td></tr>
                        </table>';
        }

?>