1/ -> executer : "select last_insert_id(UserID) AS Id_last from users;"
=> $Id_last = $result['Id_last'];
2/ -> executer : "select telephone FROM telephone where telephone like '%$search%'"
=> $tel_search = $result['telephone'];
3/ la "grosse" requete :
SELECT `civilite`, `name`,`prenom`, `score`,`telephone` FROM `users`
Left Join users_Adresse_link ON users.UserID=users_Adresse_link.UserID
Left Join Adresse ON Adresse.AdresseID=users_Adresse_link.AdresseID
Left Join users_telephone_link ON users.UserID= users_telephone_link.UserID
Left Join telephone ON telephone.telephoneID= users_telephone_link.telephoneID
WHERE users.UserID = '".$Id_last."'
AND telephone.telephone = '%".$tel_search."%' ORDER BY users.USERID DESC LIMIT 1 ;
4/ on récupère donc le telephone de CET utilisateur !
$tel_user_from_bd = ...;
$search -> c'est le tel à vérifier
5/ on a juste à comparer $tel_user_from_bd et $search (en php) :
if(strpos ( $tel_user_from_bd , $search )) {
...
Partager