PHP News Project - Pagination Tutorial in Hindi / Urdu

In this tutorial you will learn php mysql news project pagination tutorial in Hindi, Urdu.You can learn how to add pagination to your webpage and divide multiple database records into multiple pages in PHP with MySQL in hindi.
PHP Tutorial in Hindi Playlist
• ✅ PHP Tutorial in Hind...
Official Website
www.yahoobaba.net/
News Project with PHP Source Code :
www.yahoobaba.n...
News Blog Project HTML Template Page Link
www.yahoobaba.n...
Follow us on Facebook
/ yahooobaba
Follow us on Twitter
/ yahooobaba
#php #webdevelopment #phpmysql

[@devsgramone5854]

I think It's the most difficult lesson(for my side) till now.
By the way, Love and respect from Bangladesh, sir.

[@rajjasoliya9147]

thank you sir we are not satisfied with our college's teaching but you fill that emptiness of teaching thank you sir

[@YahooBaba]

It's my pleasure

[@sunnyshrivastav1226]

sir mai apse ek vinti krta hu plz sir aap C# tutorial lekar aayiye sir plz maine apka php course ko shi se pdha h aur mai ab ache se backend pr kaam krta hu as a developer mujhe apka way bahut acha lga plz sir aap C# . Net ka course lekar aao plz sir i want to learn C# only from you sir You are great....

[@abhimanyuarora6377]

@yahoobaba thankyou sir Amazingly explained I wish I would have know about your channel and videos few years to aaj kahi or hi hota

[@praveensuthar6444]

Yahoo baba>>>>>code with harry

[@mobinaparween7725]

Shubhan-allah 👍 kya gjb padhte ho sir. Really you are genius.

[@YahooBaba]

Thanks for appreciating my work :)

[@mobinaparween7725]

Most welcome sir. Waise ap ho kaha se. Apka khud Ka institute hai kya sir?

[@YahooBaba]

Main Haryana (INDIA) se hun. Mera koi institute nahi hai, basically mein ek freelance fullstack developer hun.

[@mobinaparween7725]

Wow sir. You are very talented. I like your voice and teaching style sir. Thank you so much for amazing tutorial 👍

[@shtakshichouhan3879]

Easy and very Helpful, Thank You so much 😊

[@bhagirathiverma2627]

Wow....
Awesome tutorial...
Thanks a lot sir
😇😇😇😇

[@spytuber7765]

I love your teaching style may allah bless you sir. 🥰🥰
your are a great teacher

[@YahooBaba]

Thanks for appreciating my work :)

[@talhashehzore]

Sir apki php ke playlist bhot helpful hai Mere liye 2023 main Sir ap sy ek request hai pagination ky baad Sir categories ko add karna usy fetch karna update and delete karna Sir uska source code provide karwa dy news blog project sy related yaa koi tutorial record karwa dy please ❤❤❤

[@shaniparacha9242]

You are great sir, i respect of my teacher. Love from Pakistan.... Best channel for learning php and mysql

[@YahooBaba]

Thanks Shani for appreciating my work :)

[@shaniparacha9242]

Sir i sign up on your website but i did not receive any confirmation email yet.

[@YahooBaba]

Please check your spam box in in your email website. If still you can't find the email then tell me your email ID

[@YahooBaba]

Aapki email id kaunsi hai : [e-mail] or [e-mail]

[@shaniparacha9242]

@@YahooBaba sir mari id [e-mail] hai or second one mere bhai ki hai Ahsan paracha ki.. Mene s sa b accouny bnaya but confirmation email ni ai

[@Ahmadabbasi20]

a lot of respect from my side... always satisfied from your lecture.. i just want one more thing from your side that if you you provide a task at every lecture for us so that we can polish our skill that we learn from you will be a nice favour......thanks a lot....respect from pakistan

[@YahooBaba]

Sure I will give a task in future videos.

[@mohsinrana7293]

sir ek number dil khush kar diya

[@YahooBaba]

👍

[@dev504]

one of the best explanation I have seen for pagination thanks sir, also please start tutorials on Laravel as your teaching is so good.

[@niteshchaurasiya1531]

Sir Very Nice Superb se bhi Upar .

[@YahooBaba]

Thanks :)

[@hafizirfanspeaks]

Fantastic SIR
but it is difficult for memorizing some steps..

[@ashishsingh7056]

sir you're great

[@YahooBaba]

Thanks :)

[@mr.editor7445]

Thank You very much sir

[@waqasdehar]

you are outstanding i like videos

[@YahooBaba]

Thanks :)

[@JamateSirajiaFaisalabad]

Very good, Thanks

[@MuhammadAyaz_786]

great sir

[@Aaodeenkytaraf]

great video thankq so much

[@YahooBaba]

You are welcome!

[@Ahmadabbasi20]

Sir ap ny hmy simple login or logout ka to bataya h is project main .. ab plz ap sign up, sign in, register , dashboard, ky bhi pages bnana sikhy isi project main hi

[@shirishachhetri3315]

Thank you so much. It was so helpful.

[@YahooBaba]

Glad it was helpful!

[@abdullahjaved1321]

Great JOB

[@YahooBaba]

Thanks :)

[@ashishsingh7056]

sir please a project on html,css,javascript,and php together

[@VishalSingh-ph5us]

yes sir please that would be helpful

[@varunjain3756]

Very helpful tutorial Sir

[@YahooBaba]

Many many thanks

[@varunjain3756]

@@YahooBaba Sir, If Possible, Put APPLAUD button on your videos so that we can appreciate your immense efforts.

[@dhruvrajsinhjadeja-vfxarti3085]

You are awesome teacher sir :)

[@YahooBaba]

Glad you think so!

[@uditmathur9159]

thankyou sir . great job

[@YahooBaba]

Most welcome

[@MdSumon-fq8ro]

Great tutorial

[@satyamannu29]

Too good explanation.

[@YahooBaba]

Glad you liked it

[@ShakeelAhmad-sc9gv]

Thank you sir for this video.. I need this video

[@YahooBaba]

Most welcome

[@ShakeelAhmad-sc9gv]

I have learnt too much from your channel..

[@vinaykamble1736]

Very well explained

[@YahooBaba]

Thanks for liking

[@thecoderraj3777]

Thanks a lot sir 😊🙏🙏🙏

[@YahooBaba]

Most welcome

[@HarishProjects]

amazing

[@YahooBaba]

Glad you think so!

[@mdarifulislam1044]

Awesome video...

[@YahooBaba]

Glad you liked it!

[@bhagirathiverma2627]

This is awesome Sir but what if pages are 100 or 100 + ....

[@YahooBaba]

Then we use advance pagination but I didn't make any video on advance pagination.

[@bhagirathiverma2627]

@@YahooBaba Please sir aap banaiye...
Koi bhi apke jitna acche s nhi sikhata.....
Plzzzz plzzzz.....😇

[@muhammadgul7956]

Thanks Sir

[@YahooBaba]

Welcome

[@mr.editor7445]

Love You ho gya sir g

[@muhammadbilalhussain4279]

SIR THANK U GOOD WORK

[@YahooBaba]

Thanks Hussain :)

[@coderunner5273]

There is no need to write if else for page=1.you can give it in users(href="xyz.php?page=1").

[@IrfanAhmad-fj3eg]

if there is three condition for searching and upon these search below pagination is created then upon clicking how to determine the cursor to goes which condition

[@almamunkhan6107]

thank you, sir.

[@YahooBaba]

Most welcome!

[@gurejalectures]

Agar 1000's of record han to kya itny sary anchor tag ayen gy? Us ka b code hona chahiyea k maximum 10 anchor tag hon baqi thory sy ...... Dots lagy hon.

[@YahooBaba]

Dear yeh ek basic project hai jismein maine yeh bataya hai ki PHP mein kaam kaise hota hai. Jis pagination ki aap baat kar rahe ho wo advance level hai aur hum waise he kaam karte hai. Advance Pagination par bhi mera video jald he aayega.

[@gurejalectures]

@@YahooBaba thanks sir

[@rajatsonu01]

thanks

[@davidbdn1994]

if i'm inside in one category of products how can i make a pagination of all products of the choosen category??

[@mayankjaiswal380]

sir also tell me should i make data base from phpmyadmin for current login or it will come automatically

[@YahooBaba]

I have place the database in download folder...please attach the same database with project.

[@mayankjaiswal380]

sir where i can chat with u

[@mayankjaiswal380]

Ok sir i will replace data base filder from ur Given code
but what ABOUT category file

[@umeshbamrara9790]

hello sir could you please me how you used this ternary operator(?) here, Bec In your previous lecture of ternary operator you said that we can use it same as if statement could you make a a separate video about all the usage of this operator(?)

[@wasyul6333]

Good

[@mayankjaiswal380]

sir i m stuck at one point and i want to Continue this playlist till end i like it very much
kindly help me i had downloaded ur Sourcecode from ur site
I did Everything which u told at 112th tutorial of php
but when u said copy the files for category module and post module at last of pagination video
I am not getting exactly which file i have to copy from ur SourceCode
Kindly Tell me the FILE with Its path to copy on my current work
or required modification

[@YahooBaba]

Copy all the files and paste in ur working folder.

[@mayankjaiswal380]

@@YahooBaba sir if i replace news-site whole folder then I wont get ( blanked basic) page so that i can code along with u

[@muhammadullahafridi5854]

this is great but if there are more records like 1000 records the number of pages will increases and it covered hole screen which is happen with me

[@YahooBaba]

Soon I make a advance Pagination tutorial.

[@anshumaantiwari3273]

No. of post ka naya input type banaye kya.

[@JustForProgrammers]

Best

[@aliirtaza6936]

bhai aikn jese jese DB main rows barhain gi tou pages bhi barhain gy or utny hi pages pegination main show hongy. phir tou woh count krta krta kfi barh jaye ga. isko kese limit krain gy? means (prev 1 2 ......... 100 101 last)

[@YahooBaba]

Jonse baat aap kar rahe ho wo Advance Pagination hai jo main aage aane wale tutorials mein bataunga.

[@aliirtaza6936]

@@YahooBaba OK. Thank You ❤

[@mr360aj]

Add category, wale page ka code btao sir. Uska different code h

[@gurejalectures]

To sir first or last ka button kesy banain gy. Agar records thousands main aty han to....

[@YahooBaba]

For first record :
if($page > 1){
echo 'First';
echo 'Prev';
}
for last record :
if($total_page > $page){
echo 'Next';
echo 'Last';
}
Records thousands ho ya millions yahi pagination ka code chalega.Aap page limit ko bada sakte hai jaise meine $limit =3 liye hai aap uski jagha 10 or 20 le sakte hai.

[@gurejalectures]

@@YahooBaba thank you very much sir g

[@diptobiswas6511]

It would be helpful to know what to do when my page count is too large.

[@YahooBaba]

Then we use advance pagination technique like (1 2 3 ... 11 12 13 ... 21 22 23)

[@sumitasharma8849]

@@YahooBaba Pls show us how to do this. Thank you!

[@zulfequarmohammed2300]

Thank you bro good explanation. I so much learning from your tutorials.
I have small doubt, how to rectify form re submission problem....? Please if possible kindly make one video.
I will wait for your valuable response.

[@YahooBaba]

What type of Re submission ?

[@zulfequarmohammed2300]

@@YahooBaba Thanks for valuable reply.
after submit form details, when we are refresh the form then re asking browser form submission. If we click button then twice time entered details in db.
How solve this problem pls reply.

[@YahooBaba]

Read this page to rectify that problem : stackoverflow.com/questions/6833914/how-to-prevent-the-confirm-form-resubmission-dialog

[@chaitanyadusane2272]

Please do these code with using Ajax

[@YahooBaba]

Right now i am just teaching the basics of PHP and MySQL. After that i will teach you about Ajax with some kind of Project.

[@tamimikbal9890]

Which code editor you use brother 😍

[@YahooBaba]

I use ATOM or Sublime for PHP development.

[@harishnegi316]

Sir php se menu and sub-menu dynamic ke liye video banayiye please

[@YahooBaba]

Yes sure

[@bhagyalaxmiyadav3590]

sir if i want tod o pagination using rest api in web page how to do please sir help me

[@shakeelahmad-ei8vy]

Respected sir plz pagination dataTable jquery plugin k through bnana sikhaye plzzz sir

[@YahooBaba]

Ye topic maine already note kiya hua hai ...ispar video bhi jald he banaunga

[@shakeelahmad-ei8vy]

@@YahooBaba thanx respected sir

[@noorulhuddamemonrecipes993]

What if we want to add jump to this page input field in the page...

[@getsetalk]

Sir now make material css tutorial

[@getsetalk]

Responsive table banana sikhaiye

[@raheelahmad3597]

Sir please tell me solution that if we want to create pagination with only two buttons prev. and next

[@techavy4084]

alag alag pege bna do bhai...

[@techavy4084]

aur link kra do....

[@sdk_gyan]

Last add data ko first page pe show karna hai...

[@YahooBaba]

Set ORDER BY id in DESC mode....in SQL Command

[@rojan11]

What is our tutor's name? How we can follow him?

[@YahooBaba]

My name is Sanchit Soni

[@mrmack6379]

When you start codeigniter tutorial

[@YahooBaba]

After I complete PHP Course

[@advologysolution8955]

when you start codeigniter

[@YahooBaba]

After PHP Course

[@mahibisht2583]

Pls provied CI using Ajax video
I am Waitng last 3 months

[@shaheersialvifans5762]

Php sy koi website develop krna sekha dain sir

[@YahooBaba]

Is project mein wahi sekha rha hun ki kaise aap ek complete PHP based dynamic website bana sakte hai.

[@ankitmakwana3141]

❤❤❤❤❤

[@hasimahmed3947]

Sir i have an error about the pagination- Undefined array key "page" in C:\xampp\htdocs\haqcomsoft\admin\users.php on line 15
please help why this error occur

[@spotlightevents3366]

Sir i have little confusion here when i make the dynamic pages than the header and footer is not showing and also the next button is not showing please help me :)

[@YahooBaba]

Please download this complete project from our website and then compare it with your code. yahoobaba.net

[@IrfanAhmad-fj3eg]

i have three condition like if(isset($_POST['search']) & !empty($_POST['searchdata']) ) and if(isset($_POST['search']) & !empty($_POST['seardate']) ) and else . these are searching input text field name searchdata and searchdate and esle if empty.
when first condition is true pagination is aslo create according to is t condition similarly on both two condition pagination is created.but confusion when i click on pagination cursor goes to else condition and again all page is shown in pagination.what i can doing wrong... i want if pagination is created in first condition and i click on pagination the cursor should be goes to first condition and the pagination is created upon second condition and i click it should go to second part not to else.

[@hardikdabhi4788]

jese ki hamare pass 5000 records h phir next par click kare to pages h wo to bahut sare dikhai dege to hamare pass kitna bhi data h par niche k pages h wo sirf 10 page hi dikhane chiye to kese karege,???????????

[@YahooBaba]

Is par main jaldi he video bana dunga

[@anuchauhan1100]

Sir ager row me color dalna ho uski vidio

[@u_zerry]

How to practice these series.
I forgot after watching and doing this on my computer.
How can i remember this?

[@YahooBaba]

Practice practice practice is the only way to become an expert

[@md.mohajirrahman681]

"Thanks You Sir".(♥ _♥)__❤️❤️❤️

[@YahooBaba]

Your welcome Mohajir :)

[@shaheersialvifans5762]

1 complete project banye plz

[@pritpalsingh4211]

When we click on any page number if the whole page refresh and if yes then how the value of $i variable in for loop remain same because we are comparing $i and $page variable to active the clicked page. I am confused now and I have stuck on this code kindly help me.

[@pritpalsingh4211]

Kindly help if anybody knows the answer.

[@mahibisht2583]

hi Sir pls provied Codegniter video using Ajax

[@muhammadhamza1073]

apki site py banda sighn up hi nai ho sakta ap ka site bnany ka faida

[@YahooBaba]

Hamza humari websites pe toh daily 15+ new signup hote hai.

[@muhammadhamza1073]

@@YahooBaba sir g cofrmation email nai arhi

[@mayankjaiswal380]

i did all the things same to same till pagination video

[@Human_477]

Error
Undefined index: page in
Ma na error thk kia but no value showing now 😢?

[@Everything4ever]

Search kar kay value dhak na hay. Search queries kay say laga na hay

[@fitbouncer6795]

Notice: Undefined index: page in E:\xampp\htdocs
ews\admin\users.php on line 15
query failed. ---aysa dikha raha sir, can't understand what's wrong in " $page = $_GET['page'];"

[@fitbouncer6795]

sir, say any solution of this problem

[@uzaifkarime4080]

Sir ek error aa raha hai.. "A non formed numeric value encountered in.... " Yeh q araha hai kya ap batahin gy please?

[@YahooBaba]

Read this article : stackoverflow.com/questions/6136430/a-non-well-formed-numeric-value-encountered
Shayad yeh aapki kuch help karde.

[@uzaifkarime4080]

@@YahooBaba .. Thanks sir

[@rightorwrong7666]

'.$i.' in this it is showing that undefined index

[@anirudhvats6038]

Sir bootstral please..
3 month se wait kar rha hun...

[@YahooBaba]

Anirudh aap itna wait kyu kar rahe hai. Bootstrap ke tutorials toh already youtube par bhare pade hai. Mere ko start karna hai lekin time nahi mil pa raha hai.

[@sumansanabada9684]

Hii bro can you post Advance Pagination in using PHP.

[@YahooBaba]

Will upload soon

[@sirajuddaulaarafat8311]

Why my errors are not displaying like yours? Directly showing 'Page not working'. Not talking about 'query failed'.

[@YahooBaba]

Can't say any thing without seeing your code. Please download this complete project from our website and then compare it with your code.

[@sirajuddaulaarafat8311]

@@YahooBaba Problem solved. Thank you

[@mrzakeey1108]

$offset =($page -1)*$limit ...sir ispe samja nhi ..zara batay sir

[@hamzatalha8013]

dude i had the same problem but i miss to delete " from my a link
echo'Prev';
echo'next';
type this ^^

[@sajjadhussain-js4fi]

codes mil sakty h ye??

[@YahooBaba]

Yes download it from our website

[@anshumaantiwari3273]

ye jo categoery hi isme no of post hi iska kya kare

[@myblogrecord6638]

Sir mjhe ek error a rha h category.php m uskko m kese solve kru can help me to find this error on my desktop with the help of anydesk pleas sir

[@YahooBaba]

Error kya aa raha hai ?

[@myblogrecord6638]

Sir querry failed btara to wo m smjh ni pa rha kese thk kru use

[@nomanali9836]

Notice: Undefined index: page in F:
aman\htdocs
ews\admin\users.php on line 15
select*from user order by user_id desc limit -3,3 what to do?

[@YahooBaba]

Is that error in our project that you downloaded from our website ?

[@sirajuddaulaarafat8311]

Yes, why here $offset value displaying -3? That's why showing query failed. Same problem here.

[@sirajuddaulaarafat8311]

Okay. it's fixed. But i Don't know how, i didn’t change any code. After refreshing some time It's working.

[@dlsstudio]

Select alll post shows

[@pintukumar-rb2yv]

How to create pagination page input field method

[@YahooBaba]

I don't get your point what u want to ask ?

[@pintukumar-rb2yv]

@@YahooBaba input de kar pagination page kese create kar te hai

[@YahooBaba]

Hahah wahi baat hindi mein likh de...... Input de kar pagination kaunsi hoti hai ? Aapne kha dekhi hai ?

[@Space_Wonder_Bzr]

what about dynamics records?

[@YahooBaba]

Means ?