1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
|
$query = "SELECT
cl.client_id,
cl.client_uniqid,
cl.client_prenom,
cl.client_nom,
cl.client_entreprise,
cl.client_siteweb,
cl.client_mail,
AES_DECRYPT(cl.client_telephone, '".SALT."') AS client_telephone,
AES_DECRYPT(cl.client_cellulaire, '".SALT."') AS client_cellulaire,
AES_DECRYPT(cl.client_bureau, '".SALT."') AS client_bureau,
AES_DECRYPT(cl.client_bureau_ext, '".SALT."') AS client_bureau_ext,
AES_DECRYPT(cl.client_fax, '".SALT."') AS client_fax,
AES_DECRYPT(cl.client_adresse, '".SALT."') AS client_adresse,
cl.client_ville,
cl.client_zipcode,
AES_DECRYPT(cl.client_cp, '".SALT."') AS client_cp,
cl.client_ajouter,
cl.client_modifier
FROM clients AS cl
INNER JOIN responsable_client AS rc
ON rc.client_id = cl.client_id
INNER JOIN responsables
ON responsables.responsable_id = rc.responsable_id
WHERE cl.client_uniqid = ?
"; |
Partager