57: How to create a search field with PHP and MySQLi | PHP tutorial | Learn PHP programming

How to create a search field with PHP and MySQLi - Learn PHP backend programming. In this video we will learn how to create a search feature using PHP from scratch.

➤ GET ACCESS TO MY LESSON MATERIAL HERE!

First of all, thank you for all the support you have given me!

I am really glad to have such an awesome community on my channel. It motivates me to continue creating and uploading content! So thank you!

I am now using Patreon to share improved and updated lesson material, and for a small fee you can access all the material. I have worked hard, and done my best to help you understand what I teach.

I hope you will find it helpful :)

[natiqmumtaz]

"Search" code starts at 28:53

[xiaoyang]

This session really wowed me. As a total programming dummy, I didn't know you can build a search function by watching just 46 mins of video. Thank you Daniel!!

[atik]

#2020
I wrote the exact same script and found one problem which is, when you hit submit without typing anything into the input field, it shows all the records from your database table.
I was about to ask Daniel for a solution but then I thought, wait a minute! it's easy :-)

So in case anyone face the same problem and need a solution, just do this..
after getting user input, run an if statement like,

if ( $input != null ) {
rest of the code;
} else if ( $input == null ) {
error message;
}


And thank you so much Daniel <3
the way you explain things, it's really Amazing!

[CaptainAwesomeVlog]

Perhaps the best thing about your tutorials is that they provide a basis from which I am able to extend and adapt the content to my needs quite easily. Today I finished my search tool based on your tutorial, for my multi-user image gallery. Works perfectly.

[jarrodestepp]

I myself just want to thank you personally for making these tutorials. Yours always help me better then any else.

[arjuntantry]

ahh just what i wanted finally!! i actually recommend watching all earlier 56 videos and then come back here because you probably wont completely understand whats going on here ill tell ya something these tutorials are such a confidence booster to me .Thanks Daniel!

[akachi]

I always come to this guys videos and i am always 100% satisfied. this guy is a legend. I am subbing

[akashdhanorkar]

It makes easy to learn when you explain everything properly. It helped me a lot. Thank you for the videos

[MohPhpMaster]

you know i'm professional PHP Programmer .. and i really enjoy with ur video .

respect ..♥

[CalvinBonner]

I know this video was posted years ago, but thank you! This was super informative as always. I don't know if you ever plan to post an updated video but, if you do, I would love to see how this search function could work with full pages on the site (so instead of putting all the data in the database itself, you can search through all pages on the website). Anway, thanks again!

[benimdraws]

Dude... I'm here in 2020 and your tutorials are just the best, no doubt about it. You explain everything so good and I have NEVER failed with something when watching your tutorials. Are you a magician or something? haha :D

[creativesasi]

You are the best. All the things are very clear. Thank you So much Mr. Danniel...

[marlonmartins]

This lesson was so useful for me to work on my page integrating PHP and SQL queries with container results div. Thank you so much! Greetings from Brazil.

[joelcortez]

Thank you very much for this video, it is very easy to understand.

[elel]

Fantastic lesson. This will keep me busy coding my own website for the next week. So many questions I had have been answered in this video. Huge thanks.

[WvyyFPS]

Thank you so much for this tutorial. This helped me so much while taking development courses during the pandemic. Wouldn't have been able to have learned this without you!

[garfielf]

39:21 I think line 15 echo "There are ".$queryResult." results! "; should be below the if ($queryResult > 0) statement instead, because if you get 0 results the page will say both "There are 0 results" and "There are no results matching your search", which is a bit redundant. Thanks for video

[brebz]

Hello !
Is there a reason why at min 33:59 when you add the $search inside the string you don't wrap it around two dots ? Like you do at 39:29 ?
Also great work with the tutorials ! They are amazing !

[germanduterte]

from mmtuts to Dani Krossing I love all of ur tutorial, It's really a big help to people like me who can't afford paying for proper education. very poor guy.

[SANBIRTRADING]

Great Tutorial! Please make a tutorial for the directory listing website's multiple search box filtering.