php
Posté : 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);
?>