コード例 #1
0
ファイル: identity.php プロジェクト: MatthewAry/php-cs313
 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;
 }