Jump to content


Check out our Community Blogs



Recent Status Updates

View All Updates

Developed by TechBiz Xccelerator
Photo
- - - - -

i want pagination for my search page results.

php mysql

This topic has been archived. This means that you cannot reply to this topic.
2 replies to this topic

#1 vinodvalluri

vinodvalluri

    CC Lurker

  • Just Joined
  • Pip
  • 1 posts

Posted 22 June 2016 - 12:27 AM

i am trying pagination for my search page results .

but i am getting errors because of more sql queries in scripts.

if there is one query i can get the results.

plz help in this regard.

i am attaching my codes below.

i have removed the pagination code from the code for below attachments and made it simple.

Attached Files



#2 sql-developer

sql-developer

    CC Lurker

  • New Member
  • Pip
  • 5 posts

Posted 04 July 2016 - 04:52 AM

SQL Server has some functions for developers for pagination requriments. Using SQL Row_Number() function is one of them. A most recent solution is using the SQL Order By clause with Offset and Fetch Next

Of course I can only suggest these for SQL Server since these are T-SQL enhancements. Like PL/SQL, since it had Row Number functionality for long, I hope MySQL has a similar function as well



#3 Risha

Risha

    CC Lurker

  • New Member
  • Pip
  • 3 posts

Posted 14 July 2016 - 02:50 AM

 I have been trying to make the search results page include pagination because I onlywant to display 10 results per pag