Foros del Web - Ver Mensaje Individual

juan_14nob · #3 (**permalink**) 30/04/2012, 17:12

Entiendo..

Modificar las variables $option_to, $table, $field

$option_to es un INT para liminar la cantidad de registros a mostrar por pagina
$table = es nuestra tabla de la base de datos
$field = es nuestro campo de la bd

pagin.php

Código PHP:

Ver original<html>
<head>
<link rel="stylesheet" type="text/css" href="styles.css"></link> 
</head>
<body>
 
<?php
/*
*   Date:   29/04/2012
*/
 
 
//       ## Complete this Three vars 
$option_to = 4;
$table = "";
$field = "";
 
//connection at your databases
$connect = mysql_connect("localhost", "root", "") or die("Problemas en la conexion");
mysql_select_db("world", $connect) or die ("Problema al seleccionar bd");
 
 
 
if(isset($_GET['id'])){
    $id = $_GET['id'];
 
    $id2 = ($id * $option_to) - $option_to;  
 
}else{
    $id = 1;
    $id2 = 0;
}
 
$sql = "SELECT {$field} FROM {$table} LIMIT {$id2}, {$option_to}";
$query = mysql_query($sql,$connect) or die(mysql_error());
 
$query_count = mysql_query("SELECT {$field} FROM {$table}",$connect) or die(mysql_error());
 
while($con = mysql_fetch_array($query)){
 
    echo $con['nombre']."<br />";
}
 
$con = mysql_fetch_array($query);
 
$count_total = mysql_num_rows($query_count);
if($id == 1){
    $prev = "#";
}else{
    $id2 = $id - 1;
    $prev = "?id=".$id2;
}
?>
 
<div id="paginator">
<a href="pagin.php<?php echo $prev;?>"><</a>
<?php
 
$h = $id * $option_to;
 
if($count_total == 0){
    echo "no records";
}elseif($count_total <= $option_to){
 
    echo "<a class='idnow' href=pagin.php?id=1>1</a>";
    
}elseif($count_total >= $option_to+1 AND $count_total <= $option_to*2){
    echo "<a class='idnow' href=pagin.php?id=1>1</a>";
    echo "<a href=pagin.php?id=2>2</a>";
 
}elseif($id == 2 AND $count_total >= $option_to*2){
 
        $number_ini = $id - 1;
        $number_last = $id + 2;
        numbers_paginator($number_ini,$number_last,2);
 
}elseif($count_total > $option_to*2 AND $id != 1){
    if($h < $count_total){
 
        $number_ini = $id - 1;
        $number_last = $id + 2;
        numbers_paginator($number_ini,$number_last,2);
 
    }else{
 
        $number_ini = $id - 2;
        $number_last = $id + 1;
 
        numbers_paginator($number_ini,$number_last,3);
 
    }   
    
}elseif($id == 1 AND $count_total > $option_to*2){
 
    $number_last = $id + 3;
    
    numbers_paginator($id,$number_last,1);
}else{
    echo "<a href=pagin.php?id=1>1</a>";
    echo "<a href=pagin.php?id=2>2</a>";
 
}
 
// Calcular el avance
 
$ultimo = ceil($count_total / $option_to);
 
if($id == $ultimo){
    $next = "#";
}else{
    $id = $id+1;
    $next = "?id=".$id;
}
 
?>
 
    <a href="pagin.php<?php echo $next;?>">></a>
</div>
 
 
</div>
<?php
    function numbers_paginator($x1,$x2,$mark){
        $_i = 0;
        for($i=$x1;$i<$x2;$i++){
        $_i++;
        
            if($_i == $mark){
                echo "<a class='idnow' href=pagin.php?id=".$i.">".$i."</a>";
            }else{
                echo "<a href=pagin.php?id=".$i.">".$i."</a>";
            }
            
        }
    
    }
 
 
?>
</body>
</html>

Estos son los Estilos...

styles.css

Código CSS:

Ver original/*  Styles  */
    #paginator{
        width: 200px;
        
    }
    #paginator a{
        background: url("background_green_more.png") no-repeat;
        background-position: 0px -21px;
        color: #000;
        font-size: 11px;
        height: 20px;
        text-decoration: none;
        padding: 0.2em 0.5em;
        width: 22px;
    
    }
    #paginator a:hover{
        background-position: 0px 1.5px;
    }
 
    #paginator a span{
        font-weight: bold;
        
    }
    .Claas_may{
        padding: 0.2em 0.3em !important;
    
    }
    .idnow{
        background-position: 0px 1.5px !important;
    }