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 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57
| <?php require_once 'connexion.php';
session_start();
if (isset($_SESSION['id_membre']) AND isset($_SESSION['pseudo'])){
//On vérifie si la variable existe et sinon elle vaut NULL
$num = isset($_POST['num']) ? $_POST['num'] : NULL;
$client = isset($_POST['client']) ? $_POST['client'] : NULL;
$designation = isset($_POST['designation']) ? $_POST['designation'] : NULL;
$quantite = isset($_POST['quantite']) ? $_POST['quantite'] : NULL;
$prixht = isset($_POST['prixht']) ? $_POST['prixht'] : NULL;
$datefacture = isset($_POST['datefacture']) ? $_POST['datefacture'] : NULL;
$facturede = isset($_POST['facturede']) ? $_POST['facturede'] : NULL;
$conditions = isset($_POST['conditions']) ? $_POST['conditions'] : NULL;
$numtva = isset($_POST['numtva']) ? $_POST['numtva'] : NULL;
$id_membre= $_SESSION['id_membre'];
$req1 = $base->prepare('UPDATE infosfacture
SET num = :num,
numtva = :numtva,
client = :client,
datefacture = :datefacture,
facturede = :facturede,
conditions = :conditions,
id_membre= :id_membre
WHERE id= :?');
$req1->bindParam(':num', $_POST['num'], PDO::PARAM_STR);
$req1->bindParam(':numtva', $_POST['numtva'], PDO::PARAM_STR);
$req1->bindParam(':client', $_POST['client'], PDO::PARAM_STR);
$req1->bindParam(':datefacture', $_POST['datefacture'], PDO::PARAM_STR);
$req1->bindParam(':facturede', $_POST['facturede'], PDO::PARAM_STR);
$req1->bindParam(':conditions', $_POST['conditions'], PDO::PARAM_STR);
$req1->bindParam(':id_membre', $_SESSION['id_membre'], PDO::PARAM_INT);
$req1->execute();
$req2 = $base->prepare('UPDATE facturation
SET designation = :designation,
quantite = :quantite,
prixht = :prixht
WHERE fk_facturation_id= ?');
$req2->bindParam(':designation', $_POST['designation'], PDO::PARAM_STR);
$req2->bindParam(':quantite', $_POST['quantite'], PDO::PARAM_STR);
$req2->bindParam(':prixht', $_POST['prixht'], PDO::PARAM_STR);
$req2->execute();
echo 'La facture n° '.$num.' a bien été mise à jour ';
<?
}
else {
echo 'Vous n\'êtes pas connecté.';
}
?> |
Partager