<?php
class Cookpedia_Entry {
private $data = [
'id' => 0,
'title' => null,
'latin_title' => null,
'category' => 0,
'calories' => 0,
'proteins' => 0,
'fats' => 0,
'carbohydrates' => 0,
'description' => null,
'tags' => null,
'measures' => [],
];
public function hydrate(PDO $dbh, int $id): void
{
$stmt = $dbh->prepare("SELECT `title`, `latin_title`, `category`, `calories`, `proteins`, `fats`, `carbohydrates`, `description`, `measures`, `tags` FROM `cook_encyclopedia_entries` WHERE `id`=:id");
$result = $stmt->execute($id);
$this->data = $result->fetch(PDO::FETCH_ASSOC);
}
public function getData(): array
{
return $this->data;
}
public function getMeasures(): array
{
$measures = explode('|',$this->data['measures']);
return [
'g_in_tsp' => $measures[0],
'g_in_tbsp' => $measures[1],
'g_in_glass' => $measures[2],
'g_in_cup' => $measures[3],
];
}
}
preferences:
27.36 ms | 402 KiB | 5 Q