-
AuthorPosts
-
June 29, 2011 at 4:43 am #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 – 6Can 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
pritam Friendpritam
- Join date:
- April 2011
- Posts:
- 609
- Downloads:
- 0
- Uploads:
- 29
- Thanks:
- 11
- Thanked:
- 125 times in 113 posts
June 29, 2011 at 9:53 am #399074Hello raffetali ,
To changing to Numbers Buttons instead of : Prev, Next Buttons
You can refer to this url :- http://www.phpeasystep.com/phptu/29.html
June 29, 2011 at 3:35 pm #399149Hi 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 AliThis 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 FriendSherlock
- Join date:
- September 2014
- Posts:
- 11453
- Downloads:
- 0
- Uploads:
- 88
- Thanks:
- 221
- Thanked:
- 2478 times in 2162 posts
June 30, 2011 at 3:17 am #399253Hi 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.thanksJune 30, 2011 at 4:02 am #399269Hi,
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 AliSherlock FriendSherlock
- Join date:
- September 2014
- Posts:
- 11453
- Downloads:
- 0
- Uploads:
- 88
- Thanks:
- 221
- Thanked:
- 2478 times in 2162 posts
June 30, 2011 at 4:29 am #399272Hi,
Please post your project to Joomlancers.com , there are more good developers on it, they will help you.
thanksJuly 1, 2011 at 9:18 am #399497Hi 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 AliAuthorPostsViewing 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
Changing to Numbers Buttons instead of : Prev, Next Buttons
Viewing 7 posts - 1 through 7 (of 7 total)