Bonjour à tous,
je voudrais afficher les différents contact de ma banque voici le code utilise :
<!doctype html public "-//w3c//dtd xhtml 1.0 strict//en"
"http://www.w3.org/tr/xhtml1/dtd/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml/lang="fr"
lang="fr"
<head>
<title>banque</title>
<META HTTP-equiv="content-type"
content="text/html, charset=utf-8"/>
</head>
<body>
<?php
require_once('includes/templategc.php');
require_once('includes/magicquotes.inc.php');
require_once('includes/bd.inc.php');
$NumBanque = mysqli_real_escape_string($lien, $_GET['NumBanque']);
$resultat = mysqli_query($lien, "select NumBanque, Enseigne, NomAgence, AdrBanque, CpBQ, VilleBq, Tel, Fax from bdbanques where NumBanque ='$NumBanque'");
$bdbanques = array();
while ($ligne = mysqli_fetch_array($resultat))
{
$bdbanques[]= array('NumBanque' => $ligne ['NumBanque'], 'Enseigne' => $ligne ['Enseigne'],'NomAgence' => $ligne ['NomAgence'],'AdrBanque' => $ligne ['AdrBanque'],'CpBQ' => $ligne ['CpBQ'],'VilleBq' => $ligne ['VilleBq'],'Tel' => $ligne ['Tel'],'Fax' => $ligne ['Fax']);
}
$resultat1 = mysqli_query($lien, "select NumContact, NumBanque, StatutCont, NomCont, PreCont, TelCont, EmailCont, MobileCont from bdcontactsbanques where NumBanque ='$NumBanque'");
$bdcontactsbanques = array();
while ($ligne = mysqli_fetch_array($resultat1))
{
$bdcontactsbanques[]= array('NumContact' => $ligne ['NumContact'], 'NumBanque' => $ligne ['NumBanque'] , 'StatutCont' => $ligne ['StatutCont'], 'NomCont' => $ligne ['NomCont'], 'PreCont' => $ligne ['PreCont'], 'TelCont' => $ligne ['TelCont'], 'EmailCont' => $ligne ['EmailCont'], 'MobileCont' => $ligne ['MobileCont']);
}
?>
<?php foreach ($bdbanques as $banques): ?>
<form action="?" method="POST">
<div class="wrapper">
<!--debut de rounded box --> <!--debut de rounded box --><b class="xb1"></b><b class="xb2"></b><b class="xb3"></b><b class="xb4"></b><b class="xb5"></b><b class="xb6"></b><b class="xb7"></b>
<div class="xboxcontent">
<fieldset>
<div class="ligne">
<span class="libelle"><label for="NumBanque">Numéro :</label></span>
<input name="NumBanque" id="NumBanque" size="10" maxlength="30" type="text" value="<?php echo $banques['NumBanque'];?>" />
</div>
<div class="ligne"><span class="libelle"><label for="Enseigne">Enseigne :</label></span>
<input name="Enseigne" id="Enseigne" size="15" maxlength="30" type="text" value="<?php echo $banques['Enseigne'];?>" /></div>
<div class="ligne"><span class="libelle"><label for="NomAgence">Nom Agence :</label></span>
<input name="NomAgence" id="NomAgence" size="35" maxlength="30" type="text" value="<?php echo $banques['NomAgence'];?>" /></div>
<div class="ligne"><span class="libelle"><label for="AdrBanque">Adresse :</label></span>
<textarea name="AdrBanque" cols="17" rows="2" id="AdrBanque"><?php echo $banques['AdrBanque'];?></textarea></div>
<div class="ligne">
<span class="libelle">
<label for="CpBQ">Code postal</label> - <label for="VilleBq">Ville :</label>
</span>
<input name="CpBQ" id="CpBQ" size="4" maxlength="5" type="text" value="<?php echo $banques['CpBQ'];?>" /> -
<input name="VilleBq" id="VilleBq" size="30" maxlength="40" type="text" value="<?php echo $banques['VilleBq'];?>" />
</div>
<div class="ligne"><span class="libelle"><label for="Tel">Tel :</label></span>
<input name="Tel" id="Tel" size="15" maxlength="30" type="text" value="<?php echo $banques['Tel'];?>" /></div>
<div class="ligne"><span class="libelle"><label for="Fax">Fax :</label></span>
<input name="Fax" id="Fax" size="15" maxlength="30" type="text" value="<?php echo $banques['Fax'];?>" /></div>
</fieldset>
<!--fin de rounded box--> </div><b class="xb7"></b><b class="xb6"></b><b class="xb5"></b><b class="xb4"></b><b class="xb3"></b><b class="xb2"></b><b class="xb1"></b>
<br />
<!--debut de rounded box --><b class="xb1"></b><b class="xb2"></b><b class="xb3"></b><b class="xb4"></b><b class="xb5"></b><b class="xb6"></b><b class="xb7"></b><div class="xboxcontent">
<fieldset>
<h3>Interlocuteurs et contacts</h3>
<?php echo "<table><tr class=\"headline\"><th>Num</th><th>Statut</th><th>Nom</th><th>Prénom</th><th>télèphone</th><th>Email</th><th>Mobile</th></tr>" ; ?>
<?php foreach ($bdcontactsbanques as $contacts): ?>
<form action ="CONSULTER" method="POST">
<?php echo "<tr><td>" .htmlspecialchars($contacts['NumContact'], ENT_QUOTES, 'utf-8'). "</td>" ; ?>
<?php echo "<td>" .htmlentities(htmlspecialchars($contacts['StatutCont'], ENT_QUOTES, 'utf-8')). "</td>" ; ?>
<?php echo "<td>" .htmlspecialchars($contacts['NomCont'], ENT_QUOTES, 'utf-8'). "</td>" ; ?>
<?php echo "<td>" .htmlspecialchars($contacts['PreCont'], ENT_QUOTES, 'utf-8'). "</td>" ; ?>
<?php echo "<td>" .htmlspecialchars($contacts['EmailCont'], ENT_QUOTES, 'utf-8'). "</td>" ; ?>
<?php echo "<td>" .htmlspecialchars($contacts['MobileCont'], ENT_QUOTES, 'utf-8'). "</td>" ; ?>
<td><a href="modifbanque.php?NumBanque=<?php echo $contacts['NumBanque'];?>"> <input type="submit" name="action" value="CONSULTER"/></a></td>
<td><a href="?supprbanqueNum=<?php echo $contacts['NumBanque']; ?>"><input type="submit" name="action" value="SUPPRIMER"/></a></td>
<?php endforeach; ?>
</form>
<?php echo "</tr></table>"; ?>
</fieldset>
<!--fin de rounded box--> </div><b class="xb7"></b><b class="xb6"></b><b class="xb5"></b><b class="xb4"></b><b class="xb3"></b><b class="xb2"></b><b class="xb1"></b>
<?php endforeach; ?>
<div id="btns">
<a href="listebanques.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Retour','','images/btn-back_hover.jpg',1)"><img src="images/btn-back_off.jpg" alt="Retour à la liste clients" name="Retour" id="Retour" /></a>
<a href="majbanque.php?NumBanque=<?php echo $banques['NumBanque']; ?>"> <input id="AJOUTER" name="AJOUTER" value="AJOUTER" type="image" src="images/btn-validate_off.jpg" /></a>
<a href="printbanque.php?NumBanque=<?php echo $banques['NumBanque']; ?>" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Retour','','images/preview.bmp',1)"><img src="images/loupe.png" alt="apercu fiche client particulier" name="apercu" id="apercu" /></a>
</div> <!--fin de btns -->
</div> <!--fin de wrapper -->
</form>
<div class="spacer"></div>
<?php include('majbanque.php'); ?>
<?php
pied();
?>
</body>
</html>
lorsque j'ouvre ma page voici le message d'erreur que j'ai :
Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in C:\Program Files\EasyPHP-5.3.3\www\gescompt\modifbanque.php on line 26
je ne comprends pas pourquoi ???
quelqu'un peux t il 'aider ???
merci d'avance
Aurélie