Exemple de requete sql

requete sql 1

  try {	
		$sqlResquest = 'SELECT u1.user_id as user_id1, 
						u1.user_fname as user_fname1, 
						u1.user_lname as user_lname1, 
						u1.user_email as user_email1, 
						u1.user_duos as user_duos1, 
						u1.user_answers as user_answers1, 
						u1.user_img as user_img1,
						d.duo_status as duo_status,
						d.duo_id as duo_id,
						u1.user_id as user_id2, 
						u2.user_fname as user_fname2, 
						u2.user_lname as user_lname2, 
						u2.user_email as user_email2, 
						u2.user_duos as user_duos2, 
						u2.user_answers as user_answers2, 
						u2.user_img as user_img2
                        FROM cf_duos d 
                        INNER JOIN cf_users u1  ON (u1.user_id = d.user_1_id)
						INNER JOIN cf_users u2  ON (u2.user_id = d.user_2_id)
						WHERE d.duo_id IN ('.$otherIds.')';
                        
		$reponse = $bdd->query($sqlResquest);
		$i = 0;
		while ($data = $reponse->fetch()){
			if($data['user_id1'] == $_SESSION['user']){
				$duo = array( 
							user =>array(
								id =>$data['user_id2'],
								fname =>$data['user_fname2'],
								lname =>$data['user_lname2'],
								email =>$data['user_email2'],
								duos =>$data['user_duos2'],
								answers =>$data['user_answers2'],
								img =>$data['user_img2'],
							),
							duoStatus =>array(
								status =>$data['duo_status'],
							),
						);
			}else if ($data['user_id2'] == $_SESSION['user']){
				$duo = array( 
							user =>array(
								id =>$data['user_id1'],
								fname =>$data['user_fname1'],
								lname =>$data['user_lname1'],
								email =>$data['user_email1'],
								duos =>$data['user_duos1'],
								answers =>$data['user_answers1'],
								img =>$data['user_img1'],
							),
							duoStatus =>array(
								status =>$data['duo_status'],
							),
						);
			}
			$duos[$i] = $duo; 
		    $i++;
		}
		echo json_encode($duos) ;
		$reponse->closeCursor();

	} catch (PDOException $e) {
		echo '{"error":{"text":'. $e->getMessage() .'}}';	
	}