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!!
#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
You could also put a required in at the input. So you can only hit the button if there is a value in it. And thus you don't go to an empty page with only an error message. This is atleast what I did :P
@@ryandewilde6396 Problem with that is if someone still really wanted to see all the records, they could just inspect element and remove the required attribute manually or just type in a space and all the results that include a space will appear
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.
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!
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.
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!
@Pak Home Well, in my case it took years. And I'm still learning. The more you look at code and play with it the more you begin to understand it. It's kind of like learning another language, like Spanish.
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
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.
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!
Thank you so much for this, sir! I've been really stressed out since I'm still a beginner to php but this video and your clear explanation really helped me a ton! I really appreciate this. Liked and subscribed so that it can reach a wider audience. Hope you're having a great day. :)
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.
Thank you bro you're the best GEEK, I had a problem of search bar which was missing on my site and now you saved my a**!! Thank you so so much. If possible you would make for me two videos one showing how to add a download button with an embedded link from the database and another one showing how to make an auto_complete search-bar.
Daniel, you did the best php tutorial in the web. ı feel like I spent quality time in your lessons. I have learned great things thanks to you! I cannot thank you enough. I have a request from you though :) could you make a tutorial about star rating system in php? Maybe you can include a system where users can add content to favorites etc. I am curious about how to create many-to-many relationship in mysql and most of all how to implement this in php? Rating system or add to favorites seems perfect to learn. Again, thanks for your great efforts.
Simply a legend, and danish at it at well. Musician at the conservatory trying to get a sidegig. I've followed a lot of your great tutorials, and are very close to finishing my website. I was wondering what you've studied at the university, and do you know if you need an education to become a web developer, (or software-engineer in general), or can you get a job with the skills you provide tutorials for? I'm very curious! A video about it would be nice, but a comment will also do - I'll take what I can get ;)!
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
thank you very much. The way you teach us is very clear, so we easy to understand the tuts. Question: do we really need always to include $conn variable before $_POST['search'] ? What I know is that mysqli_query function always need two arguments and one of them is $conn and the query statement.
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 !
Very Nice Tutorial! Super easy to follow thank you! Can you make a video how to search every table in a database? Like for example you have 5 tables (cars, users, maintenance, contact, price). Because I been trying to refactor your example code but it's fighting me and being a beginner I don't know enough about PHP to figure why I can't get it to work.
Daniel, thanks a lot for all fantastic videos! I guess you have a lot of things to do already, but you should be a tutor on some university! Your codes and speech are very clear and easy to understand! Bravo!
Great tutorial thanks! I would be interested to know with regards to the comments from Junior WebDeveloper below, which of the two solutions to the empty search box situation is the "correct way"?
Very nice things so beautifully explained. Before watching this video, I thought searching is the most puzzling part of the website but after that I'm just like this is a piece of piss..😂😂😂
Thank you so much for your amazing explanation, this video has been really helpful to me. But I got one problem I don't know how to deal with it. I have two tables in my database, how to access both of them from my search field?
"Search" code starts at 28:53
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!!
I always come to this guys videos and i am always 100% satisfied. this guy is a legend. I am subbing
please i want the code for my university it dont print any thing when search
Thank you very much for this video, it is very easy to understand.
#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
You could also put a required in at the input. So you can only hit the button if there is a value in it. And thus you don't go to an empty page with only an error message. This is atleast what I did :P
@@ryandewilde6396 yeap, i didn't know about "required " attribute then 😅
@@ryandewilde6396 Problem with that is if someone still really wanted to see all the records, they could just inspect element and remove the required attribute manually or just type in a space and all the results that include a space will appear
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.
I myself just want to thank you personally for making these tutorials. Yours always help me better then any else.
please can u send me the codes please
It makes easy to learn when you explain everything properly. It helped me a lot. Thank you for the videos
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!
You are the best. All the things are very clear. Thank you So much Mr. Danniel...
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.
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!
you know i'm professional PHP Programmer .. and i really enjoy with ur video .
respect ..♥
@Pak Home Well, in my case it took years. And I'm still learning. The more you look at code and play with it the more you begin to understand it. It's kind of like learning another language, like Spanish.
Do you use PDO or mysqli ?
THANK YOU KIND SIR, YOUR TUTORIALS DO THE MOST.
SHOUT OUT ALL THE WAY FROM SOUTH AFRICA!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
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
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.
This is amazing. Thank you so much. This helped me in my MBA course
Your Tutorial is very useful, please keep going 🙏🙏
Your videos really help. You explain every method and concept very thoroughly. i learned a lot from your videos. Thanks.
omy you actually helped me on my project! thank you so much you earned a new sub! keep up the great work my man!
Best , clear , simple ,
Thank you Danial it was really useful ,
Thank you for your time and efforts .
You explained it very clearly. Thumbs up!
Absolutely love your tutorials man keep posting you create a lot of value for the programming community!
Love the details video! So clear for new bie like me to understand
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!
Thanks for this tutorial: you are a really good teacher!
Great video, i did this followed the tutorial but did everything using PDO instead, still worth the watch
One of the best tutorial i've ever listened.....
Thank you so much for this, sir!
I've been really stressed out since I'm still a beginner to php but this video and your clear explanation really helped me a ton! I really appreciate this.
Liked and subscribed so that it can reach a wider audience.
Hope you're having a great day. :)
Hi sir thank you for creating this kind of tutorial this program help me a lot for my thesis :)
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.
Thanks you for all your PHP tutorials mmtuts :) just downloaded the full part of PHP tuts.
i have learned a lot from your tutorials, very well explained, thank you!!
thank you so so so much! it helped me a lot for my exam next week
Thank you! Good explaining and I like that you explain what everything is and does!
Subscribed and Followed!
Hi Daniel! All your tutorials are so so amazing, thanks for sharing your knowledge.
Omg! This is one of the best videos I have ever seen😍!!!
The way you have explained the concepts is really awesome👍
Keep making such video.❤️from🇮🇳
Your lessons explain everything so well! Thank you so much!
Your tutorials are amazing! Thank you so much for the knowledge!
Thank you so much for your video tuts, they helped me a LOT during my traineeship. Keep up the good work, looking forward to more tutorials!
Thank you so much for your unselfish sharing! I really appreciate it. Keep going. You did a really good job!
i am new in webdeveloping and this video is sooooooo helpful. Can i give more than one thumbsup? Anyways, thanks for sharing this. kudos
Thanks Dani, that was very helpful 😍
very effective php ...!!!
Really it is true.
If, I could Subscribe to this Channel 100000+ times, I would do ...!!!!!
Wow, you just created a mini CMS here. Really liked it, thanks!
"but note that the author does have a big D" I see what you are trying to tell us mister Daniel ;) LOL
Fair warning!
i thought i was the only one. lol Daniel with a big D. 3:12
hahah
and in Philippines (in Visayas) , Otten also is a D tho. +10 intelligence
hahahaha wtf
Thank you for sharing your knowledge. Nice job!
In most cases, ID is used to refer to the article. Using title and date of article seems to be pointless. Anyway, the tutorial is nice!
Thank you man, it is very helpful! Keep up the good work. :)
Thank you bro you're the best GEEK, I had a problem of search bar which was missing on my site and now you saved my a**!! Thank you so so much. If possible you would make for me two videos one showing how to add a download button with an embedded link from the database and another one showing how to make an auto_complete search-bar.
THANK YOU!
please can u send me the code when i search it dont print any thing
Super helpful, Thank so much!
Daniel, you did the best php tutorial in the web. ı feel like I spent quality time in your lessons. I have learned great things thanks to you! I cannot thank you enough. I have a request from you though :) could you make a tutorial about star rating system in php? Maybe you can include a system where users can add content to favorites etc.
I am curious about how to create many-to-many relationship in mysql and most of all how to implement this in php? Rating system or add to favorites seems perfect to learn.
Again, thanks for your great efforts.
3:14, this put a smile to my face
Great Tutorial! Please make a tutorial for the directory listing website's multiple search box filtering.
dude you are amazing! thank you.
Simply a legend, and danish at it at well. Musician at the conservatory trying to get a sidegig. I've followed a lot of your great tutorials, and are very close to finishing my website. I was wondering what you've studied at the university, and do you know if you need an education to become a web developer, (or software-engineer in general), or can you get a job with the skills you provide tutorials for? I'm very curious! A video about it would be nice, but a comment will also do - I'll take what I can get ;)!
Thank your very much for your good job.
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
Thanks you! very very much..it's a great tutorials,. All tutorials Excellents..
Thank you :)
I learn so much watching your PHP videos. Can you please make a video creating a search field with pagination?
I'll wirte it down ;)
this is a great tutorial a suggestion though you should add comments to your code that way we always have a reference to what is what
thank you very much. The way you teach us is very clear, so we easy to understand the tuts. Question: do we really need always to include $conn variable before $_POST['search'] ?
What I know is that mysqli_query function always need two arguments and one of them is $conn and the query statement.
It helped me a lot.
You Nailed it! Just what I needed. :)
Says Quagmire haha
please can u send me the code
This was a massive help. Thank you
thank you this what i need. hope you make a advance search field.
Thank you for the video!
best tutorial THanks
Thank you VERY VERY VERY VERY much
Thank You for your hard work.
Thank you very much, very helpful.
THANK YOU MAN YOU'RE THE BEST
You're the best
Thanks so much, Daniel! You rock
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 !
Great points you expressed here. Thanks.
Been waiting for this! Love it
Very Nice Tutorial! Super easy to follow thank you! Can you make a video how to search every table in a database? Like for example you have 5 tables (cars, users, maintenance, contact, price). Because I been trying to refactor your example code but it's fighting me and being a beginner I don't know enough about PHP to figure why I can't get it to work.
I really love you man. But please include some timing so we can jump to where we wanna get to.
Daniel, thanks a lot for all fantastic videos! I guess you have a lot of things to do already, but you should be a tutor on some university! Your codes and speech are very clear and easy to understand! Bravo!
i never knew that making a functioning search field could be easy.
Can you pretty pls make a video about creating a live chat system?
I am also eagerly waiting
easier way to do a livechat is to use mongodb + express + nodejs :)
@@MrFckingninja express is node
Great tutorial thanks! I would be interested to know with regards to the comments from
Junior WebDeveloper
below, which of the two solutions to the empty search box situation is the "correct way"?
It's very helpful video :D Thanks!!
understandable!!!
illustrative!!!
keep going!!!
Make a video about how to make a brand filter for online shop
Thanks a lot for this
Great video, thank you!
Thamk you so Much Brother..:) 🧡🧡🧡
Thnx man for helpful tutorial ♥️🙏
THANK YOU VERY VERY MUCH!!!!!!!!!!
Thanks for helpful video
Awesome video, thanks
if you get an Warning like "Notice: Use of undefined constant” use echo "".$row['a_title']."";
(with single quotes) instead
Very nice things so beautifully explained. Before watching this video, I thought searching is the most puzzling part of the website but after that I'm just like this is a piece of piss..😂😂😂
Thank you so much for your amazing explanation, this video has been really helpful to me. But I got one problem I don't know how to deal with it. I have two tables in my database, how to access both of them from my search field?
You should do a tutorial on how to create a profile page with the ability to post blogs
Thank You! Sir.
hi Dani It was very helping Tnx!!!, But How about when we have multiple tables???
Hello, thank you for your great video 🌹
I have a question...
Why is date and time types ('type='date') not used for searching?