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 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html lang="en" xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<meta http-equiv="content-type" content="application/xhtml+xml; charset=utf-8" />
<title>CSS Registration Form</title>
<link rel="stylesheet" type="text/css" href="css/default.css" />
</head>
<?php
try {
$bdd = new PDO('mysql:host=localhost;dbname=agence;charset=utf8', 'ludo', '');
} catch (Exception $e) {
die('Erreur : ' . $e->getMessage());
}
$codebien = $_POST['codebien'];
$requete="SELECT
`Code_Bien`,
`Agence`,
`Type_Vente`,
`Type_Bien`,
`Date_F`,
`Date_I`,
`Date_Expiration`,
`Actif`,
`Etat`,
`Certif_PEB`,
`Photos`,
`Plan`,
`PDF_Plan`,
`Modif_Plan`,
`Fichier_Plan`,
`Date_Reception`,
`Date_Creation`,
`Date_Envoie`,
`Date_Corrections`,
`Date_Publication`,
`Remarques`
FROM `biens`
WHERE 'Code_Bien' ='".$bien."'";
$response = $bdd->query($requete);
$response = $bdd->prepare($requete);
$response->execute(array(':bien'=>$_POST['bien']));
$data = $response->fetch(PDO::FETCH_ASSOC);
?>
<body>
<h1>Consultation des Biens </h1>
<fieldset class="row1"> <legend>Détails du bien </legend>
<p> <label style="width: 100px;">Code bien </label>
<input name="bien" type="search" value="<?php echo htmlspecialchars($data['Code_bien']); ?> " style="width: 100px;" />
<label style="width: 100px;">Type de Vente</label>
<input type="text" name="typevente"style="width: 100px">
<label style="width: 100px;">Type de Bien </label>
<input type="text" name="typebien"style="width: 100px;">
<p> <label style="width: 100px;">Agence </label>
<input type="text"name="agence"style="width: 100px;"/>
<label style="width: 100px;">Actif </label>
<input type="text" name="actif"style="width: 100px;">
<label style="width: 100px;">Etat </label>
<input type="text" name="etat"style="width: 100px;">
</p>
<p> <label style="width: 100px;">Date f</label>
<input name="datef" type="text"style="width: 100px;" id="datef" />
<label style="width: 100px;"id="datei">Date I </label>
<input name="datei" type="text" style="width: 100px;"id="dateim" />
<label style="width: 100px;" id="dateexpir">Date expiration </label>
<input name="dateexpir" type="text" style="width: 100px;" id="dateexpira" />
</p>
<p> Remarques :<textarea class="remarque" name="remarque" row="24" cols="45" style="height: 80px; width: 600px;"></textarea>
</fieldset>
<fieldset class="row2"> <legend>Plans </legend>
<p style="text-align: left;">*
<label>Plan</label>
<input name="plan" type="checkbox" value="oui" />
<label class="gender">Oui</label>
<input name="plan" type="checkbox" value="non" />
<label class="gender">Non</label> </p>
<p> <label>Nouveau PDF</label> <input name="newpdf"style="width:100px;" type="text" class="long" />
<label>Date reception</label> <input name="reception"style="width:100px;" type="text" /> </p>
<p> <label>Modif PDF </label> <input name="modif"style="width:100px;" type="text" class="long" />
<label>Date creation</label> <input name="creation"style="width:100px;" type="text" /> </p>
<p> <label>Fichier plan</label> <input name="fichier"style="width:100px;" type="text" class="long" />
<label>Date agence</label> <input name="dateagence"style="width:100px;" type="text" /> </p>
<p> <label>Date corrections</label> <input name="correction"style="width:100px;" type="text" />
<label>Date publication</label> <input name="publication"style="width:100px;" type="text" /> </p>
</fieldset>
<fieldset class="row3"> <legend>Autre Informations </legend>
<p> <label>Numéro PEB</label> <input name="certifpeb"type="text" /></p>
<p> <label> ID BDD</label> <input name="idbdd"type="text" /></p>
<p> <label> Photos </label> <input name="photo"type="text"/></p>
</fieldset>
<div><input class="button" type="submit" value="Valider »"/></div>
</form>
</body>
</html> |
Partager