inscription.php

<?php

    $connection=mysqli_connect("localhost","root","","pfa");
    if($connection==false) echo "pas de connexion";

    if(!empty($_POST)){

        if(!empty($_POST['prenom']) && isset($_POST['prenom']) && !empty($_POST['nom']) && isset($_POST['nom']) && isset($_POST['adresse']) && !empty($_POST['adresse']) && !empty($_POST['ville']) && isset($_POST['ville']) && !empty($_POST['tel']) && isset($_POST['tel']) && !empty($_POST['email']) && isset($_POST['email']) )
        {


            $firstname = $_POST['prenom'];
            $lastname = $_POST['nom'];
            $address = $_POST['adresse'];
            $town = $_POST['ville'];
            $tel = $_POST['tel'];
            $email = $_POST['email'];

            $sql = "INSERT INTO client VALUES (null, '$firstname', '$lastname', '$address', '$town', '$tel', '$email') ";

            $request = mysqli_query($connection, $sql);

            if(!$request){

                printf("Erreur d'enregistrement %s", mysqli_error($connection));
                die();
            }

            header("Location: tablclient.php");
            die();


        }


    }

    mysqli_close($connection);

?>


<html>
<head><title>Formulaire d'Inscription </title></head>
<body>

<form action="" method="post">
<table border="1" align="center">
<tr><th colspan="2">inscrire</th></tr>
<tr><td>Prenom </td><td><input type="text" name="prenom"></td></tr>
<tr><td>Nom </td><td><textarea name="nom"></textarea></td></tr>
<tr><td>Adress </td><td><textarea name="adresse"></textarea></td></tr>
<tr><td>ville </td><td><textarea name="ville"></textarea></td></tr>

<tr><td>Tel </td><td><input type="text" name="tel"></td></tr>
<tr><td>Email </td><td><input type="text" name="email"></td></tr>

</select></td></tr>
<tr align="center"><td><input type="submit" value="Valider"></td><td><input type="reset" value="Annuler"></td></tr>
</table>
</form>
</body>
</html>