Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <head>
- <title>Ajouter un membre</title>
- <meta charset='UTF-8'>
- <link rel="stylesheet" type="text/css" href="style.css" />
- </head>
- <body>
- <form action="" method="post">
- <table class="add">
- <th>Ajouter une entrée dans la table</th>
- <tr><td>first_name</td> <td><input type="text" name="first_name"></td></tr>
- <tr><td>middle_name</td> <td><input type="text" name="middle_name"></td></tr>
- <tr><td>last_name</td> <td><input type="text" name="last_name"></td></tr>
- <tr><td>contact #1</td> <td><input type="text" name="contact" ></td></tr>
- <tr><td>email_address</td> <td><input type="text" name="email" ></td></tr>
- <tr><td><input type="submit"></td></tr>
- </table>
- </form>
- </body>
- <?php
- $errors = array();
- extract($_POST); //On prend les valeurs du formulaire
- if(!empty($first_name) and !empty($middle_name) and !empty($last_name) and !empty($contact) and !empty($email)) //si les champs ne sont pas vides
- {
- require_once('db.php'); //connexion a la BDD
- $req = $bdd->prepare('INSERT INTO tbi_contacts (first_name, middle_name, last_name, contact, email) VALUES (:firstname,:middlename,:lastname,:contact,:email)'); // requete
- print_r($req);
- $req->bindParam(':firstname', $first_name, PDO::PARAM_STR); // on link les valeurs
- $req->bindParam(':middlename', $middle_name, PDO::PARAM_STR); // on link les valeurs
- $req->bindParam(':lastname', $last_name, PDO::PARAM_STR); // on link les valeurs
- $req->bindParam(':contact', $contact, PDO::PARAM_STR); // on link les valeurs
- $req->bindParam(':email', $email, PDO::PARAM_STR); // on link les valeurs
- $req->execute();
- /*array(
- 'first_name' => $first_name,
- 'middle_name' => $middle_name,
- 'last_name' => $last_name,
- 'contact' => $contact,
- 'email' => $email,
- ));*/
- /*$first_name,
- $middle_name,
- $last_name,
- $contact,
- $email,
- )); */
- var_dump($first_name);
- echo "OK";
- echo '<br/>' . '<a href="address_book.php">' . 'Retour' .'</a>';
- }
- else
- $errors['empty'] = "Un des champs est vide";
- if ($errors)
- {
- foreach($errors as $num_errors)
- {
- echo $num_errors . '<br />';
- echo '<br/>' . '<a href="address_book.php">' . 'Retour' .'</a>';
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement