PHP MySQL Paging Help!

[akvlko]

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!

[richieking]

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]

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]

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]

/*	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]

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]

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]

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]

Laziness? :icon_eek:
You have showed no effort. Show your relevant codes