Baqi teek ha lkn agr hmare pass long list ha like 15 pages ha our ham chahte ha ka sare show na ho jo selected page ha os se ek next our ek previus page pagination ma show ho to wo kase kar sakte ha?
@@WebMentorDev concept to yahi ha lkn agr hmare pass 100 pages ha ab 100 pages ko to show nia karaskte page par show to sirf 5 ya 6 buttons ko karen ga os logic ki samaj nai arahi
us k liay select tag ki dropdown list create kr skty hein. ya 1, 2,3,4 ... 100. is trha say pacges ho first, 4th pay click karon to agay 5 a jain or first 1 sat3 hide ho jain. agar dobara 4 pay click karin pahly wali postion pay a jain. asay kr skty hein. laravel mein by default hota hei asa. Easiest tarika dropdown wala hei ya number wala. Select with datalist
Write a code for getting single value with Where clause and use pagination for it Like select *from employee where CONCAT(city,district,state) like %location% limit $offset,$limit;
@@WebMentorDev when i moved to page 2 search parameters are missed and no search result shown. Can u upload the tutorial pagination with search field ? Tnk u for ur quick response.
Thank u so much very easy and easily understand tgank u
Happy to help
Thank you so much for the lesson, everything worked, but for some reason "DESC" in the $sql variable does not work for me, it gives an error🤔
DESC is to fetch lastest one first. put DESC after ORDER BY id. liek this "SELECT* from posts ORDER BY id DESC"
Select count (*) from posts . in this query what is posts either it is table name or a predefined variable?
posts is table name and count(*) means count all records in table.
Baqi teek ha lkn agr hmare pass long list ha like 15 pages ha our ham chahte ha ka sare show na ho jo selected page ha os se ek next our ek previus page pagination ma show ho to wo kase kar sakte ha?
tub previous or next k button ho ga. usa pay ap pages read karo gaay k next or previous page kon sa hei. concept yhin rahy ga
@@WebMentorDev concept to yahi ha lkn agr hmare pass 100 pages ha ab 100 pages ko to show nia karaskte page par show to sirf 5 ya 6 buttons ko karen ga os logic ki samaj nai arahi
@@WebMentorDev for example agr 5 page selected ha 100 pages ma se to page par sirf 3,4,5,6,7,8 pages show ho
us k liay select tag ki dropdown list create kr skty hein. ya 1, 2,3,4 ... 100. is trha say pacges ho first, 4th pay click karon to agay 5 a jain or first 1 sat3 hide ho jain. agar dobara 4 pay click karin pahly wali postion pay a jain. asay kr skty hein. laravel mein by default hota hei asa. Easiest tarika dropdown wala hei ya number wala. Select with datalist
Write a code for getting single value with Where clause and use pagination for it
Like select *from employee where CONCAT(city,district,state) like %location% limit $offset,$limit;
Спасибо
It is not working in search field
what happed? you might have missed something. Get git hub code and try it
@@WebMentorDev when i moved to page 2 search parameters are missed and no search result shown. Can u upload the tutorial pagination with search field ? Tnk u for ur quick response.