Ajax Live Data Search with jQuery PHP MySQL

[@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 :)

[@ciyaarahadunidaoffical5474]

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

[@websitegeek7099]

Thanks :)

[@piku5224]

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

[@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

[@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 :)

[@umitarslan1125]

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

[@websitegeek7099]

Thanks :)

[@bilalboss152]

Yoo tnx dude, everytNice tutorialng works. I LIKE IT

[@websitegeek7099]

Thank you :)

[@noveltunez6546]

arguably the best tutorial on TH-cam.

[@websitegeek7099]

Thanks :)

[@gennarodolce4722]

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

[@websitegeek7099]

Thanks:)

[@lincyarokeiyamary3161]

Source code pls

[@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?

[@codeGamerOfficial]

love it! everything clearly discribed.

[@websitegeek7099]

Thanks :)

[@mehaksafdar5536]

bro i m trying my hard and its done 👍🏼

[@BelaKun-y1s]

When type something in the input field and delete it with

[@victorromiux]

Thank you for everything, greetings from Mexico City.

[@websitegeek7099]

@@victorromiux Thank you so much

[@zlatkogurmesev1132]

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

[@websitegeek7099]

Thanks

[@yashsingadiya9850]

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

[@websitegeek7099]

Thanks:)

[@ryanudatinya6253]

this was very informative and easy to understand. Thanks alot

[@websitegeek7099]

Thanks:)

[@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

[@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 :)

[@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.

[@muthurams4809]

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

[@websitegeek7099]

Beginners video?

[@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

[@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

[@ugurhurcan]

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

[@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.

[@muratulusoy3639]

Thanks a lot. Very useful content.

[@eramperwez4617]

Thank you so much Ma'am😊😊😊

[@khalidhalder7297]

Thanks. It helped me a lot

[@websitegeek7099]

Thanks :)

[@user-jy3ml3dn4f]

Can you please share the source code

[@misiu475]

The best tutorial... thank you

[@websitegeek7099]

Thanks :)

[@bestmovieclips3999]

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

[@aissoumonder3518]

Which extension do you use ?

[@KhurramAziz-h4i]

Excellent ! I subscribed !!!

[@tarunjaiswal914]

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

[@websitegeek7099]

Thanks :)

[@MOhamedKhaled-se5mn]

Thank you very much, this was helpful to me

[@sagarkumar-ly8zq]

if input empty no data shows ??

[@greesevijay4550]

perfect Tutotrial Ever

[@websitegeek7099]

Thanks :)

[@shinvlog1126]

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

[@Ibrarhussain.official]

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

[@hermesonfg]

what version of mysql and php you used?

[@websitegeek7099]

mysqli & php version : 8

[@mazidulhoque4384]

please make a tutorial update any information of search data

[@naykaneha9565]

Can i use thi code in my website??

[@HollyDiver-pn2ep]

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

[@tomaszt1397]

What about sql injection?

[@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)

[@edgarpione5916]

thank you or this very useful tutorial !!!

[@websitegeek7099]

Thanks :)

[@kishandebbarma4235]

how to make it case sensitive?

[@topguy1971]

mysqli_connect is outdated

[@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.

[@nikolabibercic5636]

Great tutorial!

[@websitegeek7099]

Thanks :)

[@writetermpapers]

Really nice video.

[@websitegeek7099]

Thanks for the appreciation :)

[@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

[@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

[@MukeshYadav-so1sz]

Very Thanks!!! 😄

[@websitegeek7099]

:)

[@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?

[@rexstrife143]

thank you i love you!

[@websitegeek7099]

Thanks :)

[@BenKopec]

Very good! Thanks!

[@websitegeek7099]

Thanks:)

[@nestonkaplid6531]

Good work thank you.

[@firtoshkumar2115]

Awesome ji hadd khubsurat

[@Kun006]

great thank you!

[@websitegeek7099]

Thanks :)

[@rayenmansour-ru6bk]

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

[@manjularathnayaka]

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

[@websitegeek7099]

Please check your jQuery code

[@orlinchirinos1981]

I want to get the source code for this

[@alikaalbright1422]

How do I get the source code

[@EddyMedinaDesigner]

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

[@zidanrizky1580]

Thanks man

[@MahdiMOhamadi-g8g]

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

[@seleman-MW]

Thank you🙏🏾

[@kaitoukidmlbb]

File pls. 😭😭😭

[@gaveshbandara6012]

internet nedda?

[@tusharrex9534]

Helpful for me

[@Snake_1v9]

Thanks Jamal

[@marcioinumaru5586]

Please provide the code...
Thanks

[@toyly2820]

Perfecto

[@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

[@nadirlaouar8376]

may I have the source code please ?

[@irfanmughal2352]

Amazing

[@HealthWealth-to3vg]

Nice

[@lincyarokeiyamary3161]

Source code pls

[@bolajiteslim9408]

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; !!

[@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