"; //STEP 1 : search with lastname (physical contact) $query = "SELECT contact_type, society, lastname, firstname, contact_id, is_corporate_person, society_short FROM contacts_v2 WHERE is_corporate_person = 'N' AND enabled = 'Y' AND enabled = 'Y' AND (LOWER(translate(lastname,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) LIKE LOWER(translate(?,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr'))) ORDER BY lastname,firstname ASC"; $arrayPDO = array('%'.$_REQUEST['what'].'%'); $stmt = $db->query($query, $arrayPDO); $nb_step1 = $stmt->rowCount(); $m = 30; if ($nb_step1 >= $m) $l = $m; else $l = $nb_step1; $found = false; for ($i=0; $i<$l; $i++) { $res = $stmt->fetchObject(); if(!empty($res->society)){ $arr_contact_info = array($res->firstname,$res->lastname,'('.$res->society.')'); }else{ $arr_contact_info = array($res->firstname,$res->lastname); } $contact_info = implode(' ', $arr_contact_info); if ($i%2==1) $color = 'LightYellow'; else $color = 'white'; echo "
• " . '' . str_replace($args, $args_bold, $contact_info) . '' ."
"; } //STEP 2 : search with society(physical contact) $query = "SELECT contact_id,firstname,lastname,society FROM contacts_v2 WHERE is_corporate_person = 'N' AND enabled = 'Y' AND (LOWER(translate(society,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) LIKE LOWER(translate(?,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) OR LOWER(translate(society_short,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) LIKE LOWER(translate(?,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr'))) ORDER BY society,lastname,firstname ASC"; $arrayPDO = array('%'.$_REQUEST['what'].'%','%'.$_REQUEST['what'].'%'); $stmt = $db->query($query, $arrayPDO); $nb_step3 = $stmt->rowCount(); $m = 30; if ($nb_step3 >= $m) $l = $m; else $l = $nb_step3; $found = false; for ($i=0; $i<$l; $i++) { $res = $stmt->fetchObject(); if(!empty($res->society)){ $arr_contact_info = array($res->firstname,$res->lastname,'('.$res->society.')'); }else{ $arr_contact_info = array($res->firstname,$res->lastname); } $contact_info = implode(' ', $arr_contact_info); if ($i%2==1) $color = 'LightYellow'; else $color = 'white'; echo "
• " . '' . str_replace($args, $args_bold, $contact_info) . '' ."
"; } /////////////////////// //STEP 3 : search with society(corporate contact) $query = "SELECT contact_id, society FROM contacts_v2 WHERE is_corporate_person = 'Y' AND enabled = 'Y' AND (LOWER(translate(society,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) LIKE LOWER(translate(?,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) OR LOWER(translate(society_short,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) LIKE LOWER(translate(?,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr'))) ORDER BY society ASC"; $arrayPDO = array('%'.$_REQUEST['what'].'%','%'.$_REQUEST['what'].'%'); $stmt = $db->query($query, $arrayPDO); $nb_step4 = $stmt->rowCount(); $m = 30; if ($nb_step4 >= $m) $l = $m; else $l = $nb_step4; $found = false; for ($i=0; $i<$l; $i++) { $res = $stmt->fetchObject(); if ($i%2==1) $color = 'LightYellow'; else $color = 'white'; echo "
• " . ''. str_replace($args, $args_bold, $res->society) .'' ."
"; } /////////////////////// //STEP 4 : search with other informations (physical contact) $query = "SELECT contact_id,firstname,lastname,function FROM contacts_v2 WHERE is_corporate_person = 'N' AND enabled = 'Y'" ." AND (LOWER(translate(firstname,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) LIKE LOWER(translate(?,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr'))" ." OR LOWER(translate(function,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) LIKE LOWER(translate(?,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr'))) ORDER BY society,lastname,firstname ASC"; $arrayPDO = array('%'.$_REQUEST['what'].'%','%'.$_REQUEST['what'].'%'); $stmt = $db->query($query, $arrayPDO); $nb_step5 = $stmt->rowCount(); $m = 30; if ($nb_step5 >= $m) $l = $m; else $l = $nb_step5; $found = false; for ($i=0; $i<$l; $i++) { $res = $stmt->fetchObject(); if(!empty($res->society)){ $arr_contact_info = array($res->firstname,$res->lastname,'('.$res->society.')'); }else{ $arr_contact_info = array($res->firstname,$res->lastname); } $contact_info = implode(' ', $arr_contact_info); if ($i%2==1) $color = 'LightYellow'; else $color = 'white'; echo "
• " . '' . str_replace($args, $args_bold, $contact_info) . '' ."
"; } /////////////////////// if($nb_step1 == 0 && $nb_step2 == 0 && $nb_step3 == 0 && $nb_step4 == 0 && $nb_step5 == 0 && $nb_step6 == 0) echo "
"; echo "

...".$nb_total." résulats au total

Aucun résultat trouvé.