PHP Ajax Load More Pagination Tutorial in Hindi / Urdu

[@nontechbg]

Its revision time watching all videos again and again 😀

[@nontechbg]

I am watching all videos again and again thankyou👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍

[@YahooBaba]

Most welcome 😊

[@shubharani7529]

such a very helpfull contents

[@mihirpatel6758]

@yahoo Baba: Sir, currently are you working on any other playlist ? can you suggest me best playlist to learn React Js or Angular Js like yours php playlist ,how you teach and cover every useful thing.

[@mohammadrasel7612]

thank you so much bhai

[@prarthanasharma6954]

big thumbs up thank u sir

[@shaikhahmad1019]

sir, will you create ajax video using vanilla javascript or not? and thanks for these awesome videos❤️❤️

[@umerfarooq3121]

If you're facing problem while loading new record after clicking on "Load More Button" just add these lines $serialNo = $page + 1; // Add this line before if statement $last_id = $serialNo; // Add this line inside the while loop as shown in the video $serialNo++; // Also add this line in while loop at the end It'll be solved ;)) Thank you.

[@supratimpathak1110]

this does not solve the problem //code for auto rearrange the column id values // Set @autoid :=0; update emp set id=@autoid := (@autoid+1); ALTER TABLE emp AUTO_INCREMENT=1;

[@akashmathpal4486]

Thanks Umar it was really helpful..

[@ShubhamSingh-dz2wy]

it's work thankyou sir

[@mahadumair1162]

Thanks that work still after 2 year

[@chetanshrivastava3762]

Very nice explanation

[@YahooBaba]

Thanks and welcome

[@muhammadbilalhussain4279]

Love u sir

[@SonuKumar-jy8iv]

Jabardast👍👍👍

[@YahooBaba]

Thanks :)

[@SonuKumar-jy8iv]

@@YahooBaba thanks for reply

[@sidaldar5552]

Awesome bro

[@bikram5563]

Please a make a playlist about how to create templates for blogger

[@anand__346]

sir in this tutorial if the id of student is not in the series then it'll not works properly like if sequence of id is 12,26,30,32,34....... in the place of 1,2,3,4,5 then it'll not works properly ???

[@anjeshravi8]

Sir ajax with json ka bhi video aayega??🤔🤔🤔

[@YahooBaba]

Yes after 2 more videos i will start Json videos.

[@rajnishbhai]

@@YahooBaba 😍

[@shakhawathossainshihab7998]

Sir, I have deleted some records from table. (the ids are now 2, 3, 6 ,8, 9, 10,11,13,15,16 ... ... ) As a result the "load more" operation is not showing few records .. what can I do now???

[@SameerShah-s3o]

please try again and see again this code i think some wrong enter the code. sorry.

[@hackerwhite7957]

bhai maja aagaya

[@YahooBaba]

Great :)

[@imjhassan2822]

A. O. A bro ❤️. Bro database min id auto increment hoti or jb record delete krte hein to id ki numbering sequence min ni ati to please id numbering sequence min lane ka method bta dein please? Hope so apko Question smj aa gia ho ga. Advance thanks ❤️ ❤️ from 🇵🇰 🇵🇰..

[@YahooBaba]

Uske liye SQL ki ALTER command use hoti hai. Sequence Number ko kaise theekh karna hai ispar maine already video banayi hue hai MySQL course mein aap ja kar ALTER command wali video check kijiye.

[@CodeWithRai]

Alter ki command na bhi use kro to $offset = ($page) * $limit; yeh formaula use kro jahan $page use kr rahay wahan ab offset lgao yeh formula else kay baad main calculate kr lo.

[@imjhassan2822]

@@CodeWithRai thanks bro

[@shahniyalrajpoot6014]

@@CodeWithRai us sy simple yeh hai k $last_id=mysqli_num_rows($results); asy krlo .. jitni b row hongi wo last id k variable ma ajay gi jb b ap load more py click kro gy..

[@kajalodedra8228]

sir ,sublime me extension konsa use kr rahe hai app?

[@dhawalparmar7117]

Sir what if our id(primary key) is not in sequence. Then what would be our page_no to be set.?

[@kaustavmukherjee4050]

Sir This is very nice video. I really love and appreciate your work. But I have a problem in load more pagination with delete button. When I delete a element from a table then load more table not work properly. Sir please kindly give me a suggestion. Thank you sir ❤️❤️❤️ // Delete records $(document).on("click",'.btn.btn-danger',function() { if(confirm("Do you really want to delete this record?")) { var studentId = $(this).data('sid'); var element = this; $.ajax({ url:"ajax-delete.php", type:"POST", data:{id:studentId}, success:function(data) { if(data == 1) { $(element).closest("tr").fadeOut(); } } }); } });

[@nitinnamdev5627]

Thanks u sir

[@YahooBaba]

Welcome

[@m.1shfaq]

I cannot use order by id desc in query with pagination. Is there any way to use it

[@zainabbas8014]

Sir php se File kese Download kre

[@abhimanyuarora6377]

@yahoobaba Hello sir your tutorial are amazing I want to lear more about laravel and magento please make videos on it

[@YahooBaba]

Laravel course is coming soon.

[@abhimanyuarora6377]

Badly waiting for that

[@Neerajkumar-sj5lp]

Id sequence change will create pbm, if id becomes like 7, 8 10, 12, 15 etc

[@YahooBaba]

In real project we don't show database tables's Id. We use our own variable and we increment it, as I showed in "News Blog" project in PHP course.

[@fixbug3327]

Sir i have tried for scroll pagination. But i faild. Can u kindly make a video on pagination like fb. KZbin has

[@humanbeing9106]

sir awsome sir onscroll me ajax request bhi banado jo

[@YahooBaba]

yes sure :)

[@adeelanjum8880]

Sir please try to provide simple frontend files without php code along with php code files.

[@YahooBaba]

You can download this complete project from our website.

[@muhammadbilalhussain4279]

Sir larvel kab start hoga

[@YahooBaba]

After completing PHP course and Codeigniter.

[@robitops1547]

cool

[@hindustan1858]

Sir function loadtable (page) me page me value kha se aari..ye btao sir plz

[@YahooBaba]

Iss wale function se : $(document).on("click","#ajaxbtn",function(){ $("#ajaxbtn").html("Loading..."); var pid = $(this).data("id"); loadTable(pid); }); Please video ko dhyan se dekhiye.

[@sagar3861]

or jisko bhi error ara h bhai loog apni table sahi karo sir ka code sahi ha ekdum table ke auto increment ke wagah sa issue ha

[@gaurav27496]

agar bich me se koi data delete karde to ye kaam nahi karega. kyu ki tab id series me nahi rahegi. iska koi solution?

[@YahooBaba]

Use one extra variable for calculation in Pagination.

[@sebich-7131]

bro mera delete id wla problem hal ni howa bai jb data insert ho jata ha tb delete btn pe click kru to id show hoti ha jse m page refresh kru tb delete btn pe kuch ni show hota wo bta de kyu hota ha

[@YahooBaba]

Kya aap Ajax se delete kar rahe ho ?

[@sebich-7131]

first m alert krwa rha hu

[@sebich-7131]

abi ajax se b kia but ni howa ajax code: $(document).on('click', '.delete-btn', function(event) { var studentId = $(this).data("id"); var del = this; $.ajax({ url : "ajax-delete.php", type : "POST", data : {studentId: id}, success : function(data){ if (data == 1) { $(del).closest("tr").fadeOut(); } else{ $("#error").html("Can't Delete Record!").slideDown(); $("#success").slideUp(); } } }) });

[@sebich-7131]

Delete ese id le ha jse ap ne le thi

[@YahooBaba]

Dear aap iska complete code humari website se download karlejiye aur compare karke dekhiye.

[@riazahmadshigri8814]

it shows every col-md-3 data in seperate row in bootstrape 4 but wroks as desired in bootstrape 3 please make it to work with bootstrape 4

[@newideasytsupport2493]

Sir, but it is not working on server , php file send another file with response like header, footer php file

[@YahooBaba]

Can you send me the URL where it is not working ?

[@mmk_youtuber]

sir agar mein start mein 59 records delete karloon then my database id will start from 60 it means my page number or last id will be 60 so it will offset 60 records but if i have 20 in database then only 5 records will show by page loading and after by button click it will not show a record what is the solution for that

[@YahooBaba]

Use Alter command for that ...see this video : kzbin.info/www/bejne/qZm9ioV_idCMhs0 ALTER TABLE-Name AUTO_INCREMENT START-NUMBER; ALTER students AUTO_INCREMENT 5;

[@mmk_youtuber]

@@YahooBaba Thank you sir ur videos are awesome

[@mdmayinuddin138]

If id serial break (such as id number 1,3 5,6,7,8) then this system will not work.

[@YahooBaba]

FOr that you have to take another variable for calculation.. soon in 2 days i will update this video code and you can download it from our website.

[@dhvanilpatel6285]

@@YahooBaba sir send code link

[@ashokmehta790]

same prblm here

[@ashokmehta790]

@@YahooBaba sir did you make video

[@saikatnaskar5047]

sir load more button click karneme vi next data nehi arahahe

[@YahooBaba]

Browser Console mein check karo kay koi error show ho rha hai ?

[@saikatnaskar5047]

@@YahooBaba console me first 5 data show honeke bad finished ho ja rahahe baki data nehi arahahe

[@pankajpawar2858]

Not Working, Becoz this is based on id column in database and offset is working based on table data index. id in my id column starting from 81 to 103. and this example not working. becoz for when i pass 81 in $page (offset) then it not load any records. becoz it not found any index 81 in table. cause there is only twenty records, index 1-20 is available. when i pass 1 to 20 any digit in $page. it loads records. for ex when i pass 3 it loads records from 84 to page limit. So what is the solution for this.

[@pankajpawar2858]

i made it , i passed pageno += 5; when load more button click from jquery. And in php side pass this pageno in offset. Please correct this mistake in your tutorial.... there is no need to pass userid on button in data attribute with button click. anyway, Your tutorials are Good.

[@anishmanhas2498]

sir id break ho rahi tab ye work ni kar raha

[@nontechbg]

Today is 22 6 2022

[@anjeshravi8]

👌👌👌👌👌👌👌👌👌👌👍👍👌👌

[@aishwaryabhosale2914]

I m trying to login but i cant

[@YahooBaba]

What is the exact problem and what is your email id which u uses at a time of login ?

[@humanbeing9106]

sir you are misguiding the student

[@YahooBaba]

Haha Dear you are getting error in your program and you are saying I am misguiding the students.... Hahahaha.

[@humanbeing9106]

@@YahooBaba sir aap has kyu rahe ho we r your student

[@YahooBaba]

@@humanbeing9106 If you feels that you are my student then why are u using negative words like "misguiding". Dear main toh aapko free mein hee lecture de rha hun aur aapke problems ko sort out bhi kar rha hun toh jo kuch aapko bhi puchna hai wo ek Ache tareeke se puchiye.

[@humanbeing9106]

@@YahooBaba sorry sir my intention was not to hurt u but u know sir apne register pe aaka naam lika hai guru shri yahoo baba mahadev ki kasam but agar app hee hame iss error se bahar nhe nikaalo ge toh future me hum faceboook or amazon ko kaise compete kr paaenge ....

[@hemantpandey6077]

@@humanbeing9106 bro Facebook or Amazon ke bare me sochane se pahle izat dena or lena sikh lo achha rahe ga

[@humanbeing9106]

there is a bug in your prev or in this programm kindly change it or stop making tutorial

[@humanbeing9106]

sir i ll tellu you have pass the record id on button click what id admin modify or delete records then it is giving us an error ...

[@YahooBaba]

Don't use "us" word because you are the only guy who is getting an error. Secondly, download the code of this video from our website and compare it with your code.

[@shaikhahmad1019]

bhai id static nhi hai agar admin koi record delete karta hai to next time jab data fetch hoga database to remaining records aayenge aur uske id set hogi..

[@sanchitsoni]

@@shaikhahmad1019 Ok not a problem just take extra variable and increment it by 1 in the loop and in last place its value in button.

[@jashankamboj9731]

[@jashankamboj9731]