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
48
49
50
51
52
53
54
55
56
57
58
59
60
|
<?php
//Update database information according to your server settings
include("../dbs/dbcon.php");
$per_page = 5;
$sqlc = "show columns from records";
$rsdc = mysql_query($sqlc);
$cols = mysql_num_rows($rsdc);
$page = $_REQUEST['page'];
$start = ($page-1)*5;
$query=mysql_query("SELECT e.nom as nom1,v.nom as nom2,e.date,e.meteo,e.temp,v.departement FROM evenement e LEFT JOIN ville v ON e.ville = v.id order by e.id limit $start,5");
echo '<div>';
echo '<a href="#">< </a> Semaine du xx au xx <a href="#">></a>';
echo '</div>';
echo '<div class="clss_tab">
<div class="clss_row">
<div class="clss_dct">
<div class="clss_date">Date</div>
<div class="clss_time">Heure</div>
</div>
<div class="clss_cnt">
<div class="clss_event">Evénement</div>
<div class="clss_city">Ville</div>
</div>
<div class="clss_tmps">Météo</div>
</div>';
while($row=mysql_fetch_assoc($query)){
//display question
echo '<div class="clss_row">
<div class="clss_dct">';
$data= strtotime($row['date']);
$jours = Array('Dimanche', 'Lundi', 'Mardi', 'Mercredi', 'Jeudi', 'Vendredi', 'Samedi');
echo '<div class="clss_date">'.date('d/m/Y' ,$data).'</div>
<div class="clss_time">'.date('H:i' ,$data).'</div>
</div>
<div class="clss_cnt">
<div class="clss_event">'.utf8_encode($row['nom1']).'</div>
<div class="clss_city">'.utf8_encode($row['nom2']).'('.$row['departement'].')</div>
</div>
<div class="clss_tmps">
<div style="clss_picto">
'.$row['meteo'].'
<br>
</div>
<div class="clss_tdg">'.$row['temp'].'</div>
</div>
</div>';
}
echo '</div>';
?> |
