Untitled

<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <link rel="stylesheet" type="text/css" href="/css/style.css">
  <title>Wyrm</title>
</head>
<body>
<?php
$user = "root";
$host = "localhost";
$password = "";
$database = "utilisateur";
$connexion = mysqli_connect($host, $user, $password);
$db = mysqli_select_db($connexion, $database);

if(isset($_POST['Inscriptione'])) {

$nom =  $_POST['nom'];
$prenom =  $_POST['prenom'];
$datenaissance = $_POST['datenaissance'];
$adressemail =  $_POST['adressemail'];
$password =  $_POST['password'];
$tel =  $_POST['tel'];
$ville =  $_POST['ville'];
$sexe =  $_POST['sexe'];
$newsletter =  $_POST['newsletter'];


if((!empty($_POST['nom'])) AND (!empty($_POST['prenom'])) AND (!empty($_POST['adressemail'])) AND (!empty($_POST['password'])) AND (!empty($_POST['tel'])) AND (!empty($_POST['ville'])) AND (!empty($_POST['datenaissance']))) {


  $query = "INSERT INTO utilisateur(idutilisateur, Prenom, Nom, adressemail, datenaissance, mdp, tel, ville) VALUES('', $prenom, $nom, $adressemail, $datenaissance, $mdp, $tel, $ville)";
  if (mysqli_query($db,$query)) {
    echo "New record created successfully";
} else {
    echo "Error: " . $db . "<br>" . mysqli_error($connexion);
}
  }
}

?>
		<div id="menu">
  <ul>
    <li><img  onclick="window.open('/compte/connexion.php', '_blank')" class="connexion" src="/img/login.png"></li>
  	<li><img class="logo" src="/img/logo.png"></li>
    <li><a href="index.php"><b>Accueil</b></a></li>
    <li><a href="evenement.php"><b>Annonces</b></a></li>
  </ul>
    </div>


    <div id="blocmilieu">    </div>
    <div id="blocco">
    <h2>Inscrivez-vous </h2>
    <br /><br /><br />
    <form method="POST" action="">
    <label for="nom">Nom :</label><input type="text" name="nom" /><p></p>
    <label for="prenom">Prénom :</label><input type="text" name="prenom" /><p></p>
    <label for="Adressemail">Adresse e-mail :</label><input type="email" name="adressemail"><p></p>
    <label for="password">Mot de passe :</label><input type="password" name="password"><p></p>
    <label for="tel">Téléphone :</label><input type="tel" name="tel"><p></p>
    <label for="ville">Ville</label><input type="text" name="ville"><p></p>
    <label for="date">Date de Naissance :</label><input type="date" name="datenaissance"><p></p>

    <input type="button" name="Inscriptione" value="Inscription"></form>
            <br /><br />
    Connectez-vous en cliquant <a href="/compte/connexion.php">ici</a>
    </div>


    <div id="footer">
      <p>Wyrm  ©  | Tous droits réservés</p>
    </div>
</body>
</html>