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 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133
| <!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" />
<?php
try {
$bdd=new PDO( 'mysql:host=localhost;dbname=fiks;charset=utf8', 'ludo', '');
} catch (Exception $e)
{ die( 'Erreur : ' . $e->getMessage());
}
//$bien = $_POST['bien'];
$requete="SELECT
`Code_Bien`,
`Agence`,
`Type_Vente`,
`Type_Bien`,
`Date_Fiks`,
`Date_Immoweb`,
`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->prepare($requete);
$response->execute(array(':bien'=>$_POST['bien']));
$data = $response->fetch(PDO::FETCH_ASSOC);
var_dump($data);
?>
</head>
<body>
<form method="post" action="reponse3.php"class="register">
<h1>Consultation des Biens FIKS</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" value="<?php echo htmlspecialchars ($data['Type_Vente']); ?> " 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 fiks</label>
<input name="datefiks" type="text" style="width: 100px;" id="datefiks" />
<label style="width: 100px;" id="dateimmo">Date Immoweb </label>
<input name="dateimmo" type="text" style="width: 100px;" id="dateimmow" />
<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