I’m working on a project, and there’s a products page with each product having an ID. When I click on the cart button, I want it to fetch me the product information including its name, image, and more. I’m a bit confused and I know I have a lot of errors. Can you help me?

solution

prepare(“SELECT GROEP.naam AS groep_naam, MERK.naam AS merk_naam, PRODUCT.opmerkingen, BESCHRIJVING.naam AS beschrijving_naam, MIN(PRODUCT.datumBeschikbaar) AS datumBeschikbaar, COUNT(PRODUCT.product_id) AS aantal_beschikbare_producten, IMAGE.image_data
FROM GROEP
INNER JOIN MERK ON GROEP.merk_id_fk = MERK.merk_id
INNER JOIN PRODUCT ON GROEP.groep_id = PRODUCT.groep_id
INNER JOIN BESCHRIJVING ON GROEP.beschrijving_id_fk = BESCHRIJVING.besch_id
INNER JOIN IMAGE ON GROEP.image_id_fk = IMAGE.image_id
WHERE PRODUCT.zichtbaar = true AND PRODUCT.isUitgeleend = false
GROUP BY GROEP.naam, MERK.naam, PRODUCT.opmerkingen, BESCHRIJVING.naam, IMAGE.image_data”);

$stmt->execute();

$result = $stmt->get_result();

$data = [];
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
$data[] = $row;
}
}

$stmt->close();

echo json_encode($data);
}
?>