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
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
| <section id="leftside" style="width:640px;float:left;">
<?php
if(!isset($_POST['Filtrer'])){
$sql = 'SELECT * FROM events INNER JOIN eventgenre ON eventgenre.id_genre=events.id_genre WHERE year_event=2015 ORDER BY dateEvent ASC' ;
$resultat = mysql_query($sql)or die(mysql_error());
}else{
if(!isset($_POST['sort'])){
$sql = 'SELECT * FROM events INNER JOIN eventgenre ON eventgenre.id_genre=events.id_genre WHERE year_event=2015 ORDER BY dateEvent ASC' ;
$resultat = mysql_query($sql) or die(mysql_error());
}else{
$sort=$_POST['sort'];
$sql = 'SELECT * FROM events INNER JOIN eventgenre ON eventgenre.id_genre=events.id_genre WHERE ';
if (!empty($_POST['sort'])) {
$sql .= 'events.id_genre IN ('.implode(', ', array_map('intval', $_POST['sort'])).') AND ';
}
$sql .= ' year_event=2015 ORDER BY dateEvent ASC' ;
$resultat = mysql_query($sql) or die(mysql_error());
}
}
?>
<ul style="list-style:none;">
<?php
while ( $donnee = mysql_fetch_assoc($resultat) ) {
?><li>
<?php echo $donnee['libelle']; ?><br />
<?php echo $donnee['titre_event']; ?>
</li><hr><?php
}
?>
</ul>
</section>
<section id="rightside" style="width:330px;float:right;" >
<form id="trier" method="post" action="index.php" style="width:300px;">
<input type="checkbox" name="sort[]" id="salon" value="1"
<?php if($_POST && in_array('1',$sort)){ echo "checked";} ?>
/><label>Salon</label><br />
<input type="checkbox" name="sort[]" id="expo" value="2"
<?php if($_POST && in_array('2',$sort)){ echo "checked";} ?>
/><label>Exposition</label><br />
<input type="checkbox" name="sort[]" id="foire" value="3"
<?php if($_POST && in_array('3',$sort)){ echo "checked";} ?>
/><label>Foire</label><br />
<input type="submit" value="Filtrer"/>
</form>
</section> |
