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
| <?php
include('secure.php');
require_once('Connections/connection.php'); ?>
<?php
print_r($_POST);
$currentPage = $HTTP_SERVER_VARS["PHP_SELF"];
$maxRows_rscli = 11;
$pageNum_rscli = 0;
if (isset($HTTP_GET_VARS['pageNum_rscli'])) {
$pageNum_rscli = $HTTP_GET_VARS['pageNum_rscli'];
}
$startRow_rscli = $pageNum_rscli * $maxRows_rscli;
mysql_select_db($database_connection, $connection);
$query_rscli = "SELECT * FROM client ORDER BY Raison_sociale ASC";
$query_limit_rscli = sprintf("%s LIMIT %d, %d", $query_rscli, $startRow_rscli, $maxRows_rscli);
$rscli = mysql_query($query_limit_rscli, $connection) or die(mysql_error());
$row_rscli = mysql_fetch_assoc($rscli);
//print_r($_POST);
if (isset($HTTP_GET_VARS['totalRows_rscli'])) {
$totalRows_rscli = $HTTP_GET_VARS['totalRows_rscli'];
} else {
$all_rscli = mysql_query($query_rscli);
$totalRows_rscli = mysql_num_rows($all_rscli);
}
$totalPages_rscli = ceil($totalRows_rscli/$maxRows_rscli)-1;
$queryString_rscli = "";
if (!empty($HTTP_SERVER_VARS['QUERY_STRING'])) {
$params = explode("&", $HTTP_SERVER_VARS['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_rscli") == false &&
stristr($param, "totalRows_rscli") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_rscli = "&" . implode("&", $newParams);
}
}
$queryString_rscli = sprintf("&totalRows_rscli=%d%s", $totalRows_rscli, $queryString_rscli);
?>
<html>
<head>
<link href="style/style.css" rel="stylesheet" type="text/css" >
<title>Formulaire de modifications des clients</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="javascript">
function message()
{ if (confirm("Etes-vous sûr de vouloir supprimer cette ligne ?")) {
return true;
}
else
{
return false;
}
}
</script>
</head>
<body><center>
<table class="interface" cellspacing="0" >
<tr class="entete2" align="center" >
<td colspan="3"><img src="images/bienvenuehomepage.gif" width="600" height="49" align="middle" ></td>
</tr>
<tr>
<td class="menugauche">
<?include ("menu.php")?>
</td>
<td class="info">
<!--------------------------------------->
<table align="center">
<caption class=""><font color="#006400">FORMULAIRE DE MISE A JOUR DES CLIENTS</font>
</caption>
<TR> </TR>
<tr><font color="red"><?php if (isset($_REQUEST['message'])) {echo($_REQUEST['message']);unset($_REQUEST['message']);}?></font></tr>
<tr bgcolor="#bde4bd"><th>Client</th><th>Adresse</th><th>Téléphone</th><th>Gestionnaire</th><th>Modifier</th><th>Supprimer</th><th>Imprimer</th></tr>
<?php
$color=1;
do {
if ($color%2==0) {$bgcolor="#f5f5f5";} else{$bgcolor="#ffffff";}
?>
<tr bgcolor="<? echo $bgcolor?>">
<td align="center"><?php echo $row_rscli['Raison_sociale']; ?></td>
<td align="center"><?php echo $row_rscli['Adresse']; ?></td>
<td align="center"><?php echo $row_rscli['telephone']; ?></td>
<td align="center"><?php echo $row_rscli['Gestionnaire']; ?></td>
<td><a href="editclient.php?NumCli=<?php echo $row_rscli['NumCli']; ?>">Modifier</a></td>
<td onClick="return message();"><a href="supclient.php?NumCli=<?php echo $row_rscli['NumCli']; ?>">Supprimer</a></td>
<td><a href="impclient.php?NumCli=<?php echo $row_rscli['NumCli']; ?>">Imprimer</a></td>
</tr>
<?php
$color++;
} while ($row_rscli = mysql_fetch_assoc($rscli));
?>
</table>
<table width="100%">
<hr>
<tr>
<td align="center"> <a href="<?php printf("%s?pageNum_rscli=%d%s", $currentPage, max(0, $pageNum_rscli - 1), $queryString_rscli); ?>"><< Précédent</a>
<a href="<?php printf("%s?pageNum_rscli=%d%s", $currentPage, min($totalPages_rscli, $pageNum_rscli + 1), $queryString_rscli); ?>">Suivant >></a> </td>
</tr>
</table>
<!--------------------------------------->
<!----------------------------------------------->
</td>
<td class="menudroit"><?include("menu_bis.php");?></td>
</tr>
<tr class="pied"><td colspan="3" ><?include("footer.php")?></td></tr>
</table>
</center>
</body>
</html>
<?php
mysql_free_result($rscli);
?> |
Partager