Voila mon code:
<?php
include ("header1.php");
?>
<?php
$hostdb = 'localhost';
$userdb = 'root';
$passdb = '';
$namedb = 'parcmfb';
try
{
$conn = new PDO("mysql:host=".$hostdb."; dbname=".$namedb."", $userdb, $passdb, array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));
$conn->exec("SET CHARACTER SET utf8");
}
catch (PDOException $e)
{
echo 'La base de donnée n\'est pas disponible';
}
$sql = 'SELECT SiteCode, SiteNom, SiteResponsable, SiteAdresse, SiteMail, SiteTel, SiteIp, SiteLiaison, SiteJirama, Observation FROM site';
$req = $conn->prepare($sql);
$req->setFetchMode(PDO::FETCH_ASSOC);
foreach($req as $row)
{
echo $row['SiteCode'];
echo $row['SiteNom'];
echo $row['SiteResponsable'];
echo $row['SiteAdresse'];
echo $row['SiteMail'];
echo $row['SiteTel'];
echo $row['SiteIp'];
echo $row['SiteLiaison'];
echo $row['SiteJirama'];
echo $row['Observation'], '<br>';
}
?>
<form name="form" action="ajout_site.php" method="POST" enctype="multipart/form-data" >
<fieldset>
<legend><em>Ajout d'un Site</em></legend>
<table align="center">
<tr>
</td>
<label for="ChampCode">Site Code:</label>
</td>
<td>
<input type="text" id="SiteCode" name="SiteCode" require/>
</td>
</tr>
<tr>
<td>
<label for="ChampNom">Nom Site:</label>
</td>
<td>
<input type="text" id="SiteNom" name="SiteNom" require/>
</td>
</tr>
<tr>
<td>
<label for="ChampRespo">Site Responsable:</label>
</td>
<td>
<select name="NomRespo" id="NomRespo">
<option value="">Nom Responsable</option>
</td>
</tr>
<tr>
<td>
<label for="ChampTel">Site Adresse:</label>
</td>
<td>
<input type="text" id="SiteAdresse" name="SiteAdresse" require/>
</td>
</tr>
<tr>
<td>
<label for="ChampTel">Site Mail:</label>
</td>
<td>
<input type="text" id="SiteMail" name="SiteMail" require/>
</td>
</tr>
<tr>
<td>
<label for="ChampTel">Site Téléphone:</label>
</td>
<td>
<input type="text" id="SiteTel" name="SiteTel" require/>
</td>
</tr>
<tr>
<td>
<label for="ChampTel">Site Ip:</label>
</td>
<td>
<input type="text" id="SiteIp" name="SiteIp" require/>
</td>
</tr>
<tr>
<td>
<label for="ChampTel">Site Liaison:</label>
</td>
<td>
<input type="text" id="SiteLiaison" name="SiteLiaison" require/>
</td>
</tr>
<tr>
<td>
<label for="ChampTel">Site Jirama:</label>
</td>
<td>
<input type="text" id="SiteJirama" name="SiteJirama" require/>
</td>
</tr>
<tr>
<td>
<label for="Champobs">Observation:</label>
</td>
<td>
<input type="text" id="Observation" name="Observation" require/>
</td>
</tr>
<tr>
<td></td>
<td>
<input type="button" value="Ajouter" onclick="alert('Ajout avec succes');" />
<input type="button" value="Annuler" onclick="alert('Ajout annuler');" />
</td>
</tr>
</table>
</fieldset>
</form>
<?php
include ("footer.php");
?>
merci dav