<?php
include "session.php";
include "db.php";
if (!empty($_GET['add']))
{
array_push($_SESSION['cart'], $_GET['add']);
header("Location: {$_SERVER['PHP_SELF']}");
}
if (!empty($_GET['del']))
{
foreach ($_SESSION['cart'] as $element)
{
if ($element == $_GET['del'])
$_SESSION['cart'] = delete_element($element, $_SESSION['cart']);
}
header("Location: {$_SERVER['PHP_SELF']}");
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<link rel="icon" href="favicon.ico">
<title>Mercuriale</title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css">
<link rel="stylesheet" href="https://cdn.datatables.net/1.10.9/css/dataTables.bootstrap.min.css">
<link href="css/mercuriale.css" rel="stylesheet">
<script src="http://getbootstrap.com/assets/js/ie-emulation-modes-warning.js"></script>
<script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
<script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
</head>
<body>
<header id="logo">
<a href="index.php"><img src="image/header.png"></a>
</header>
<?php
if (count($_SESSION['cart']) > 0) {
$condition = " WHERE code_article IN (";
foreach ($_SESSION['cart'] as $element)
$condition .= $element.',';
$condition = substr($condition,0, -1);
$condition .= ")";
$requete = $bdd->prepare("SELECT DISTINCT code_article, designation, fournisseur, marque, unite_commande, prix_ht, quantite FROM essais
$condition ORDER BY prix_ht asc");
$requete->execute();
}
else {
$requete = $bdd->prepare("SELECT DISTINCT code_article, designation, fournisseur, marque, unite_commande, prix_ht, quantite FROM essais where code_article=-1");
$requete->execute();
}
$results = $requete->fetchAll(PDO::FETCH_ASSOC);
?>
<section class="main" >
<div class="container-fluid middle">
<nav class="navbar">
<div class="container-fluid">
<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
</div>
<div id="navbar" class="navbar-collapse collapse">
<ul class="nav navbar-nav">
<li class="active"><a href="./mercuriale.php"><i class='glyphicon glyphicon-list-alt'></i> Liste recherche</a></li>
</ul>
<ul class="nav navbar-nav navbar-right">
<li><a href="BC.php"><i class='glyphicon glyphicon-shopping-cart'></i> Bon de Commande</a></li>
<li class="dropdown">
<ul class="dropdown-menu">
</ul>
</li>
</ul>
</div>
</div>
</nav>
<div class="col-xs-12 col-md-8 col-md-offset-2" id="resulat">
<table id="tarif" class="table table-striped table-hover" cellspacing="0" width="100%">
<thead>
<tr>
<th>Code Article</th>
<th>Désignation</th>
<th>Fournisseur</th>
<th>Marque</th>
<th>Unité de commande</th>
<th>Prix</th>
<th>Quantité</th>
<th class="hidden-print">Selection</th>
</tr>
</thead>
<tbody>
<?php
foreach($results as $result){
echo "<tr>";
echo " <td>{$result['code_article']}</td>";
echo " <td>{$result['designation']}</td>";
echo " <td>{$result['fournisseur']}</td>";
echo " <td>{$result['marque']}</td>";
echo " <td>{$result['unite_commande']}</td>";
$prix = explode('.', $result['prix_ht']);
echo " <td>$prix[0]€$prix[1]</td>";
echo " <td>{$result['quantite']}</td>";
echo " <td class='center hidden-print'><a href='{$_SERVER['PHP_SELF']}?del={$result['code_article']}'><i class='glyphicon glyphicon-minus'></i></a></td>";
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>
</section>
<script type="text/javascript" src="https://code.jquery.com/jquery-1.11.3.min.js"></script>
<script type="text/javascript" src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/js/bootstrap.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/1.10.9/js/jquery.dataTables.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/1.10.9/js/dataTables.bootstrap.min.js"></script>
<script>
$(document).ready(function(){
$('#tarif').DataTable( {
language: {
"sProcessing": "Traitement ...",
"sSearch": "Rechercher :",
"sLengthMenu": "Afficher _MENU_ éléments",
"sInfo": "_START_ à _END_ / _TOTAL_ ",
"sInfoEmpty": "0 à 0 sur 0 éléments",
"sInfoFiltered": "(filtré de _MAX_ éléments au total)",
"sInfoPostFix": "",
"sLoadingRecords": "Chargement en cours...",
"sZeroRecords": "Aucun élément à afficher",
"sEmptyTable": "Aucune donnée disponible dans le tableau",
"oPaginate": {
"sFirst": "Premier",
"sPrevious": "Précédent",
"sNext": "Suivant",
"sLast": "Dernier"
},
"oAria": {
"sSortAscending": ": activer pour trier la colonne par ordre croissant",
"sSortDescending": ": activer pour trier la colonne par ordre décroissant"
}
},
"lengthMenu": [ [10, 25, 50, -1], [10, 25, 50, "Tout"] ]
});
});
</script>
<footer>
<p><img src="image/footer1.png"></p>
</footer>
</body>
</html>
voici le code modifié , je n'ai plus de message d'erreur , j'ai bien ma colonne "quantité" , le contenu de ma bd n'est pas affiché par contre .
la quantité je voudrai la noté manuellement sur mon tableau et lorsque je vais sur "bon de commande" en passant par ma session , le calcul "quantité"x"unité de commande" se fasse .
Merci
