Untitled

<?php
session_start();
if(isset($_SESSION['connected'])){header('Location: welcome.php');}
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "projetphp";
?>

<html>
<head><title>Inscription</title></head>
<body>

  <center>
	<h1 class="text1"> S'inscrire sur Naruto Streaming</h1>
<meta charset="UTF-8"><link rel="stylesheet" href="stylesheet.css">
<form action ="inscription.php" method="POST" class="text3">
  email: <br/><input type="text" name="email" /><br>
  password:  <br/><input type="password" name="password" /><br><br>
  <input type="submit" name="Connexion"/>
 </form>
 <br><br><p class="text5">Déjà inscrit ? <a href="login.php" class="text1">Se connecter</a></p><br>
 <p><a href="index.php" class="text1">Revenir au menu principal</a></p>

</center></body></html>

<?php

if (isset($_POST['email']) && isset($_POST['password'])){

	$email = htmlspecialchars($_POST['email']);
	$pass = sha1($_POST['password']);

  if (strlen($_POST['password']) < 8){die("<div class='error'>Mot de passe trop court</div>");}
  if (!preg_match("#[0-9]+#", $_POST['password'])){die("<div class='error'>Votre mot de passe doit contenir au moins un chiffre</div>");}
  if (!preg_match("#[a-zA-Z]+#", $_POST['password'])){die("<div class='error'>Votre mot de passe doit contenir au moins une lettre</div>");}
  if (!filter_var($email, FILTER_VALIDATE_EMAIL)){die("<div class='error'>Veuillez entrer un email valide</div>");}


	// Create connection
    $conn = new mysqli($servername, $username, $password, $dbname);
    // Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }


    $sql2 = "SELECT * FROM logs WHERE email like '".$email."'";
    $result = mysqli_query($conn, $sql2);
    $row=mysqli_fetch_assoc($result);

    if(mysqli_num_rows($result) == 0){
            $sql = "INSERT INTO logs (email, pass) VALUES ('$email', '$pass')";

  	  	if ($conn->query($sql) === TRUE) {
			echo "<div class='succes'><center>Nouvel utilisateur enregistré !</center><br></div>";
   			echo "<div class='succes'><center>Cliquez ici pour vous connecter : <a href='login.php' class='succes'>Se connecter</a></center></div>";

		} else {
        echo "Error: " . $sql . "<br>" . $conn->error;
    		}
        $conn->close();
    }
    else{die("<div class='error'>Email deja utilisé</div>");}
}

?>