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
| (<?php error_reporting (E_ALL ^ E_NOTICE); ?>
<?php include("menu.php");?>
<link rel="stylesheet" href="menu/dropdown_three.css" type="text/css">
<link rel="stylesheet" href="style.css" type="text/css">
<?php
include("include/db_inc_pdo.php");
?>
<table class="bicolor" border="1" align="center">
<tr>
<th>Date arrive</th>
<th>Date depart</th>
<th>Nb.</th>
<th>Nom</th>
<th>Prix location</th>
<th>Caution</th>
<th>1er paie.</th>
<th>Date.</th>
<th>2e paie.</th>
<th>Date</th>
<th>3e paie.</th>
<th>Date</th>
<th>Linge</th>
<th>Litbaby</th>
<th>Degats payes</th>
<th>Non paye</th>
<th>Remarques</th>
<th>Rest.</th>
<th>Date lettre</th>
<th>Appart</th>
<th>Tarifs</th>
<th>Desc.</th>
<th>Paragraphe sup.</th>
<th>Conf.</th>
<th>Enfants</th>
<th>Annulé</th>
</tr>
<?php
$reponse = $pdo->query('SELECT DATE_FORMAT( datearrive, "%d/%m/%Y" ) AS datea, DATE_FORMAT( datedepart, "%d/%m/%Y" ) AS dated, dateloca.nombre, dateloca.prixlocation, dateloca.caution, dateloca.1erpaiement AS apaiement, DATE_FORMAT( date1erpaiement, "%d/%m/%Y" ) AS dateunp, dateloca.2epaiement AS bpaiement, DATE_FORMAT( date2epaiement, "%d/%m/%Y" ) AS datedeuxp, dateloca.3epaiement AS cpaiement, DATE_FORMAT( date3epaiement, "%d/%m/%Y" ) AS datetroisp, dateloca.linge, dateloca.litbaby, dateloca.degatspayes, dateloca.nonpaye, dateloca.remarques, dateloca.restitution, DATE_FORMAT( datelettre, "%d/%m/%Y" ) AS datel, dateloca.appart, dateloca.envoitarifs, dateloca.envoidescriptif, dateloca.paragraphesup, dateloca.confirmation, dateloca.enfants, dateloca.annul, locataires.nom
FROM dateloca
INNER JOIN locataires ON dateloca.idnoms = locataires.idnoms
WHERE locataires.reserve = "oui"
ORDER BY datearrive desc');
while ($donnees = $reponse->fetch())
{
//On affiche les données dans le tableau
echo "<tr>";
echo "<td> $donnees[datea] </td>";
echo "<td> $donnees[dated] </td>";
echo "<td> $donnees[nombre] </td>";
echo "<td> $donnees[nom] </td>";
echo "<td> $donnees[prixlocation] </td>";
echo "<td> $donnees[caution] </td>";
echo "<td> $donnees[apaiement] </td>";
echo "<td> $donnees[dateunp] </td>";
echo "<td> $donnees[bpaiement] </td>";
echo "<td> $donnees[datedeuxp] </td>";
echo "<td> $donnees[cpaiement] </td>";
echo "<td> $donnees[datetroisp] </td>";
echo "<td> $donnees[linge] </td>";
echo "<td> $donnees[litbaby] </td>";
echo "<td> $donnees[degatspayes] </td>";
echo "<td> $donnees[nonpaye] </td>";
echo "<td> $donnees[remarques] </td>";
echo "<td> $donnees[restitution] </td>";
echo "<td> $donnees[datel] </td>";
echo "<td> $donnees[appart] </td>";
echo "<td> $donnees[envoitarifs] </td>";
echo "<td> $donnees[envoidescriptif] </td>";
echo "<td> $donnees[paragraphesup] </td>";
echo "<td> $donnees[confirmation] </td>";
echo "<td> $donnees[enfants] </td>";
echo "<td> $donnees[annul] </td>";
echo "</td>";
echo "</tr>";
// echo $donnees['datearrive'] .$donnees['datedepart'] .$donnees['nom'] .$donnees['prenom'] . $donnees['nombre'] .$donnees['prixlocation'] .'<br />';
}
$reponse->closeCursor();
?> |
Partager