Pagination Tutorial for PHP MySQL Programmers - Web Intersect Paging Database Results
Loading...
Uploader Comments (flashbuilding)
Top Comments
-
you should defenetly go into teaching. I honestly learn more out of your tutorials than i do in my college class, I NEVER understood how to paginate, and with ur video, i totaly get it now, my pagination is a bit different than urs, but same idea, thx ur videos are always a big help ^.^
WRITE A BOOK!!!
1 year ago 20
All Comments (56)
-
how to add pagination in blogger?
-
i keep getting this error message, also i am using MAMP, thanks.
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /Applications/MAMP/htdocs/test
/scripts/homePage_randomMember s.php on line 33 -
amazing teacher
-
great vid adam. Thanks
-
you rock man!
-
Thanks to you sir...you made me understand pagination thru your video tuts.
More power.
I subscribed.
:D
-
ba-da ping ,, . :)
-
$sql1=mysql_query("Select pid, title, author, price, picture1 from tblproducts where scid='$scid' and penabled='1' ORDER BY pid ASC");
when i put the $scid it can only be function in first paging when i reach second page the page is blank but when i use the scid in '1' can be function and take all from database which the scid is 1 but can use in variable passing
- 45 videosHow to build a social network, community, php mysql web site
- 22:26
How to Build a Community Website Part 1 - Social Network Production Tutorialsby flashbuilding199,650 views
- 10:47
Dreamweaver CS4 Pagination Tutorial Paging Database Resultsby flashbuilding23,222 views
- 16:39
Web Intersect v1.3 - HTML Header, Fixed Bugs, and GNU GPL Welcoming Programmersby flashbuilding6,913 views
- 9:54
Dynamic Google Maps Location Tutorial For PHP + MySQL Driven Websitesby flashbuilding15,468 views
- 15:19
Part 1: How to Build PHP and MySQL CMS Website Softwareby flashbuilding76,819 views
- 12:39
jQuery Grids - really simpleby optikalefxx9,927 views
- 10:00
Learning PHP Programming Lesson 1: Introduction - Part 1by umicom88,417 views
- 7:45
PHP: Create, Edit, Delete & View (Part 3)by abell121,874 views
- 14:40
2. How to Create A Basic Membership Website System Using PHP and MySQL Tutorialby flashbuilding24,392 views
- 2:58
Visual Perception, 3D GUI Pitchby vangpk118,640 views
- 28:50
4. E - Commerce Website Tutorial - PHP MySQL Inventory Managementby flashbuilding29,218 views
- 6:48
PHP Lesson 1: How to get data from MySQL Databaseby iCreativeTech14,708 views
- 30:20
Part 3: How to Build PHP and MySQL CMS Website Softwareby flashbuilding31,253 views
- 26:34
Part 2: How to Build Custom PHP and MySQL CMS Website Softwareby flashbuilding47,769 views
- 23:03
[EN][PHP] Pagination tutorialby Laimonas1711,261 views
- 6:40
MySQL Tutorial 1 - Connecting to a Databaseby thornwebdesign46,294 views
- 8:37
PHP Lesson 10: MySQL User Login - Part 1by gorilla3d109,671 views
- 4:23
Flash PHP MySQL Communication Tutorials Intro ActionScript 3by flashbuilding34,723 views
- 7:59
[ PHP ] Pagination - Part 1by EpicSoftworks1,395 views
- 15:01
PHP MySQL Tutorial: Create a Simple View Counter -HD-by RiverCityGraphix23,978 views
Wouldn't it be more efficient to use "COUNT(*)" in SQL query to get numer of rows instead of running the whole big query and using mysql_num_rows($sql) function?
yco79 6 months ago
@yco79 - Yes it is. And even more efficient than that is to use a session variable to only have to query that total amount number... one time and not on every page request. I do a lot of things really basic and beginner friendly in tutorials. They can go further and learn to be more efficient once they grasp the logic. Go for a session variable based pagination for top efficiency. How about I update this tutorial... I will show the session based example to show the most efficient.
flashbuilding 6 months ago 9