public function view_product($name)
{
$sql = <<<sql
SELECT
p.name name,
c.name category,
p.details details
FROM products p
JOIN
categories c
ON
p.category_id = c.id
WHERE p.name = :name
LIMIT 1
sql;
$data = ['name' => $name];
try {
return $this->select_one_rec($sql, $data);
} catch (Exception $e) {
Debig::msg($e->getMessage());
}
}
