INSERT en mysqli ds ma db

Bonjour, je début en informatique j'aimerais faire un formulaire signup mais je n'arrive pas a entrer mes variables POST dans ma db

voici mon form :

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
<!-- signupform Modal -->
        <div id="id02" class="modal">
          <span onclick="document.getElementById('id02').style.display='none'" class="close" title="Close Modal">&times;</span>
 
          <!-- Modal Content -->
          <form class="modal-content animate" action="form/signup1.php" method="post">
            <div class="imgcontainer">
              <img src="img_avatar2.png" alt="Avatar" class="avatar">
            </div>
 
            <div class="container">
 
              <label for="pseudo"><b>Pseudo</b></label>
                <input type="text" placeholder="pseudo" name="pseudo" required>
 
                <label for="email"><b>E-mail</b></label>
                <input type="email" placeholder="E-mail" name="email" required>
 
              <label for="psw"><b>Password</b></label>
                <input type="password" placeholder="Password" name="psw" required>
 
                <label for="rpsw"><b>Repassword</b></label>
                <input type="password" placeholder="Repassword" name="rpsw" required>
 
              <label for="firstname"><b>Prénom</b></label>
                <input type="text" placeholder="firstname" name="firstname" required>
 
                <label for="lastname"><b>Nom</b></label>
                <input type="text" placeholder="Name" name="lastname" required>
 
              <button type="submit">Login</button>
 
            </div>
 
            <div class="container" style="background-color:#f1f1f1">
              <button type="button" onclick="document.getElementById('id02').style.display='none'" class="cancelbtn">Cancel</button>
              <span class="psw">Forgot <a href="#">password?</a></span>
            </div>
          </form>
        </div>

et voici mon PHP:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
<?php
  if(!isset($_POST['pseudo']) && !isset($_POST['psw']) && !isset($_POST['email']) && !isset($_POST['lastname']) && !isset($_POST['firstname']))
  {
 
    echo "<script type='text/javascript'>alert('formulaire nn transmis');</script>";
  }
 
  echo "<script type='text/javascript'>alert('formulaire transmis');</script>";
 
  $servername = "127.0.0.1";
  $username = "root";
  $password = " ";
  $dbname = "test";
  // connection db
  $conn = mysqli_connect($servername, $username, $password, $dbname);
 
    // Check connection
      if (mysqli_connect_errno())
      {
        echo "<script type='text/javascript'>alert('echec de connexion a la db');</script>" .mysqli_connect_errno();
      }
      else {
      echo "<script type='text/javascript'>alert('connexion db ok');</script>";
 
 
 
      $insert = 'INSERT INTO user (login, password, email, name, firstname) VALUES("'.$_POST['pseudo'].'", "'.$_POST['psw'].'", "'.$_POST['email'].'", "'.$_POST['lastname'].'", "'.$_POST['firstname'].'")';
 
      $result = mysqli_query($conn, $insert) or die ('Erreur SQL !'.$sql.'<br />'.mysqli_error());
 
      mysqli_close($conn);
 
 
      echo "<script type='text/javascript'>alert('Inscription réussie');</script>";
      //header("Location: /index.php");
      }
 
      //echo "<script type='text/javascript'>alert('Inscription non réussie');</script>";
 
?>

je pense que c'est une erreure de syntax mais sans plus :s
quelqu'un sait m'aider?