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; }