static function get($id) { $pdo = PDOBuilder::getPDO(); $stmt = $pdo->prepare("SELECT * FROM PROVIDERS WHERE ID = :id"); if ($stmt->execute(array(':id' => $id))) { if ($row = $stmt->fetch()) { $prov = ProvidersService::buildDBprov($row); return $prov; } } return null; }