Exemplos de pagination::get_page em PHP

Exemplo n.º 1

Arquivo: rechercher_v.php Projeto: ATS001/PRSIT

?>
   </h1>


     

 <?php 
global $db;
$records_per_page = 100;
$pagination = new pagination();
if (!$db->Query("SELECT id  , titr" . LANG . " as titre ,document ,dat , modul from contenu where   titr" . LANG . " LIKE  '%" . tp('mot') . "%' or  cont" . LANG . " LIKE  '%" . tp('mot') . "%' order by  id DESC  ")) {
    $db->Kill('Error1s');
}
if ($db->RowCount() > 0) {
    $totalrow = $db->RowCount();
    if (!$db->Query("SELECT id  , titr" . LANG . " as titre ,document ,dat , modul from contenu where   titr" . LANG . " LIKE  '%" . tp('mot') . "%' or  cont" . LANG . " LIKE  '%" . tp('mot') . "%' order by  id DESC    limit " . ($pagination->get_page() - 1) * $records_per_page . ', ' . $records_per_page)) {
        $db->Kill('Error1s');
    }
    $pagination->records($totalrow);
    $pagination->records_per_page($records_per_page);
    ?>

     <div class="sidebar"> 
        <!-- ################################################################################################ -->
       <article>

        <nav class="sdb_holder">
          <ul>
          <?php 
    while (!$db->EndOfSeek()) {
        $row = $db->Row();

Exemplo n.º 2

Arquivo: lstcom_v.php Projeto: ATS001/PRSIT

<div class="postcontent"><h2><?php 
echo lg('PLUSCOM');
?>
</h2>
<link rel="stylesheet" href="css/zebra_pagination.css" type="text/css">
 <?php 
global $db;
$records_per_page = 8;
$pagination = new pagination();
if (!$db->Query("SELECT titr" . LANG . " as titre ,id,app,DATE_FORMAT(dat,'%d-%m-%Y') as dat,cont" . LANG . " as content from communique   where titr" . LANG . " IS NOT NULL  order by id DESC")) {
    $db->Kill('Error1s');
}
if ($db->RowCount() > 0) {
    $totalrow = $db->RowCount();
    $requet = "SELECT titr" . LANG . " as titre ,id,app,DATE_FORMAT(dat,'%d-%m-%Y') as dat,cont" . LANG . " as content from communique   where titr" . LANG . " IS NOT NULL  order by id DESC limit " . ($pagination->get_page() - 1) * $records_per_page . ', ' . $records_per_page;
    if (!$db->Query($requet)) {
        $db->Kill($requet);
    }
    $pagination->records($totalrow);
    $pagination->records_per_page($records_per_page);
    ?>


            <?php 
    $index = 0;
    ?>

            <?php 
    while (!$db->EndOfSeek()) {
        $row = $db->Row();
        ?>

Exemplo n.º 3

Arquivo: lstnews_v.php Projeto: ATS001/PRSIT

<div class="span9">
<div class="postcontent"><h2><?php 
echo lg('PLUSACT');
?>
</h2>
<link rel="stylesheet" href="css/zebra_pagination.css" type="text/css">
 <?php 
global $db;
$records_per_page = 6;
$pagination = new pagination();
if (!$db->Query("SELECT titr" . LANG . " as titre ,id,img,app,DATE_FORMAT(dat,'%d-%m-%Y') as dat,cont" . LANG . " as content from news   where titr" . LANG . " IS NOT NULL and flash = 0 order by id DESC")) {
    $db->Kill('Error1s');
}
if ($db->RowCount() > 0) {
    $totalrow = $db->RowCount();
    $requet = "SELECT titr" . LANG . " as titre,aut" . LANG . " as autor ,id,img,app,DATE_FORMAT(dat,'%d-%m-%Y') as dat,cont" . LANG . " as content from news   where titr" . LANG . " IS NOT NULL and flash = 0 order by id DESC limit " . ($pagination->get_page() - 1) * $records_per_page . ', ' . $records_per_page;
    if (!$db->Query($requet)) {
        $db->Kill($requet);
    }
    $pagination->records($totalrow);
    $pagination->records_per_page($records_per_page);
    ?>


            <?php 
    $index = 0;
    ?>

            <?php 
    while (!$db->EndOfSeek()) {
        $row = $db->Row();

Exemplo n.º 4

Arquivo: recherche_v.php Projeto: ATS001/PRSIT

        echo $post;
        ?>
" a retourné <?php 
        if ($db->RowCount() > 0) {
            echo $db->RowCount();
        } else {
            echo "0";
        }
        ?>
 résultats</p>
	</div>
<?php 
        if ($db->RowCount() > 0) {
            $totalrow = $db->RowCount();
            // nombre d'enregistrement dans une table retourner par mysql_num_rows() par exemple ou autre ,
            if (!$db->Query("SELECT titr" . LANG . " as titre ,id,app,cont" . LANG . " as content from " . $mode . "   where  titr" . LANG . " like '%" . $post . "%'  or cont" . LANG . " like '%" . $post . "%' limit " . ($pagination->get_page() - 1) * $records_per_page . ', ' . $records_per_page)) {
                $db->Kill('Error1s');
            }
            $pagination->records($totalrow);
            $pagination->records_per_page($records_per_page);
            while (!$db->EndOfSeek()) {
                $row = $db->Row();
                $applic = $row->app;
                if (tg('m') == 4) {
                    $mode = 'com';
                }
                ?>
<div id="act" style="height:auto; max-height:93; min-height:35;">
        <a class="titactp" href="./<?php 
                echo $mode . '-' . $row->id . '-' . fl($row->titre) . '.html';
                ?>

Exemplo n.º 5

Arquivo: docx_v.php Projeto: ATS001/PRSIT

    }
    if (tp('jour') != 0) {
        $wher .= " and  DAY(dat) = " . tp('jour');
    }
    if (tp('motcle') != '') {
        $wher .= " and  titr" . LANG . " LIKE  '%" . tp('motcle') . "%'";
    }
    if (tp('mois') != 0) {
        $wher .= " and  MONTH(dat) = " . tp('mois');
    }
    if (!$db->Query("SELECT id  , titr" . LANG . " as titre ,document ,dat from contenu where  titr" . LANG . " IS NOT NULL   and modul=" . tg('id') . "  {$wher}  order by  id DESC  ")) {
        $db->Kill('Error1s');
    }
    if ($db->RowCount() > 0) {
        $totalrow = $db->RowCount();
        if (!$db->Query("SELECT id  , titr" . LANG . " as titre ,document , dat from contenu where  titr" . LANG . " IS NOT NULL    and modul=" . tg('id') . "  {$wher}  order by  id DESC  limit " . ($pagination->get_page() - 1) * $records_per_page . ', ' . $records_per_page)) {
            $db->Kill('Error1s');
        }
        $pagination->records($totalrow);
        $pagination->records_per_page($records_per_page);
        ?>

     <div class="sidebar"> 
        <!-- ################################################################################################ -->
       <article>

        <nav class="sdb_holder">
          <ul>
          <?php 
        while (!$db->EndOfSeek()) {
            $row = $db->Row();

Exemplo n.º 6

Arquivo: lien_v.php Projeto: ATS001/PRSIT

<div class="postcontent"><h2><?php 
echo lg('LIEN');
?>
</h2>

<?php 
global $db;
$records_per_page = 16;
$pagination = new pagination();
if (!$db->Query("SELECT titr" . LANG . " as titre ,id from lienu   where titr" . LANG . " IS NOT NULL order by id ")) {
    $db->Kill('Error1s');
}
if ($db->RowCount() > 0) {
    $totalrow = $db->RowCount();
    if (!$db->Query("SELECT titr" . LANG . " as titre ,id,lien from lienu   where titr" . LANG . " IS NOT NULL order by id  limit  " . ($pagination->get_page() - 1) * $records_per_page . ', ' . $records_per_page)) {
        $db->Kill('Error1s');
    }
    $pagination->records($totalrow);
    $pagination->records_per_page($records_per_page);
    ?>

<div class="pj">
<ul>
<?php 
    while (!$db->EndOfSeek()) {
        $row = $db->Row();
        //	$class=	str_replace(".","",strrchr($row->img,'.'));
        ?>
     <li class="lien"><a href="http://<?php 
        echo $row->lien;
        ?>

Exemplo n.º 7

Arquivo: docx_v.php Projeto: ATS001/PRSIT

 <div class="span9" >
<div class="postcontent"><h2><?php 
echo lg('DOCX');
?>
</h2>

<?php 
global $db;
$records_per_page = 16;
$pagination = new pagination();
if (!$db->Query("SELECT titr" . LANG . " as titre ,id,img from document  where titr" . LANG . " IS NOT NULL  order by id DESC")) {
    $db->Kill('Error1s');
}
if ($db->RowCount() > 0) {
    $totalrow = $db->RowCount();
    if (!$db->Query("SELECT titr" . LANG . " as titre ,id,img from document  where titr" . LANG . " IS NOT NULL order by id DESC limit " . ($pagination->get_page() - 1) * $records_per_page . ', ' . $records_per_page)) {
        $db->Kill('Error1s');
    }
    $pagination->records($totalrow);
    $pagination->records_per_page($records_per_page);
    ?>

<div class="pj">
<ul>
<?php 
    while (!$db->EndOfSeek()) {
        $row = $db->Row();
        $class = str_replace(".", "", strrchr($row->img, '.'));
        ?>
<li class="<?php 
        echo $class;

Exemplo n.º 8

Arquivo: synthese_v.php Projeto: ATS001/PRSIT

?>
</h1>


 

 <?php 
global $db;
$records_per_page = 100;
$pagination = new pagination();
if (!$db->Query("SELECT id  , titr" . LANG . " as titre  from synthese where  titr" . LANG . " IS NOT NULL      order by  id DESC  ")) {
    $db->Kill('Error1s');
}
if ($db->RowCount() > 0) {
    $totalrow = $db->RowCount();
    if (!$db->Query("SELECT id  , titr" . LANG . " as titre  from synthese where  titr" . LANG . " IS NOT NULL      order by  id DESC   limit " . ($pagination->get_page() - 1) * $records_per_page . ', ' . $records_per_page)) {
        $db->Kill('Error1s');
    }
    $pagination->records($totalrow);
    $pagination->records_per_page($records_per_page);
    ?>

     <div class="sidebar"> 
        <!-- ################################################################################################ -->
       <article>

        <nav class="sdb_holder">
          <ul>
          <?php 
    while (!$db->EndOfSeek()) {
        $row = $db->Row();

Exemplo n.º 9

Arquivo: video_v.php Projeto: ATS001/PRSIT

 <div class="span9">
 <div class="postcontent"><h2><?php 
echo lg('GVIDEO');
?>
</h2>
 <?php 
global $db;
$records_per_page = 9;
$pagination = new pagination();
if (!$db->Query("SELECT titr" . LANG . " as titre ,vod" . LANG . " as vod,id from vod   where vod" . LANG . " IS NOT NULL order by id DESC")) {
    $db->Kill('Error1s');
}
if ($db->RowCount() > 0) {
    $totalrow = $db->RowCount();
    if (!$db->Query("SELECT titr" . LANG . " as titre ,vod" . LANG . " as vod,id from vod   where vod" . LANG . " IS NOT NULL order by id DESC limit " . ($pagination->get_page() - 1) * $records_per_page . ', ' . $records_per_page)) {
        $db->Kill('Error1s');
    }
    $pagination->records($totalrow);
    $pagination->records_per_page($records_per_page);
    ?>

<link rel="stylesheet" href="css/zebra_pagination.css" type="text/css">
	

<?php 
    while (!$db->EndOfSeek()) {
        $row = $db->Row();
        ?>

 <div id="contvod">
 <a class="youtube titvod" href="http://www.youtube.com/embed/<?php 

Exemplo n.º 10

Arquivo: decrets_v.php Projeto: ATS001/PRSIT

 

 <?php 
global $db;
$records_per_page = 70;
$wher = '';
$pagination = new pagination();
if (tp('motcle') != '') {
    $wher .= " and  titr" . LANG . " LIKE  '%" . tp('motcle') . "%'";
}
if (!$db->Query("SELECT id  , titr" . LANG . " as titre , img   from document where  article = 84 and   titr" . LANG . " IS NOT NULL  {$wher}     order by  id DESC  ")) {
    $db->Kill('Error1s');
}
if ($db->RowCount() > 0) {
    $totalrow = $db->RowCount();
    if (!$db->Query("SELECT id  , titr" . LANG . " as titre , img   from document where  article = 84 and   titr" . LANG . " IS NOT NULL  {$wher}    order by  id DESC    limit " . ($pagination->get_page() - 1) * $records_per_page . ', ' . $records_per_page)) {
        $db->Kill('Error1s');
    }
    $pagination->records($totalrow);
    $pagination->records_per_page($records_per_page);
    ?>

     <div class="sidebar"> 
        <!-- ################################################################################################ -->
       <article>

        <nav class="sdb_holder">
          <ul>
          <?php 
    while (!$db->EndOfSeek()) {
        $row = $db->Row();

Exemplo n.º 11

Arquivo: photoshow_v.php Projeto: ATS001/PRSIT

 
<div id="content" class="three_quarter"> 
<?php 
if (tg('id') != '') {
    $id = tg('id');
    $titre = tg('titre');
    global $db;
    $records_per_page = 9;
    $pagination = new pagination();
    if (!$db->Query("SELECT titr" . LANG . " as titre ,id from album where titr" . LANG . " IS NOT NULL   and arch <> 1  order by id DESC  ")) {
        $db->Kill('Error1s');
    }
    if ($db->RowCount() > 0) {
        $totalrow = $db->RowCount();
        if (!$db->Query("SELECT titr" . LANG . " as titre ,id from album where titr" . LANG . " IS NOT NULL   and arch <> 1  order by id DESC  limit " . ($pagination->get_page() - 1) * $records_per_page . ', ' . $records_per_page)) {
            $db->Kill('Error1s');
        }
        $pagination->records($totalrow);
        $pagination->records_per_page($records_per_page);
        ?>
 
 <h1  ><?php 
        echo lg('GALPHOTOS');
        ?>
 </h1>
 <div id="gallery">
        <figure>
        
          <article>
           
           <ul class="nospace clear">