Ajax Live Data Search with jQuery PHP MySQL

[@ciyaarahadunidaoffical5474]

Best soft soft tutorial for beginners on RUclips! I'm an absolute beginner and all the other tutorials I've found on RUclips 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 :)

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

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

[@noveltunez6546]

arguably the best tutorial on RUclips.

[@websitegeek7099]

Thanks :)

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

[@yashsingadiya9850]

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

[@websitegeek7099]

Thanks:)

[@bilalboss152]

Yoo tnx dude, everytNice tutorialng works. I LIKE IT

[@websitegeek7099]

Thank you :)

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

[@ryanudatinya6253]

this was very informative and easy to understand. Thanks alot

[@websitegeek7099]

Thanks:)

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

[@mehaksafdar5536]

bro i m trying my hard and its done 👍🏼

[@codeGamerOfficial]

love it! everything clearly discribed.

[@websitegeek7099]

Thanks :)

[@zlatkogurmesev1132]

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

[@websitegeek7099]

Thanks

[@Ahmadabbasi20]

Thank you Soo much am trying this since last some days

[@BelaKun-y1s]

When type something in the input field and delete it with

[@KhurramAziz-h4i]

Excellent ! I subscribed !!!

[@muthurams4809]

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

[@websitegeek7099]

Beginners video?

[@ugurhurcan]

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

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

[@muratulusoy3639]

Thanks a lot. Very useful content.

[@dogone1330]

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

[@websitegeek7099]

Thanks :)

[@eramperwez4617]

Thank you so much Ma'am😊😊😊

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

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

[@tarunjaiswal914]

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

[@websitegeek7099]

Thanks :)

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

[@php.amateur9905]

Très simple et pratique

[@aissoumonder3518]

Which extension do you use ?

[@misiu475]

The best tutorial... thank you

[@websitegeek7099]

Thanks :)

[@MOhamedKhaled-se5mn]

Thank you very much, this was helpful to me

[@firtoshkumar2115]

Awesome ji hadd khubsurat

[@hermesonfg]

what version of mysql and php you used?

[@websitegeek7099]

mysqli & php version : 8

[@khalidhalder7297]

Thanks. It helped me a lot

[@websitegeek7099]

Thanks :)

[@Ibrarhussain.official]

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

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

[@greesevijay4550]

perfect Tutotrial Ever

[@websitegeek7099]

Thanks :)

[@nikolabibercic5636]

Great tutorial!

[@websitegeek7099]

Thanks :)

[@bestmovieclips3999]

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

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

[@sagarkumar-ly8zq]

if input empty no data shows ??

[@writetermpapers]

Really nice video.

[@websitegeek7099]

Thanks for the appreciation :)

[@HollyDiver-pn2ep]

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

[@naykaneha9565]

Can i use thi code in my website??

[@mazidulhoque4384]

please make a tutorial update any information of search data

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

[@nestonkaplid6531]

Good work thank you.

[@user-jy3ml3dn4f]

Can you please share the source code

[@BenKopec]

Very good! Thanks!

[@websitegeek7099]

Thanks:)

[@edgarpione5916]

thank you or this very useful tutorial !!!

[@websitegeek7099]

Thanks :)

[@tomaszt1397]

What about sql injection?

[@MukeshYadav-so1sz]

Very Thanks!!! 😄

[@websitegeek7099]

:)

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

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

[@99danwil]

same trouble. it give result just once, then u have to refresh

[@rexstrife143]

thank you i love you!

[@websitegeek7099]

Thanks :)

[@Kun006]

great thank you!

[@websitegeek7099]

Thanks :)

[@shinvlog1126]

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

[@kishandebbarma4235]

how to make it case sensitive?

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

[@Terrific1v9]

Thanks Jamal

[@topguy1971]

mysqli_connect is outdated

[@toyly2820]

Perfecto

[@tusharrex9534]

Helpful for me

[@seleman-MW]

Thank you🙏🏾

[@rayenmansour-ru6bk]

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

[@irfanmughal2352]

Amazing

[@zidanrizky1580]

Thanks man

[@gaveshbandara6012]

internet nedda?

[@HealthWealth-to3vg]

Nice

[@EddyMedinaDesigner]

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

[@MahdiMOhamadi-g8g]

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

[@manjularathnayaka]

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

[@websitegeek7099]

Please check your jQuery code

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

[@orlinchirinos1981]

I want to get the source code for this

[@rbaby4307]

Super

[@marcioinumaru5586]

Please provide the code...
Thanks

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

[@nadirlaouar8376]

may I have the source code please ?

[@kaitoukidmlbb]

File pls. 😭😭😭

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

رائع

[@websitegeek7099]

Thanks :)

[@lincyarokeiyamary3161]

Source code pls

[@bolajiteslim9408]

source code pls

[@khalidsiyal9266]

Source code plz?

[@kingmega8730]

Source

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