The search feature in DataBridge is much more complete. It handles things like repeat spaces, grouping with quotes, AND or OR type searches and it is more efficient in the query building. However a quick and dirty hand coded version might look like:
php:
<?php
$keyArr = array();
if (isset($_GET["keywords"])) {
$keyArr = explode($_GET["keywords"]," ");
}
?>
<?php
$ApplicantProfile = new WA_MySQLi_RS("ApplicantProfile",$conn_i,30);
$ApplicantProfile->setQuery("SELECT infos.email, infos.nom, infos.prenom, infos.niveau, infos.localisation, infos.pays, infos.secteur1, infos.secteur2, infos.secteur3, infos.photo, infos.titre_cv1, infos.cv1, infos.langue_cv1, infos.dip1, infos.obtention1, infos.fichier1, infos.dip2, infos.obtention2, infos.fichier2, infos.dip3, infos.obtention3, infos.fichier3, infos.Statut, flag1.flag AS fl1, flag2.flag AS fl2 FROM infos, (select * from pays_world) AS flag1, (select * from pays_world) AS flag2 WHERE infos.Statut = 'APPROVED' AND infos.localisation=CONCAT(flag1.fr,' - ',flag1.en) AND infos.pays=CONCAT(flag2.fr,' - ',flag2.en)");
if (sizeof($keyArr) > 0) $ApplicantProfile->Statement .= " AND (";
for ($x=0; $x<sizeof($keyArr); $x++) {
if ($x>0) $ApplicantProfile->Statement .= " OR ";
$ApplicantProfile->Statement .= "(CONCAT(infos.email,' ', infos.nom, ' ', infos.prenom, ' ', infos.niveau, ' ', infos.localisation, ' ', infos.pays, ' ', infos.secteur1, ' ', infos.secteur2, ' ', infos.secteur3, ' ', infos.titre_cv1, ' ', infos.Statut) LIKE ?)";
$ApplicantProfile->bindParam("c", "".($keyArr[$x]) ."", ""); //colname
}
if (sizeof($keyArr) > 0) $ApplicantProfile->Statement .= ")";
$ApplicantProfile->execute();
?>
Did this help? Tips are appreciated...
