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 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160
| <?php require_once('Connections/cnx3.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$currentPage = $_SERVER["PHP_SELF"];
$maxRows_Recordset1 = 10;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
$pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;
// si venant du FORMULAIRE
if(isset($_POST['combo3'])){
$combo3 = $_POST['combo3'];
}
// venant de la PAGINATION (via URL)
elseif(isset($_GET['combo3'])){
$combo3 = urldecode($_GET['combo3']);
}
else {
$combo3 = ''; // (valeur par defaut)
}
// --------------------------
if(isset($_POST['combo4'])){ // si venant du FORMULAIRE
$combo4 = $_POST['combo4'];
}
elseif(isset($_GET['combo4'])){ // si venant du FORMULAIRE
$combo4 = urldecode($_GET['combo4']);
}
else {
$combo4 = ''; // (valeur par defaut)
}
// Pour utilisation dans une REQUÊTE SQL -> PROTECTION CONTRE injection SQL
$combo3_bd = mysql_real_escape_string($combo3);
$combo4_bd = mysql_real_escape_string($combo4);
// => CE SONT CES VARIABLES $combo3_bd ET $combo4_bd qu'il faut utiliser dans LA REQUÊTE !
// --------------------------
mysql_select_db($database_cnx3, $cnx3);
$query_Recordset1 = "SELECT SUM( quantite ) AS SOMME, nom
FROM lignescommande a, commande b, client c
WHERE a.id_cmd = b.id_cmd
AND b.id_cl = c.id_cl
AND date BETWEEN '$combo3_bd' AND '$combo4_bd'
GROUP BY c.id_cl";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $cnx3) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
if (isset($_GET['totalRows_Recordset1'])) {
$totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
$all_Recordset1 = mysql_query($query_Recordset1);
$totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
$queryString_Recordset1 = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_Recordset1") == false &&
stristr($param, "totalRows_Recordset1") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_Recordset1 = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Les Clients2</title>
<link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body>
<div class="globale">
<div class="entete">
</div><!-- division entête !-->
<?php require_once("menuH.php")?>
<!-- menu guache !-->
<?php require_once("menuGuache.php")?>
<div class="contenu">
<center>
<table border="3">
<tr>
<td>NOM</td>
<td>QUANTITE</td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_Recordset1['nom']; ?></td>
<td><?php echo $row_Recordset1['SOMME']; ?></td>
</tr>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>
<?php $transmission_variables = '&combo3='.urlencode($combo3).'&combo4='.urlencode($combo4);
?>
<p>
<a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, 0, $queryString_Recordset1).$transmission_variables; ?>">Premier</a>
<a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, max(0, $pageNum_Recordset1 - 1), $queryString_Recordset1).$transmission_variables; ?>">Précédent</a>
<a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, min($totalPages_Recordset1, $pageNum_Recordset1 + 1), $queryString_Recordset1).$transmission_variables; ?>">Suivant</a>
<a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, $totalPages_Recordset1, $queryString_Recordset1).$transmission_variables; ?>">Dernier</a>
</p>
</center>
</div>
<!-- division contenu !-->
<!-- menu droite !-->
<?php require_once("menuDroite.php")?>
<!-- pied !-->
<?php require_once("pied1.php")?>
</div> <!-- division globale !-->
</body>
</html>
<?php
mysql_free_result($Recordset1);
?> |