close();
function getResep( $id = false, $conn ){
if ( (int)$id ){
$sql = "
SELECT r.id_resep, r.nama_resep, r.cara_masak, r.video, b.nama_bahan FROM detail_resep rd
LEFT JOIN tbl_resep r ON r.id_resep = rd.id_resep
LEFT JOIN tbl_bahan b ON b.id_bahan = rd.id_bahan
WHERE rd.id_resep = ". (int)$id . " ;
";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
$resep_id = $row["id_resep"];
$resep_nama = $row["nama_resep"];
$resep_cara_masak = $row["cara_masak"];
$resep_video = $row["video"];
$bahan[] = $row["nama_bahan"];
}
$data = [
"success" => true,
"info" => "Resep ID = " . $resep_id,
"nama" => $resep_nama ,
"cara_masak" => $resep_cara_masak ,
"video" => $resep_video ,
"bahan" => implode(", ", $bahan),
];
} else {
$data = [
"success" => false,
"info" => "Nodata"
];
}
} else {
$data = [
"success" => false,
"info" => "No Id Select"
];
}
return $data;
}
?>
Resep
Nama Resep :
Bahan :
Cara :
Video :