public static function findByType($type) { if (is_string($type)) { switch ($type) { case 'student': $type = 1; break; case 'contact': $type = 2; break; case 'teacher': $type = 3; break; default: return false; break; } } $db = DB::getInstance(); $request = $db->prepare('SELECT * FROM identity WHERE type = :type'); $request->bindParam(":type", $type, PDO::PARAM_INT); if (!$request->execute()) { return false; } $list = []; foreach ($request->fetchAll() as $i) { $item = new Identity($i['id'], $i['first_name'], $i['middle_name'], $i['last_name'], $i['gender'], $i['email'], $i['id_Image_uri'], $i['type']); $list[] = $item->getValues(); } return $list; }