1. <?php
3.     include("include/config.php" );
4.     include("include/functions/import.php" );
5.     $thebaseurl = $config['baseurl'];
7.     $page = intval($_REQUEST[page]);
9.     $s = stripslashes(strip_tags($_REQUEST['s']));
10.     STemplate::assign('s',$s);
11.     if($s == "t" )
12.     {
13.        $ftime = time() - (24 * 60 * 60);
14.        $addsql .= " AND time_added>='$ftime'";
15.        $addsql2 .= " AND A.time_added>='$ftime'";
16.     }
17.     elseif($s == "w" )
18.     {
19.        $ftime = time() - (7 * 24 * 60 * 60);
20.        $addsql .= " AND time_added>='$ftime'";
21.        $addsql2 .= " AND A.time_added>='$ftime'";
22.     }
23.     elseif($s == "m" )
24.     {
25.        $ftime = firstDayOfMonth2();
26.        $addsql .= " AND time_added>='$ftime'";
27.        $addsql2 .= " AND A.time_added>='$ftime'";
28.     }
29.     elseif($s == "y" )
30.     {
31.        $ftime = firstDayOfYear2();
32.        $addsql .= " AND time_added>='$ftime'";
33.        $addsql2 .= " AND A.time_added>='$ftime'";
34.     }
36.     if($page=="" )
37.     {
38.        $page = "1";
39.     }
40.     $currentpage = $page;
42.     if ($page >=2)
43.     {
44.        $pagingstart = ($page-1)*$config[items_per_page];
45.     }
46.     else
47.     {
48.        $pagingstart = "0";
49.     }
51.     $query1 = "SELECT count(*) as total from posts where active='1' $addsql order by time_added desc limit $config[maximum_results]";
52.     $query2 = "SELECT * from posts A, categories B where A.active='1' $addsql2 AND A.category=B.CATID order by A.time_added desc limit $pagingstart, $config[items_per_page]";
53.      
54.     $executequery1 = $conn->Execute($query1);
56.     $totalvideos = $executequery1->fields['total'];
57.     if ($totalvideos > 0)
58.     {
59.        if($executequery1->fields['total']<=$config[maximum_results])
60.        {
61.           $total = $executequery1->fields['total'];
62.        }
63.        else
64.        {
65.           $total = $config[maximum_results];
66.        }
67.      
68.        $toppage = ceil($total/$config[items_per_page]);
69.        if($toppage==0)
70.        {
71.           $xpage=$toppage+1;
72.        }
73.        else
74.        {
75.           $xpage = $toppage;
76.        }
77.      
78.        $executequery2 = $conn->Execute($query2);
79.        $posts = $executequery2->getrows();
80.        $beginning=$pagingstart+1;
81.        $ending=$pagingstart+$executequery2->recordcount();
82.        $pagelinks="";
83.        $k=1;
84.        $theprevpage=$currentpage-1;
85.        $thenextpage=$currentpage+1;
86.      
87.        if($s != "" )
88.        {
89.           $adds = "&s=$s";
90.        }
91.        if ($currentpage > 0)
92.        {
93.           if($currentpage > 1)
94.           {
95.              $pagelinks.="<a href='$thebaseurl/?page=1$adds'>$lang[64]</a>&nbsp;&nbsp;";
96.              $pagelinks.="...&nbsp;&nbsp;";
97.              $pagelinks.="<a href='$thebaseurl/?page=$theprevpage$adds'>&laquo; $lang[65]</a>&nbsp;&nbsp;";
98.              STemplate::assign('tpp',$theprevpage);
99.           }
100.          
101.           $counter=0;
102.          
103.           $lowercount = $currentpage-5;
104.           if ($lowercount <= 0) $lowercount = 1;
105.          
106.           while ($lowercount < $currentpage)
107.           {
108.              $pagelinks.="<a href='$thebaseurl/?page=$lowercount$adds'>$lowercount</a>&nbsp;&nbsp;";
109.              $lowercount++;
110.              $counter++;
111.           }
112.          
113.           $pagelinks.="<strong>$currentpage</strong>&nbsp;&nbsp;";
114.          
115.           $uppercounter = $currentpage+1;
116.          
117.           while (($uppercounter < $currentpage+10-$counter) && ($uppercounter<=$toppage))
118.           {
119.              $pagelinks.="<a href='$thebaseurl/?page=$uppercounter$adds'>$uppercounter</a>&nbsp;&nbsp;";
120.              $uppercounter++;
121.           }
122.          
123.           if($currentpage < $toppage)
124.           {
125.              $pagelinks.="<a href='$thebaseurl/?page=$thenextpage$adds'>$lang[66] &raquo;</a>&nbsp;&nbsp;";
126.              STemplate::assign('tnp',$thenextpage);
127.              $pagelinks.="...&nbsp;&nbsp;";
128.              $pagelinks.="<a href='$thebaseurl/?page=$toppage$adds'>$lang[67]</a>&nbsp;&nbsp;";
129.           }
130.        }
131.     }
133.     $templateselect = "index.tpl";
135.     //TEMPLATES BEGIN
136.     STemplate::assign('beginning',$beginning);
137.     STemplate::assign('ending',$ending);
138.     STemplate::assign('pagelinks',$pagelinks);
139.     STemplate::assign('total',$total);
140.     STemplate::assign('posts',$posts);
141.     STemplate::display('header.tpl');
142.     STemplate::display($templateselect);
143.     STemplate::display('footer.tpl');
144.     //TEMPLATES END
145.     ?>

$i = 0;
while (maCondition) {
  if ($i % 3 == 0) { // % est l'opérateur modulo
    // afficher bannière
  }
  ++$i;
}

1. $query1 = "SELECT count(*) as total from posts where active='1' $addsql order by time_added desc limit $config[maximum_results]";
2. $query2 = "SELECT * from posts A, categories B where A.active='1' $addsql2 AND A.category=B.CATID order by A.time_added desc limit $pagingstart, $config[items_per_page]";