Advertisement
Guest User

Untitled

a guest
Apr 27th, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.28 KB | None | 0 0
  1. <?php
  2. session_start();
  3. try
  4. {
  5.     $bdd = new PDO('mysql:host=localhost;dbname=cinema;charset=utf8', 'root', '');
  6. }
  7. catch(Exception $e)
  8. {
  9.     die("Erreur:" . $e->getMessage());
  10. }
  11.  
  12. $req=$bdd->prepare('INSERT INTO film(Titre, DateDeSortie, Genre) Values(:NomFilm, :DateDeSortie, :GenreFilm)');
  13.  
  14. $req->execute(array('NomFilm'=>$_POST['NomFilm'],'DateDeSortie'=>$_POST['DateDeSortie'], 'GenreFilm'=>$_POST['GenreFilm']));
  15.  
  16.  
  17. if ($req) {
  18.     $_SESSION['message'] = "insertion ok";
  19.     header('Location:index.php');
  20. } else {
  21.     $_SESSION['message']="Insertion Pas ok";
  22.     header ('Location:index.php');
  23. }
  24.  
  25. ?>
  26.  
  27.  
  28. <?php
  29.  
  30. try
  31. {
  32.     $bdd = new PDO('mysql:host=localhost;dbname=cinema;charset=utf8', 'root', '');
  33. }
  34. catch(Exception $e)
  35. {
  36.     die("Erreur:" . $e->getMessage());
  37. }
  38.  
  39. $req=$bdd->prepare('INSERT INTO personnes(Nom,Prenom, DateDeNaissance, Nationalite) Values(:Nom, :Prenom, :DateDeNaissance, :Nationalite)');
  40.  
  41. $req->execute(array('Nom'=>$_POST['Nom'],'Prenom'=>$_POST['Prenom'], 'DateDeNaissance'=>$_POST['DateDeNaissance'], 'Nationalite'=>$_POST['Nationalite']));
  42.  
  43.  
  44. if ($req) {
  45.     $_SESSION['message'] = "insertion ok";
  46.     header('Location:index.php');
  47. } else {
  48.     $_SESSION['message']="Insertion Pas ok";
  49.     header ('Location:index.php');
  50. }
  51.  
  52.  
  53.  
  54.  
  55.  
  56. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement