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 54 55 56 57 58 59 60 61 62 63 64 65
| <?
require("cnx/login_sql.php");
//Connexion à la base
$db = mysql_connect('localhost', 'root', '') or die ("Erreur de connexion");
//Selection de la base
mysql_select_db('alliance',$db);
@$id=$_GET['id'];
$date = date("y/m/d G.i:s", time());
$empr="SELECT s.id_spare,p.idspare_pr FROM spare s LEFT JOIN pr_spare p ON s.id_spare=p.idspare_pr WHERE p.idspare_pr='$id'";
$data=mysql_query($empr) or die ('Erreur SQL !');
//Formulaire d'ajout.
echo '<form name="formpret" method="POST" Action="?numlien=pret">
<br><center><table border="0" cellpadding="1" cellspacing="1">
<tr bgcolor="#336699">
<td height="25"colspan="2" align="center"><strong>
<font color="#FFFFFF" size="2">Pret Pc Portable</font></strong></td>
</tr>
<tr>
<td bgcolor="E8E8E8">Spare a préter</td>';
echo '<td bgcolor="F4F4F4"><SELECT name="nom_sp">';
while($datalst(mysql_num_rows($data)))
{
echo '<option value="'.$datalst['id_spare'].'">'.$datalst['nom_spare'].'</option>';
}
echo '</td>
</tr>
<tr>
<td bgcolor="E8E8E8">Nom de l\'emprunteur ?</td>
<td bgcolor="F4F4F4"><input type="text" name="emprunteur" value="'.@$_POST['emprunteur'].'"></td>
</tr>
<tr>
<td bgcolor="E8E8E8">Date du jour (auto)</td>
<td bgcolor="F4F4F4"><TEXTAREA name="date" onfocus="document.forms.f.dmc.blur()" value="'.$date['datejour'].'"></td>
</tr>
<tr>
<td bgcolor="E8E8E8">Nbres Jours / Mois</td>
<td bgcolor="F4F4F4"><input type="text" name="jourmois" value="'.@$_POST['nbrejourmois'].'"></td>
</tr>
<tr>
<td bgcolor="E8E8E8">Validation emprunt</td>
<td bgcolor="F4F4F4">Oui : <input type="radio" name="choix" value="'.@$_POST['oui'].'"><br>
non : <input type="radio" name="choix" value="'.@$_POST['non'].'"></td>
</tr>
<tr align="center" bgcolor="D6D6D6">
<td colspan="2"><strong><font size="1"></font>
<input type="Submit" value="Valider"></strong>
</td>
</tr>
</table><br></center></form>';
//Fermeture de la connexion
mysql_close();
?> |
Partager