static function get($id)
{
$pdo = PDOBuilder::getPDO();
$stmt = $pdo->prepare("SELECT * FROM PRODUCTS LEFT JOIN PRODUCTS_CAT " . "ON PRODUCTS_CAT.PRODUCT = PRODUCTS.ID WHERE ID = :id");
if ($stmt->execute(array(':id' => $id))) {
if ($row = $stmt->fetch()) {
$prd = ProductsService::buildDBPrd($row, $pdo);
return $prd;
}
}
return null;
}
