1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
<?php require_once('Connections/conn_i.php'); ?>
<?php
$EventList = new WA_MySQLi_RS("EventList",$conn_i,20);
$EventList->setQuery("SELECT evenement.ID, evenement.type, evenement.Reference, evenement.NomEvenement, evenement.StartDate, evenement.EndDate, evenement.Location, evenement.Pays, evenement.`Description`, evenement.Attachment1, evenement.Attachment2, evenement.Websitelink, evenement.ProgramVideoLink, evenement.todays_date, evenement.Email, evenement.Statut, infos_firm.email, infos_firm.nom, infos_firm.photo, pays_world.flag FROM evenement, infos_firm, pays_world WHERE infos_firm.email = evenement.Email AND evenement.Pays = CONCAT(pays_world.fr,' - ',pays_world.en) AND DATEDIFF(evenement.EndDate,CURDATE()) > 0 AND evenement.Statut='APPROVED'");
if (sizeof($keyArr) > 0) $EventList->Statement .= " AND (";
for ($x=0; $x<sizeof($keyArr); $x++) {
if ($x>0) $EventList->Statement .= " AND ";
$EventList->Statement .= "(CONCAT(evenement.type,' ', evenement.Reference, ' ', infos_firm.nom, ' ', evenement.NomEvenement, ' ', evenement.Location, ' ', evenement.Pays, ' ', evenement.`Description`, ' ', evenement.StartDate, ' ', evenement.EndDate) LIKE ?)";
$EventList->bindParam("c", "".($keyArr[$x]) ."", " "); //colname
}
if (sizeof($keyArr) > 0) $EventList->Statement .= ")";
$EventList->execute();
?> |
