Ajax Live Data Search with jQuery PHP MySQL

[@piku5224]

Very simple and very useful with great explanation. Thanks from,KOLKATA, India

[@ciyaarahadunidaoffical5474]

Best soft soft tutorial for beginners on KZbin! I'm an absolute beginner and all the other tutorials I've found on KZbin have been so

[@websitegeek7099]

Thanks :)

[@photoinshot1355]

Brilliant! Thanks for an excellent tutorial, clearly and fully explained and expertly presented, love your expert use of language to give detailed and clear explanations with the minimum of words to get the message across, so this make it a very efficient tutorial. Clearly a talented coder and expert tutor. Thanks!

[@websitegeek7099]

Thank you so much for your appreciation :)

[@aChannel13813]

i like the fact you have the text to speach explain while coding, make it easier to understand why you write something.

[@DavidAshby1]

'%$input%' worked for me, rather than '{$input}%'. Thanks for the tutorial.

[@erinc2001]

I just wanted to add that only '%' . $input . '%' worked for me in case that helps anyone else! Thanks

[@noveltunez6546]

arguably the best tutorial on KZbin.

[@websitegeek7099]

Thanks :)

[@umitarslan1125]

Thank you so much. I solve my terrible problem after watching your video. You explain very well

[@websitegeek7099]

Thanks :)

[@gennarodolce4722]

Awesome!!! I followed step by step all work well!!! Thanks

[@websitegeek7099]

Thanks:)

[@lincyarokeiyamary3161]

Source code pls

[@victorromiux]

Thank you for everything, greetings from Mexico City.

[@websitegeek7099]

@@victorromiux Thank you so much

[@polareda687]

At first, thanks 🤗 After I learned the correct method from you, I was able to invent simpler methods with the same results. Keep going. Thank you again.

[@websitegeek7099]

Thank you :)

[@zlatkogurmesev1132]

Fast and simple ... Other users make a talk show out of a simple project.. *****🎉

[@websitegeek7099]

Thanks

[@codeGamerOfficial]

love it! everything clearly discribed.

[@websitegeek7099]

Thanks :)

[@ryanudatinya6253]

this was very informative and easy to understand. Thanks alot

[@websitegeek7099]

Thanks:)

[@bilalboss152]

Yoo tnx dude, everytNice tutorialng works. I LIKE IT

[@websitegeek7099]

Thank you :)

[@yashsingadiya9850]

Ohhh gosh super simple and you also given us some extra knowledge So for that thank you 😊😊

[@websitegeek7099]

Thanks:)

[@mehaksafdar5536]

bro i m trying my hard and its done 👍🏼

[@dogone1330]

Thank you so much, you've been very helpful.

[@websitegeek7099]

Thanks :)

[@Ahmadabbasi20]

Thank you Soo much am trying this since last some days

[@Rahimoff666]

Thank you so much for this video I liked your video .

[@websitegeek7099]

Thanks :)

[@KhurramAziz-h4i]

Excellent ! I subscribed !!!

[@fivesauceftbananas8319]

tysm! but i need to reload when i want to search again, how can i do it to fix that?

[@imadasly5857]

Have you found the answer?

[@marky1756]

We're the same problem here.. It need to reload or refresh the page.

[@bestmovieclips3999]

@@imadasly5857 same to me.did you find a solution?

[@misiu475]

The best tutorial... thank you

[@websitegeek7099]

Thanks :)

[@BelaKun-y1s]

When type something in the input field and delete it with

[@TejasAgarwal90]

How can select drop down value without using form or submit button and put it's value in MySQL query for data search? In php page.

[@khalidhalder7297]

Thanks. It helped me a lot

[@websitegeek7099]

Thanks :)

[@muthurams4809]

Mam osam teaching ❤.... Mam please upload jQuery and php tutorial mam❤🙏

[@websitegeek7099]

Beginners video?

[@eramperwez4617]

Thank you so much Ma'am😊😊😊

[@muratulusoy3639]

Thanks a lot. Very useful content.

[@MOhamedKhaled-se5mn]

Thank you very much, this was helpful to me

[@berndopoku-boadu3416]

Hi thank you for the explanation. I'm trying to do this and allow one to edit and delete the data found from the search but it's not working. Can you help me?

[@websitegeek7099]

You have to apply jQuery again for the edit & delete option .. First you have to add the edit button on data found row and then after clicking on the edit button a jQuery code will execute to change all the found data into editable data . Then add the submit button & on clicking it again run the jQuery submit form code . To delete the record , add anchor tag with row's ID like this

[@Ibrarhussain.official]

Hello.. I Like your work. It's super cool. Can I get the source file? It will help me.

[@firtoshkumar2115]

Awesome ji hadd khubsurat

[@epicosexio]

So as long the thing is not empty, it will continue posting and display queried results.. what if i want to to post even when it's empty for more consistency, so that i dont have to reload the page to get it working again

[@tarunjaiswal914]

Very useful and informative video thanks for making it ....👌

[@websitegeek7099]

Thanks :)

[@greesevijay4550]

perfect Tutotrial Ever

[@websitegeek7099]

Thanks :)

[@ugurhurcan]

Hello, if we do this search with pdo instead of mysqli, what should we write mysqli_query, mysqli_num_rows , mysqli_fetch_assoc

[@user-jy3ml3dn4f]

Can you please share the source code

[@lazybusylog5081]

So easy, so informative, and for very short time!!! Awesome! You are one of the best developer! BTW, why we must use "Display NONE and DISPLAY BLOCK ? Anyway, thanks a lot!

[@websitegeek7099]

Thanks:) .. Answer: If you will search any keyword and you will not use ($("#searchresult").css("display","none"); ) code, then it will remains on the screen even after clearing the search box. To remove the result after clearing the search box, i have used this code :($("#searchresult").css("display","none"); )

[@lazybusylog5081]

@@websitegeek7099 It is TRUE )) I checked... :) But I did not catch this... how does css("display", "block") work?

[@websitegeek7099]

@@lazybusylog5081 display block makes the resulted div section visible after finding the result .. if any result not found then it will remain invisible

[@sisaygame9550]

Hi It didnt work for me can you help me pls? i cant see any error when i run the program but when i write something in search input i didnt see any result.

[@edgarpione5916]

thank you or this very useful tutorial !!!

[@websitegeek7099]

Thanks :)

[@bestmovieclips3999]

please help how to fix this , reload first before search again?

[@nikolabibercic5636]

Great tutorial!

[@websitegeek7099]

Thanks :)

[@mazidulhoque4384]

please make a tutorial update any information of search data

[@writetermpapers]

Really nice video.

[@websitegeek7099]

Thanks for the appreciation :)

[@hermesonfg]

what version of mysql and php you used?

[@websitegeek7099]

mysqli & php version : 8

[@Sofia-ilms]

The display wont clear once you clear the text box, the fix for that is to put the display block outside the if else statement, put that in the line of sample alert

[@websitegeek7099]

@@Sofia-ilms i am not able to get you ... Can you explain a little more?

[@mxxxio]

thank you very much for your effort! I am getting an 405 error (Method Not Allowed). Fk this CORS errors. What I have to do?:( Another question. I try to virtualize my html with an extension called live Server but probably thats also wrong. Can you give me a hint?

[@mxxxio]

Solution - Use XAMPP or WAMP or something like that

[@TROUBLEA]

I have this error showing up : Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given Is it normal ?

[@amboula5036]

you need to pass result as parameter like this mysqli_num_rows($result)

[@rexstrife143]

thank you i love you!

[@websitegeek7099]

Thanks :)

[@MukeshYadav-so1sz]

Very Thanks!!! 😄

[@websitegeek7099]

:)

[@BenKopec]

Very good! Thanks!

[@websitegeek7099]

Thanks:)

[@sagarkumar-ly8zq]

if input empty no data shows ??

[@aissoumonder3518]

Which extension do you use ?

[@HollyDiver-pn2ep]

the whole code stops after searching once, how do I stop it

[@shinvlog1126]

i see error i need to reload when i search again how to fix this

[@ragnarocking]

Would this be appropriate for a database with about 300,000 records, or would there be significant performance issues? Thanks

[@ragnarocking]

answered my own question. It works just fine with 300k records as long as the query that drives the text box's results is efficient.

[@nestonkaplid6531]

Good work thank you.

[@kishandebbarma4235]

how to make it case sensitive?

[@tomaszt1397]

What about sql injection?

[@AkashSharma-kx5xd]

This only gives me result once after that i have to refresh the page and again search it

[@websitegeek7099]

First step: check the jquery event , is it working properly means it is giving results or not. To check it: alert("hy"); after a keyup event like id already did in starting

[@Kun006]

great thank you!

[@websitegeek7099]

Thanks :)

[@rayenmansour-ru6bk]

Good job !!! is there any source code for this project plz !!!

[@naykaneha9565]

Can i use thi code in my website??

[@EddyMedinaDesigner]

I need a more secure config file. But thanks a lot!

[@topguy1971]

mysqli_connect is outdated

[@seleman-MW]

Thank you🙏🏾

[@Snake_1v9]

Thanks Jamal

[@manjularathnayaka]

I try this code but my live search.php not redirect .

[@websitegeek7099]

Please check your jQuery code

[@tusharrex9534]

Helpful for me

[@zidanrizky1580]

Thanks man

[@MahdiMOhamadi-g8g]

Hello, it was great, but can you put the file in the download link?

[@irfanmughal2352]

Amazing

[@toyly2820]

Perfecto

[@kaitoukidmlbb]

File pls. 😭😭😭

[@orlinchirinos1981]

I want to get the source code for this

[@HealthWealth-to3vg]

Nice

[@alikaalbright1422]

How do I get the source code

[@muthurams4809]

Mam please php web development tutorial ❤

[@websitegeek7099]

Thanks

[@websitegeek7099]

Beginners?

[@meyladalazawi6354]

Wonderful, well done....and the sound is very wonderful.... with the search with the multiplicity of pages

[@marcioinumaru5586]

Please provide the code... Thanks

[@gaveshbandara6012]

internet nedda?

[@nadirlaouar8376]

may I have the source code please ?

[@lincyarokeiyamary3161]

Source code pls

[@erhansarici9213]

hahahaha i didnt wait last minute from your video and im trying maybe in 1 hours " delete in input why againg not coming the name why nothing " hahahaha omg because i didnt add in if display:block; !!

[@bolajiteslim9408]

source code pls

[@khalidsiyal9266]

Source code plz?

[@rbaby4307]

Super

[@kingmega8730]

Source

[@يحيىالقانوع-ث9ش]

رائع

[@websitegeek7099]

Thanks :)

[@0scaar247]

Emit089 thanks man

[@websitegeek7099]

Thanks :)

[@Malus.m]

i see error i need to reload when i search again how to fix this

[@fivesauceftbananas8319]

yeahh, me too, are you fixed it?

[@Malus.m]

@@fivesauceftbananas8319 yeees bro

[@definitelynotpochita5653]

@@Malus.m where's the problem can you share it?

[@larnedreal9553]

@@definitelynotpochita5653 watch till the end

[@bestmovieclips3999]

how to fix?

[@sunilweerasinghe]

Super

[@rakibahsan6786]

source code please