Erreur fonction (MYSQL)
steve225 Le 18 avril 2017 à 10:35 (Édité le 25 janvier 2019 à 17:53)
<?php
include ("perl.php");
?>
<html>
<head>
<title>Ajouter un vehicule</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="../lien.css" rel="stylesheet" type="text/css">
</head>
<body marginheight="40" bgcolor="#fffcd9">
<p align="center" class="style2"><strong>- Ajouter un vehicule -</strong></p><br>
<form name="Immatriculation_Vehicule" method="post" action="ajoutvehicule.php">
<table align="center" border="0">
<tr>
<td align="right">Matricule :</td>
<td><input type="text" name="Immatriculation_Vehicule"></td>
<td align="right">Modele :</td>
<td><input type="text" name="Modele_Vehicule"></td>
</tr>
<tr>
<td align="right">Date de sortie :</td>
<td>
<?php
echo "<select name=\"joursortie\">";
for($i=1;$i<32;$i++)
echo "<option value=\"$i\">$i</option>";
echo "</select> ";
echo "<select name=\"moissortie\">";
for($i=1;$i<13;$i++)
echo "<option value=\"$i\">$i</option>";
echo "</select> ";
echo "<select name=\"anneesortie\">";
for($i=2000;$i<2020;$i++)
echo "<option value=\"$i\">$i</option>";
echo "</select>";
?>
</td>
<td align="right">Marque :</td>
<td>
<?php
$requete = mysql_query("select * from vehicule");
echo "<select name=\"vehicule\" id=\"vehicule\">";
while($resultat = mysql_fetch_array($requete))
echo "<option value=\"$resultat[0]\">$resultat[1]</option>";
echo "</select>";
?>
</td> </tr> <tr>
<td align="right">Type :</td>
<td><?php
$requete2 = mysql_query("SELECT * FROM vehicule");
echo "<select name=\"vehicule\" id=\"vehicule\">";
while($resultat2 = mysql_fetch_array($requete2))
echo "<option value=\"$resultat2[0]\">$resultat2[1]</option>";
echo "</select>";
?>
</td>
<td align="right">Code de reservation :</td>
<td><?php
$requete2 = mysql_query("SELECT * FROM reservation");
echo "<select name=\"reservation\" id=\"reservation\">"; while($resultat2 = mysql_fetch_array($requete2))
echo "<option value=\"$resultat2[0]\">$resultat2[1]</option>";
echo "</select>";
?>
</td>
</table><br>
<div align="center"><input type ="submit" value="Enregistrer"></div>
</form>
</body>
</html>
<?php
// deconnexion de la base
mysql_close();
?>
Balatharas Le 18 avril 2017 à 12:49
Au lieu de faire mysql_fetch_array fais $var->fetch();
