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
| <?php
$host = 'localhost';
$user = 'root';
$pass = '';
$db = 'netfilter';
$link = mysql_connect ($host,$user,$pass) or die ('Erreur : '.mysql_error() );
mysql_select_db($db) or die ('Erreur :'.mysql_error());
// requête SQL qui compte le nombre total d'enregistrement dans la table et qui
//récupère tous les enregistrements
$select = 'SELECT date FROM paket';
$result = mysql_query($select,$link) or die ('Erreur : '.mysql_error() );
$total = $result;
$sel = 'SELECT date FROM paket';
$resu = mysql_query($sel,$link) or die ('Erreur : '.mysql_error() );
$total = $resu;
echo "<form action='ta_page.php' method='POST'>
<table><tr><td>begin date
<select name='begin date '>";
$total = mysql_num_rows($result);
while ($row=mysql_fetch_array($result))
{
echo"<option>$row[0]</option>";
}
echo"</select></td></tr>
</table>
<table><tr><td>end date
<select name='end date '>";
$total = mysql_num_rows($resu);
while ($row=mysql_fetch_array($resu))
{
echo"<option>$row[0]</option>";
}
echo $row[0];
echo"</select></td></tr>
</table>
</form>";
?> |
Partager