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);
?> |
