Forum d'entraide PHPFrance

par **gallaye** » 04 juil. 2018, 16:34

bonjour j'ai crée un formulaire et je veux enregistrer les données dur la base donnée mais j'y arrive pas je voudrai de l'aide svp
 
ma page index.php
namespace location\dao
    {
 
        use \PDO;
 
        //Classe caisseprevisionnelle
 
        class caisseprevisionnelle{
            private $_id;
            private $_numsnd;
            private $_numbcda;
            private $_detadepart;
            private $_dateretour;
            private $_mission;
            private $_site;
            private $_itinerairederoute;
            private $_region;
            private $_numsnc;
            private $_client;
            private $_buisnessline;
 
            // constructeur de la classe
 
            public function __construct($id, $numsnd, $numbcda, $detadepart, $datederetour, $mission, $site, $itinerairederoute, $region, $numsnc, $client){
                $this->_id = $id;
                $this->_numsnd = $numsnd;
                $this->_numbcda = $numbcda;
                $this->_detadepart = $detadepart;
                $this->_dateretour = $datederetour;
                $this->_mission = $mission;
                $this->_site = $site;
                $this->_itinerairederoute = $itinerairederoute;
                $this->_region = $region;
                $this->_numsnc = $numsnc;
                $this->_client = $client;
                $this->_buisnessline = $buisnessline;
            }
 // accesseurs de la classe
 
            public function id(){
                return $this->_id;
            }
 
            public function numsnd(){
                return $this->_numsnd;
            }
 
            public function numbcda(){
                return $this->_numbcda;
            }
 
            public function detadepart(){
                return $this->_detadepart;
            }
 
            public function datederetour(){
                return $this->_dateretour;
            }
 
            public function mission(){
                return $this->_mission;
            }
 
            public function site(){
                return $this->_site;
            }
 
            public function itinerairederoute(){
                return $this->_itinerairederoute;
            }
 
            public function region(){
                return $this->_region;
            }
 
            public function numsnc(){
                return $this->_numsnc;
            }
 
            public function client(){
                return $this->_client;
            }
 
            public function buisnessline(){
                return $this->_buisnessline;
            }
 
       
// classe qui gère les caisseprevisionnelle
 
        class gestioncaisseprevisionnelle{
            private $_bdd;
 
            // constructeur de la classe
 
            public function __construct(PDO $bdd){
                $this->_bdd  = $bdd;
            }
 
            //methode qui enregistre un caisseprevisionnelle
 
            public function add(caisseprevisionnelle $u){
                $sql = $this->_bdd->prepare("INSERT INTO caisseprevisionnelle VALUES (null, :numsnd, :numbcda, :detadepart, :datederetour, :mission, :site, :itinerairederoute, :region, :numsnc, :client, :buisnessline)");
                $sql->execute(array(
                    'numsnd' => $u->numsnd(),
                    'numbcda' => $u->numbcda(),
                    'detadepart' => $u->detadepart(),
                    'datederetour' => $u->datederetour(),
                    'mission' => $u->mission(),
                    'site' => $u->site(),
                    'itinerairederoute' => $u->itinerairederoute(),
                    'region' => $u->region(),
                    'numsnc' => $u->numsnc(),
                    'client' => $u->client(),
                    'buisnessline' => $u->buisnessline()
                ));
            }
    }
le formulaire
<!DOCTYPE html>
<html>
<head>
    <title>inscription-gestion-location</title>
 
    <!-- link bootstrap -->
 
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta.2/css/bootstrap.min.css">
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css">
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.6/umd/popper.min.js"></script>
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta.2/js/bootstrap.min.js"></script>
 
</head>
<body style="background-image: url('../images/BusinessPartners.jpg'); background-size: cover;">
 
    <div class="container">
        <br>
        <center>
            <div id="connexion" style="width: 600px;">
            <div class="card" style="background: rgba(0,0,0,0.5);">
                  <div class="card-body">
                    <a href=""><i class="fa fa-home fa-5x" aria-hidden="true" style="float: left; color: white;"></i></a><br>
                    <center><h1 class="text-primary">Page d'inscription</h1><br></center>
                    <form method="POST" action="">
                        <div class="form-group row">
                            <label class="col-lg-3 col-form-label"><B>Numero SND :</B></label>
                            <input type="text" class="form-control col-lg-8" name="numsnc"  placeholder="">
                        </div>
                        <div class="form-group row">
                            <label class="col-lg-3 col-form-label"><B>Numero bcda :</B></label>
                            <input type="text" class="form-control col-lg-8" name="numbcda"  placeholder="">
                        </div>
                        <div class="form-group row">
                            <label class="col-lg-3 col-form-label"><B>date depart :</B></label>
                            <input type="date" class="form-control col-lg-8" name="datededepart" placeholder="">
                        </div>
                        <div class="form-group row">
                            <label class="col-lg-3 col-form-label"><B>date retour :</B></label>
                            <input type="date" class="form-control col-lg-8" name="datederetour" placeholder="">
                        </div>
                        <div class="form-group row">
                            <label class="col-lg-3 col-form-label"><B>mission :</B></label>
                            <input type="text" class="form-control col-lg-8" name="mission" placeholder="">
                        </div>
                        <div class="form-group row">
                            <label class="col-lg-3 col-form-label"><B>site :</B></label>
                            <input type="text" class="form-control col-lg-8" name="site" placeholder="">
                        </div>
                        <div class="form-group row">
                            <label class="col-lg-3 col-form-label"><B>itineraire de route :</B></label>
                            <input type="text" class="form-control col-lg-8" name="itinerairederoute" placeholder="">
                        </div>
                        <div class="form-group row">
                            <label class="col-lg-3 col-form-label"><B>region :</B></label>
                            <select class="form-control col-lg-8" name="region">
                              <option value=""></option>
                              <option value="Dakar">Dakar</option>
                              <option value="Louga">Louga</option>                   
                            </select>                    
                            </div>
                        <div class="form-group row">
                            <label class="col-lg-3 col-form-label"><B>numero snc :</B></label>
                            <input type="text" class="form-control col-lg-8" name="numsnc" placeholder="">
                        </div>
                        <div class="form-group row">
                            <label class="col-lg-3 col-form-label"><B>client :</B></label>
                            <input type="text" class="form-control col-lg-8" name="client" placeholder="">
                        </div>
                        <div class="form-group row">
                            <label class="col-lg-3 col-form-label"><B>buisness line :</B></label>
                            <input type="text" class="form-control col-lg-8" name="buisnessline" placeholder="">
                        </div>
                      
                        <center>
                            <input type="submit" name="inscription" class="btn btn-primary" value="Enregistrer"><br><br>
                        </center>                     
                       
                    </form>
                </div>
                <center>
                    <?php
 
                        require 'index.php';
 
                        use location\dao\caisseprevisionnelle;
                        use location\dao\gestioncaisseprevisionnelle;
 
                        include 'db.php';
 
                        extract($_POST);
                        if (isset($inscription)) {
                            if ($numsnc == "" || $numbcda == "" || $datederetour == "" || $datederetour =="" || $mission =="" || $site =="" || $itinerairederoute =="" || $region =="" || $numsnc =="" || $client =="" || $buisnessline =="") {
                                echo "<span class='alert alert-danger'>Veuillez saisir tous les champs</span>";
                            }
                            else{
                                $u = new caisseprevisionnelle(0, $numsnc, $numbcda, $datederetour, $datederetour, $mission, $site, $itinerairederoute, $region, $numsnc, $clien, $buisnessline);
                                $gestion = new gestioncaisseprevisionnelle($db);
                                $gestion->add($u);
                                echo "<span class='alert alert-secondary'>Utilisateur ajouté avec succés</span>";
                              
                            }
                        }
                    ?>
                </center>
                <br><br>.
            </div>
        </div>
        </center>
    </div>
 
</body>
</html>
 
 
connexion dans la base de donnée
<?php
$db = new PDO('mysql:host=localhost;dbname=camusat', 'root', 'root');
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
 ?>

php

Répondre

Étendre la vue Revue du sujet : php

php