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
| <?php
session_start();
include_once('cnx.php');
$date = date("d-m-Y");
$heure = date("H:i");
include_once('head.php');
?>
<div id="menu2">
<ul>
<!-- Texte Menu droit de la page à modifier -->
<li><a href="espace_dpm.php" title=""> Page d'accueil </a></li>
<li><a href="consulter_eta_dpm.php" title="">Consulter données</a></li>
<li><a href="compte_dpm.php" title="">Modifier votre compte</a></li>
<li><a href="authentification.php?deco=1" title="">Se déconnecter</a></li>
</ul>
</div>
<div id="page">
<h1>Resultat de recherche </h1>
<?php
// Connect to the server.
set_time_limit(0);
include_once('cnx.php');
if (!$conn)
die( print_r( sqlsrv_errors(), true));
// Define and execute the query.
// Note that the query is executed with a "scrollable" cursor.
$_SESSION['n']=$_POST["n"];
$_SESSION['m']=$_POST["m"];
$_SESSION['cm']=$_POST["cm"];
$_SESSION['cd']=$_POST["cd"];
$_SESSION['c']=$_POST["c"];
$_SESSION['d']=$_POST["d"];
$_SESSION['e']=$_POST["Designation_Entite"];
$n=$_SESSION['n'];
$m= $_SESSION['m'];
$cm=$_SESSION['cm'];
$cd=$_SESSION['cd'];
$c=$_SESSION['c'];
$d= $_SESSION['d'];
$e= $_SESSION['e'];
$sql = "Select * from V_ETA where Date_Vente Between '".$c."' and '".$d."' ";
if($m!=''){
$sql = $sql. " and Nom_Acheteur like '".$m."' ";
}
if($cm!=''){
$sql = $sql. " and Code_Acheteur='".$cm."' ";
}
if($n!=''){
$sql =$sql. " and Vendeur like '%".$n."%' ";
}
if($cd!=''){
$sql =$sql. " and Code_Vendeur='".$cd."' ";
}
if($e!=-1){
$sql = $sql. " and libelle='".$e."' ";
}
$sql = $sql. " order by Nom_Acheteur ,Code_Acheteur,Vendeur,Code_Vendeur,Date_Vente,libelle";
echo $sql;
$ress=$sql;
$stmt = sqlsrv_query($conn, $ress, array(), array( "Scrollable" => 'static' ));
if ( !$stmt )
die( print_r( sqlsrv_errors(), true));
// Get the total number of rows returned by the query.
// Display links to "pages" of rows.
function getPage($stmt, $pageNum, $rowsPerPage)
{
$offset = ($pageNum - 1) * $rowsPerPage;
$rows = array();
$i = 0;
while(($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_NUMERIC, SQLSRV_SCROLL_ABSOLUTE, $offset + $i)) && $i < $rowsPerPage)
{
array_push($rows, $row);
$i++;
}
return $rows;
}
// Set the number of rows to be returned on a page.
$rowsPerPage = 10;
$rowsReturned = sqlsrv_num_rows($stmt);
if($rowsReturned === false)
die( print_r( sqlsrv_errors(), true));
elseif($rowsReturned == 0)
{
echo "No rows returned.";
exit();
}
else
{
// Display page links.
$numOfPages = ceil($rowsReturned/$rowsPerPage);
for($i = 1; $i<=$numOfPages; $i++)
{
$pageLink = "?pageNum=$i";
print("<a href=$pageLink>$i</a> ");
}
echo "<br/><br/>";
}
// Display the selected page of data.
echo "<table border='1px'>";
echo "<tr><td>Code Entité</td><td>Désignation Entité</td><td>Code Mareyeur</td><td>Nom Marayeur</td><td>Poids Acheté</td><td>Poids Vendu</td></tr>";
$pageNum = isset($_GET['pageNum']) ? $_GET['pageNum'] : 1;
$page = getPage($stmt, $pageNum, $rowsPerPage);
foreach($page as $row)
echo "<tr><td>$row[0]</td><td>$row[1]</td><td>$row[6]</td><td>$row[7]</td></tr>";
echo "</table>";
sqlsrv_close( $conn );
?>
</div>
<div id="footer"> Copyright © <a href="index.php">GESTION DE TRACABILITE DES PRODUITS DE LA MER </a> | Designed by| <a href="www.onp.co.ma/">ONP</a> </div>
</div>
</body>
</html> |
