Hi Friends ! I Need a Paging Script such as Gmail for my College Project Which is a CMS based on Windows Sky Drive with Email Facility....!
Thanks in Advanced!
akvlko 0 Light Poster
richieking 44 Master Poster
Hi, Paging script to function just like gmail to be precise?
Please provide more information detailed about what you want. help is on the way.
akvlko 0 Light Poster
Hi, Paging script to function just like gmail to be precise?
Please provide more information detailed about what you want. help is on the way.
I Just need a Paging Function which is returns the Paging Result from my database as you can see in Gmail Inbox
With Checkbox and search
Hope you will understand now !
richieking 44 Master Poster
look i need to get a gmail account to see what you are talking about. i have been using my own email system since 2004. what exactly ???
do you need pagination script that got checkbox at the side for delete..?? And a search script to search your info etc...?
sorry i dont use gmail and i really dont have the time to do one. i can only write you few script and some directions. how long have you prog. on php?
richieking 44 Master Poster
/* 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";
}while($row = mysql_fetch_array($result))
{
// Your while loop here
}$pagination richieking 44 Master Poster
This is a simple pagination i wrote few years back. it should work out the box. just change few details including database stuff.
Good luck ;)
Explore ;)
akvlko 0 Light Poster
This is a simple pagination i wrote few years back. it should work out the box. just change few details including database stuff.
Good luck ;)
Explore ;)
Thank You So Much for Your Kind Support
Actually I'm Currently Working With a CMS
In the Message Section I have Some Folders Such as Inbox, Draft, Sent Box and User also can Add the Folders for their Use.
I wants Paging Script by which I can Drag the Messages from One Folder to Another.
I have tried to do so With Ajax but unable to Drag the Messages
I hav eseen this feature in Gmail so thats why I use the Word Gmail.
and I'm working with PHP Since 3 Years
i have made a lot of Web Based Application but I believe in Adding new Features into my Projects so that is Why...
Anyways If you are using your own Email System its Very Good but You are using the Same Application Since 2004 this can not be good if you are a good developer.
I hope you will understand what I really mean so..
Thanking You again.....!
Take Care ....
richieking 44 Master Poster
Hi akvlko, there are some logic that does not change. A pagination in 50 years is the same today. The logic remains the same. The beauty is css.
Also, php does not have api for drag and drop. Ajax will.
You can post your ajax script and i will look into it and see if i can assist you on that.
Thats if you want ;)
Explore ;)
Stefano Mtangoo 455 Senior Poster
Laziness? :icon_eek:
You have showed no effort. Show your relevant codes
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.