En fait, dans ma page listing client sur mon bouton, j'ai cla comme code :
[code]<td class="highlight"><a href='edit_client.php?num=<?php echo "$num" ?>'><img border='0'src='image/edit.gif' alt='<?php echo $lang_editer; ?>'></a></td>
[/code]
et le but est que j'arrive sur la meme page avec modifier_client.php que par mon bouton dans listing client.
je cherche juste à simplifier le fait de retrouver un client.
Je plave le code complet de ma page listin :
[code]<?php
/*
* Factux le facturier libre
* Copyright (C) 2003-2004 Guy Hendrickx
*
* Licensed under the terms of the GNU General Public License:
* http://www.opensource.org/licenses/gpl-license.php
*
* For further information visit:
* http://factux.sourceforge.net
*
* File Name: lister_clients.php
* liste les clients et permet de multiples action sur les clients
*
* * * Version: 1.1.5
* * * * Modified: 23/07/2005
*
* File Authors:
* Guy Hendrickx
*.
*/
require_once("include/verif.php");
include_once("include/config/common.php");
include_once("include/language/$lang.php");
include_once("include/utils.php");
include_once("include/headers.php");?>
<script type="text/javascript" src="javascripts/confdel.js"></script>
<?php
include_once("include/finhead.php");
?>
<table width="760" border="0" class="page" align="center">
<tr>
<td class="page" align="center">
<?php
include_once("include/head.php");
?>
</td>
</tr>
<tr>
<td class="page" align="center">
<?php
if ($user_cli == n) {
echo"<h1>$lang_client_droit";
exit;
}
?>
<?php
$sql = " SELECT * FROM " . $tblpref ."client WHERE actif != 'non' ";
if ( isset ( $_GET['ordre'] ) && $_GET['ordre'] != '')
{
$sql .= " ORDER BY " . $_GET[ordre] . " ASC";
}else{
$sql .= "ORDER BY nom ASC ";
}
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
?>
<center><table class="boiteaction">
<caption><?php echo $lang_clients_existants; ?></caption>
<tr>
<th><a href="lister_clients.php?ordre=num_client"><?php echo $num_client; ?> </a></th>
<th><a href="lister_clients.php?ordre=civ"><?php echo $lang_civ; ?> </a></th>
<th><a href="lister_clients.php?ordre=nom"><?php echo $lang_nom; ?></a></th>
<th><a href="lister_clients.php?ordre=nom2"><?php echo $lang_complement; ?></a></th>
<th><a href="lister_clients.php?ordre=rue"><?php echo $lang_rue; ?></a></th>
<th><a href="lister_clients.php?ordre=cp"><?php echo $lang_code_postal; ?></a></th>
<th><a href="lister_clients.php?ordre=ville"><?php echo $lang_ville; ?></a></th>
<th><a href="lister_clients.php?ordre="><?php echo $lang_numero_tva; ?></a></th>
<th><a href="lister_clients.php?ordre=tel"><?php echo $lang_tele;?></a></th>
<th><a href="lister_clients.php?ordre=fax"><?php echo $lang_fax;?></a></th>
<th><a href="lister_clients.php?ordre=condipay"><?php echo $lang_condipay;?></a></th>
<th><a href="lister_clients.php?ordre=mail"><?php echo $lang_email; ?></a></th>
<th><a href="lister_clients.php?ordre=mail2"><?php echo $lang_email2; ?></a></th>
<th colspan="2"><?php echo $lang_action; ?></th>
</tr>
<?php
$nombre =1;
while($data = mysql_fetch_array($req))
{
$civ =$data['civ'];
$num_client =$data['num_client'];
$nom = $data['nom'];
$nom_html= addslashes($nom);
$nom2 = $data['nom2'];
$rue = $data['rue'];
$ville = $data['ville'];
$cp = $data['cp'];
$tva = $data['num_tva'];
$mail =$data['mail'];
$mail2 =$data['mail2'];
$num = $data['num_client'];
$civ = $data['civ'];
$tel = $data['tel'];
$fax = $data['fax'];
$condipay = $data['condipay'];
$nombre = $nombre +1;
if($nombre & 1){
$line="0";
}else{
$line="1";
}
?>
<tr class="texte<?php echo"$line" ?>" onmouseover="this.className='highlight'" onmouseout="this.className='texte<?php echo"$line" ?>'">
<td class="highlight"><?php echo $num_client; ?></td>
<td class="highlight"><?php echo $civ; ?></td>
<td class="highlight"><?php echo $nom; ?></td>
<td class="highlight"><?php echo $nom2; ?></td>
<td class="highlight"><?php echo $rue; ?></td>
<td class="highlight"><?php echo $cp; ?></td>
<td class="highlight"><?php echo $ville; ?></td>
<td class="highlight"><?php echo $tva; ?></td>
<td class="highlight"><?php echo $tel; ?></td>
<td class="highlight"><?php echo $fax; ?></td>
<td class="highlight"><?php echo $condipay; ?></td>
<td class="highlight"><a href="mailto:<?php echo $mail; ?>" ><?php echo "$mail"; ?></a></td>
<td class="highlight"><a href="mailto:<?php echo $mail2; ?>" ><?php echo "$mail2"; ?></a></td>
<td class="highlight"><a href='edit_client.php?num=<?php echo "$num" ?>'><img border='0'src='image/edit.gif' alt='<?php echo $lang_editer; ?>'></a></td>
<td class="highlight"><a href='del_client.php?num=<?php echo "$num"; ?>' onClick="return confirmDelete('<?php echo"$lang_cli_effa $nom_html ?"; ?>')"><img border='0'src='image/delete.jpg' alt='<?php echo $lang_supprimer; ?>'></a></td>
<?php
}
$aide = client;
?>
<tr><TD colspan="12" class="submit"></TD></tr>
</table></center><tr><td>
<?php
include("help.php");
echo"</td></tr><tr><td>";
include_once("include/bas.php");
?>
</td></tr>
<?php
$url = $_SERVER['PHP_SELF'];
$file = basename ($url);
if ($file=="form_client.php") {
echo"</table>";
} ?>
</table>
</body>
</html>
[/code]
Ci dessous, le code de ma page rechercher_client.php
[code]<?php
/*
* Factux le facturier libre
* Copyright (C) 2003-2004 Guy Hendrickx
*
* Licensed under the terms of the GNU General Public License:
* http://www.opensource.org/licenses/gpl-license.php
*
* For further information visit:
* http://factux.sourceforge.net
*
* File Name: chercher_factures.php
* formulaire de recherche des factures
*
* * * Version: 1.1.5
* * * * Modified: 23/07/2005
*
* File Authors:
* Guy Hendrickx
*.
*/
require_once("include/verif.php");
include_once("include/config/common.php");
include_once("include/language/$lang.php");
include_once("include/utils.php");
include_once("include/headers.php");?>
<?php
include_once("include/finhead.php");
?>
<table width="760" border="0" class="page" align="center">
<tr>
<td class="page" align="center">
<?php
include_once("include/head.php");
?>
</td>
</tr>
<tr>
<td class="page" align="center">
<?php
if ($user_com == n) {
echo"<h1>$lang_commande_droit";
exit;
}
$rqSql = "SELECT num_client, nom FROM " . $tblpref ."client WHERE 1";
if ($user_fact == r) {
$rqSql = "SELECT num_client, nom FROM " . $tblpref ."client
WHERE " . $tblpref ."client.permi LIKE '$user_num,'
or " . $tblpref ."client.permi LIKE '%,$user_num,'
or " . $tblpref ."client.permi LIKE '%,$user_num,%'
or " . $tblpref ."client.permi LIKE '$user_num,%'
";
}
?>
<form name="formu" method="post" action="edit_client.php?num=<?php echo "$num" ?>">
<center><table >
<caption><?php echo $lang_chercher_cli; ?></caption>
<tr>
<td class="texte1">
<?php echo $lang_client; ?></td><td class="texte1">
<?php
require_once("include/configav.php");
if ($liste_cli!='y') {
$rqSql="$rqSql order by nom";
$result = mysql_query( $rqSql ) or die( "Exécution requête impossible.");
?>
<SELECT NAME='listeville'>
<OPTION VALUE="null"><?php echo $lang_choisissez; ?></OPTION>
<?php
while ( $row = mysql_fetch_array( $result)) {
$numclient = $row["num_client"];
$nom = $row["nom"];
?>
<OPTION VALUE='<?php echo "$num" ?>'><?php echo $nom; ?></OPTION>
<?php
}
?>
</SELECT>
<?php }else{ ?>
<script type="text/javascript" src="javascripts/montrer_cacher.js"></script>
<INPUT type="checkbox" checked name="list_client" onClick="montrer_cacher(this,'cluster','cluster2')">
<?php
include_once("include/choix_cli.php");
} ?>
<td class=""highlight"><a href='edit_client.php?num=<?php echo "$num" ?>'> colspan="2"> <input type="submit" name="submit" value=<?php echo $lang_rech ?>>
</td>
</tr>
</tr>
</table></center></form>
</td></tr><tr><td>
<?php
include("help.php");
echo"</td></tr><tr><td>";
include_once("include/bas.php");
?>
</td></tr>
</table>
</body>
</html>
[/code]
je ne voit pas ou il manque l'info du n° de client.
