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
| <?php
//Retourne les infos d'un Cd si id > 0 de tous les Cds si Id vide ou = 0
// Se connecter à la base de données
include("fct.php");
if(empty($_GET["id"])){
$id = 0;
}else{
$id = intval($_GET["id"]);
}
//$sql = "SELECT * FROM cd";
if($id > 0){
$sql = "SELECT * FROM cd WHERE IdCd=".$id." ";
}else{
$sql = "SELECT * FROM cd ";
}
$lst_Cd = array();
$result = mysqli_query($conn, $sql) or die ($sql) ;
while($ReqlstCd = mysqli_fetch_array($result, MYSQLI_ASSOC)){
$lst_Cd[] = $ReqlstCd;
}
header('Content-Type: application/json');
echo json_encode($lst_Cd, JSON_PRETTY_PRINT);
?> |