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
| <?php
if(isset($_GET["id"])){
$req=$bd->requete_obj("SELECT r.*,CONCAT(c.prenom,' ',c.nom) as client FROM reservation_cours r
LEFT JOIN boutique_clients_associe c ON r.assignation=c.id
WHERE r.id=:id",array("id"=>$_GET['id']));
$value=$req->fetch();
echo "<h1>".$value->client."</h1>";}
}
else
if(isset($_GET["id"])){
$req=$bd->requete_obj("SELECT r.*,CONCAT(c.prenom,' ',c.nom) as client FROM reservation_cours r
LEFT JOIN boutique_clients c ON r.id_client=c.id
WHERE r.id=:id",array("id"=>$_GET['id']));}
?> |