Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • raffetali Friend
    #165775

    Hello,

    I have installed quickstart “JA TELINE IV” template, everything worked fine, recently, it’s still on my local machine.
    All I need now is to change the Prev, Next buttons into “Numbers” something like: 1 – 2 – 3 – 4 – 5 – 6

    Can anyone tell me how to do that?

    Please see the attached image for illustration.

    Thanks a lot for the great help you offering to all members

    Best Regards
    Raffet Ali


    1. numbers
    pritam Friend
    #399074

    Hello raffetali ,

    To changing to Numbers Buttons instead of : Prev, Next Buttons

    You can refer to this url :- http://www.phpeasystep.com/phptu/29.html

    raffetali Friend
    #399149

    Hi pritam,

    Thanks for your reply.

    I have read the script, it’s about php pagination,
    but I wonder if it is working with “JA News Featured Module”? If yes, then can you please tell me which coding page I have to customize / replace with the script you gave ?

    Thank you for your help

    Best Regards
    Raffet Ali

    This is the code:

    <?php
    /*
    Place code to connect to your DB here.
    */
    include('config.php'); // include your code to connect to DB.

    $tbl_name=""; //your table name
    // How many adjacent pages should be shown on each side?
    $adjacents = 3;

    /*
    First get total number of rows in data table.
    If you have a WHERE clause in your query, make sure you mirror it here.
    */
    $query = "SELECT COUNT(*) as num FROM $tbl_name";
    $total_pages = mysql_fetch_array(mysql_query($query));
    $total_pages = $total_pages[num];

    /* Setup vars for query. */
    $targetpage = "filename.php"; //your file name (the name of this file)
    $limit = 2; //how many items to show per page
    $page = $_GET['page'];
    if($page)
    $start = ($page - 1) * $limit; //first item to display on this page
    else
    $start = 0; //if no page var is given, set start to 0

    /* Get data. */
    $sql = "SELECT column_name FROM $tbl_name LIMIT $start, $limit";
    $result = mysql_query($sql);

    /* Setup page vars for display. */
    if ($page == 0) $page = 1; //if no page var is given, default to 1.
    $prev = $page - 1; //previous page is page - 1
    $next = $page + 1; //next page is page + 1
    $lastpage = ceil($total_pages/$limit); //lastpage is = total pages / items per page, rounded up.
    $lpm1 = $lastpage - 1; //last page minus 1

    /*
    Now we apply our rules and draw the pagination object.
    We're actually saving the code to a variable in case we want to draw it more than once.
    */
    $pagination = "";
    if($lastpage > 1)
    {
    $pagination .= "<div class="pagination">";
    //previous button
    if ($page > 1)
    $pagination.= "<a href="$targetpage?page=$prev">« previous</a>";
    else
    $pagination.= "<span class="disabled">« previous</span>";

    //pages
    if ($lastpage < 7 + ($adjacents * 2)) //not enough pages to bother breaking it up
    {
    for ($counter = 1; $counter <= $lastpage; $counter++)
    {
    if ($counter == $page)
    $pagination.= "<span class="current">$counter</span>";
    else
    $pagination.= "<a href="$targetpage?page=$counter">$counter</a>";
    }
    }
    elseif($lastpage > 5 + ($adjacents * 2)) //enough pages to hide some
    {
    //close to beginning; only hide later pages
    if($page < 1 + ($adjacents * 2))
    {
    for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
    {
    if ($counter == $page)
    $pagination.= "<span class="current">$counter</span>";
    else
    $pagination.= "<a href="$targetpage?page=$counter">$counter</a>";
    }
    $pagination.= "...";
    $pagination.= "<a href="$targetpage?page=$lpm1">$lpm1</a>";
    $pagination.= "<a href="$targetpage?page=$lastpage">$lastpage</a>";
    }
    //in middle; hide some front and some back
    elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
    {
    $pagination.= "<a href="$targetpage?page=1">1</a>";
    $pagination.= "<a href="$targetpage?page=2">2</a>";
    $pagination.= "...";
    for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
    {
    if ($counter == $page)
    $pagination.= "<span class="current">$counter</span>";
    else
    $pagination.= "<a href="$targetpage?page=$counter">$counter</a>";
    }
    $pagination.= "...";
    $pagination.= "<a href="$targetpage?page=$lpm1">$lpm1</a>";
    $pagination.= "<a href="$targetpage?page=$lastpage">$lastpage</a>";
    }
    //close to end; only hide early pages
    else
    {
    $pagination.= "<a href="$targetpage?page=1">1</a>";
    $pagination.= "<a href="$targetpage?page=2">2</a>";
    $pagination.= "...";
    for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
    {
    if ($counter == $page)
    $pagination.= "<span class="current">$counter</span>";
    else
    $pagination.= "<a href="$targetpage?page=$counter">$counter</a>";
    }
    }
    }

    //next button
    if ($page < $counter - 1)
    $pagination.= "<a href="$targetpage?page=$next">next »</a>";
    else
    $pagination.= "<span class="disabled">next »</span>";
    $pagination.= "</div>n";
    }
    ?>

    <?php
    while($row = mysql_fetch_array($result))
    {

    // Your while loop here

    }
    ?>

    <?=$pagination?>

    Sherlock Friend
    #399253

    Hi raffetali,
    Now, ja news fp module doesn’t support numbers button, and this is heavy customize so support team can’t help more you in this issue, if you know more about javascrip and html recommend you can check source code in blog.php and script.js file in modules/mod_janews_fp/tmp/default folder.
    Hope can help you.thanks

    raffetali Friend
    #399269

    Hi,

    Is there a developer team that can make these changes to me, and I will pay the cost?

    Thank you for your help

    Best Regards
    Raffet Ali

    Sherlock Friend
    #399272

    Hi,
    Please post your project to Joomlancers.com , there are more good developers on it, they will help you.
    thanks

    raffetali Friend
    #399497

    Hi hainn84,

    Thanks for the idea to post to Joomlancers.com, I didn’t know about this site before.

    Thanks again I will post there.

    Best Regards
    Raffet Ali

Viewing 7 posts - 1 through 7 (of 7 total)

This topic contains 7 replies, has 3 voices, and was last updated by  raffetali 13 years, 4 months ago.

We moved to new unified forum. Please post all new support queries in our New Forum