query("SELECT * FROM lebensmittel WHERE lebensmittel_id = '$lebensmittel_id';");
if ($result = $response->fetch_assoc()) {
$namen = $result['namen'];
$kalorien = $result['kalorien'];
$kohlenhydrate = $result['kohlenhydrate'];
$fett = $result['fett'];
$protein = $result['protein'];
$zucker = $result['zucker'];
} else {
$url = 'https://api.webapp.prod.blv.foodcase-services.com/BLV_WebApp_WS/webresources/BLV-api/food/' . $lebensmittel_id . '?lang=de';
$ch = curl_init();
$curl_options = [
CURLOPT_URL => $url,
CURLOPT_HEADER => false,
CURLOPT_RETURNTRANSFER => true,
];
curl_setopt_array($ch, $curl_options);
$response = curl_exec($ch);
curl_close($ch);
$result = json_decode($response, true);
$namen = $result['name'];
$werte = $result['values'];
foreach ($werte as $wert) {
if ($wert['component']['code'] == 'ENERCC') {
$kalorien = $wert['value'];
} else if ($wert['component']['code'] == 'CHO') {
$kohlenhydrate = $wert['value'];
} else if ($wert['component']['code'] == 'FAT') {
$fett = $wert['value'];
} else if ($wert['component']['code'] == 'PROT625') {
$protein = $wert['value'];
} else if ($wert['component']['code'] == 'SUGAR') {
$zucker = $wert['value'];
}
}
$datenbank->query("INSERT INTO lebensmittel VALUES ('$lebensmittel_id', '$namen', '$kalorien', '$kohlenhydrate', '$fett', '$protein', '$zucker')");
}
}
?>
Lebensmittel hinzufügen
Kohlenhydrate
gramm / 100 gramm
Protein
gramm / 100 gramm
hinzufügen