<?php
// k3nz0 > sarhan
// problem ?

$db_host="localhost";
$db_user="root";
$db_pass="";
$db_name="register";

$connect = mysql_connect($db_host, $db_user, $db_pass);
if(!$connect)
        die('Could not connect: ' . mysql_error());

$y = mysql_select_db($db_name, $connect);
    if(!$y)
        die('Enable to connect to the database.');

if($_POST)
{
    if(isset($_POST['name']) && !empty($_POST['name']))
    {
        $name = mysql_real_escape_string($_POST['name']);
        if(isset($_POST['first_name']) && !empty($_POST['first_name']))
        {
            $first_name = mysql_real_escape_string($_POST['first_name']);
            if(isset($_POST['email']) && !empty($_POST['email']) && preg_match("#^[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$#Ui", trim($_POST['email']))) // regex sur l'email
            {
                $email = mysql_real_escape_string(trim($_POST['email']));
                if(isset($_POST['date']) && !empty($_POST['date']) && preg_match("#^[0-9]{1,2}\/[0-9]{1,2}\/[0-9]{4}$#Ui", trim($_POST['date'])))
                {
                    preg_match("#^[0-9]{1,2}\/[0-9]{1,2}\/([0-9]{4})$#", trim($_POST['date']), $year);
                    if(intval($year[1])>=1987 && intval($year[1])<=1996)
                        $birthdate = mysql_real_escape_string($year[1]);
                    else
                        echo "You must have a maximum of 25 years to attend the event.<br />";

                    if(isset($_POST['numero']) && !empty($_POST['numero']) && preg_match("#^[0-9]{8}$#", trim($_POST['numero']))) // regex sur le numéro
                        $numero = mysql_real_escape_string(trim($_POST['numero']));
                    else
                        echo "Invalid phone number.<br />";

                }
                else
                    echo "Invalid date.<br />";

            }
            else
                echo "Invalid email.<br />";
        }
        else
            echo "Invalid first name.<br />";
    }
    else
        echo "Invalid name.<br />";
}



if(isset($_POST['occupation']) && !empty($_POST['occupation']))
    $occupation = mysql_real_escape_string($_POST['occupation']);
else
    $occupation = "NULL";
if(isset($_POST['twitter']) && !empty($_POST['twitter']))
    $twitter = mysql_real_escape_string($_POST['twitter']);

else
    $twitter = "NULL";

if(isset($_POST['team_message']) && !empty($_POST['team_message']))
    $team_message = mysql_real_escape_string($_POST['team_message']);

else
    $team_message = "NULL";


$ip = mysql_real_escape_string(getenv('REMOTE_ADDR'));
if(isset($name) && isset($first_name) && isset($email) && isset($birthdate) && isset($numero))
{
    $x = mysql_query("INSERT INTO users (name, first_name, email, birthdate, phone, occupation, twitter, message, ip) VALUES ('$name', '$first_name', '$email', '$birthdate', '$numero', '$occupation', '$twitter', '$team_message', '$ip')");
    if(!$x)
        die('Syntax error.');

    $subjet = "Hello $name $first_name";
    $message = "Hi $name $first_name ,\nYou will receive an e-mail within the next 48 hours with our recommendations.\n\nTEDxYouth's team";
    $headers = 'From: contact@tedxyouthlafayette.com' . "\r\n" .
     'Reply-To: contact@tedxyouthlafayette.com' . "\r\n" .
     'X-Mailer: PHP/' . phpversion();
    mail($email, $subject, $message, $headers);
    echo "Registration done successfully.<br />";
}

$req = mysql_query("SELECT MAX(id) AS id_max FROM users");
$data = mysql_fetch_array($req);
$places_restantes = 100 - intval($data["id_max"]);
echo "There are still $places_restantes places.";
if($data['id_max'] <= 100)
{
echo '<form method="post" action="">';
echo '<label>Name :</label><input type="text" name="name">*<br />';
echo '<label>First name :</label><input type="text" name="first_name">*<br />';
echo '<label>Email :</label><input type="text" name="email">*<br />';
echo '<label>Date of birth :</label><input type="text" name="date">*<br />';
echo '<label>Phone number :</label><input type="text" name="numero">*<br />';
echo '<label>Occupation :</label><input type="text" name="occupation"><br />';
echo '<label>Twitter :</label><input type="text" name="twitter"><br />';
echo '<label>Leave a message for the team :</label><br /><textarea name="team_message"></textarea><br />';
echo '<label>Captcha here</label><br /><input>*<br />';
echo '<input type="submit" value="Valider"><br />';
echo '</form>';
echo 'Notice : Fields with a star "*" are mandatory.';
}
else
    echo "Registration closed.";

<?php mysql_close($connect);?>