Joseph, I wanted to say thank you as this was a really solid tutorial. BTW, I always find it better to have the mistakes as part of the training so that we get the opportunity to troubleshoot. It enhances the training and really enforces what was covered.
This was VERY helpful!!!! I am actually glad you made those few mistakes. It shows us what to do when if those errors come up for us! Way to go man!!!!!!!
Yes, the mistakes you made were ironically very useful to help demonstrate and identify your debugging methods. I like how you knew you had a misspelling in one of the variables as opposed to panic about why it didn't work.
I will get around to it, I have been super busy these holidays doing Helping Develop's website when ever I can... I will get back to all the tutorials once that is done so I have somewhere to house my source code and download packages etc!
I’m having some issues when I try your script; I’m getting a ‘500’ error code in my Chrome browser and in my Safari browser I just get a blank browser windows.. Regardless, yours is one of the best tutorials because not only do you explain WHAT you’re doing, you explain WHY you’re doing it!! Nice work!
Thank you very much Joe, you made know I can search not by "=" operation only but I can also use the like clause in searching for both names from my database
Oh my gash! What a great video bro!! Keep it up!! Your video was very helpful for us specially to us who were beginners! Ive learned so many things in this video. DONE SUBSCRIBE
Cool. Thanks. Btw I think it is realy good to make mistakes, becouse by that You helping us realize eventual problems we can face with in our work. BW. thanks again.
Hello, Mr. Smith. You can explain very clear php possibilities. Your example works with me very stable with a few moderations. Can you explain how to grab data from table generated after search and use it for example to insert in another table?
Nice tutorial, thanks. To update to mysqli I added/edited the following $dbc = mysqli_connect("localhost", "root", "PASSWORD") or die("Could not connect"); mysqli_select_db($dbc, "search_test") or die ("Could not find database. Please try again later"); $query = mysqli_query($dbc, "SELECT * FROM members WHERE firstname LIKE '%$searchq%' OR lastname LIKE '%$searchq%'") or die("Could not search"); Every reference to mysql should be changed to mysqli and obviously in the connection script make sure you enter the correct password and database name as well as the table name in the SELECT query. works like a dream.
Hey! What should I write on preg_replace statement if I want my search to include Cyrilic keyboard? Utf-8? Thank you for that lesson! U are the best teacher! You explain everything, using simple words so we can understand you! God bless!
Actually the mistake is ok and also a tutorial so we will know how to solve the problem if we also encounter those errors, by the way you help me with your tutorial a good one
Este video es genial !!! todo funciona como lo especifica !!! Thisvideo is great!!! everything works as you said !!! I hope you could upload any tutorial video especific to OOP PHP, thanks for your help.
Yeah I understand what you mean if you watch my jquery image slider tutorial that teaches that part... I will do a third part maybe tomorrow night, (might be a forth part too) about how to make a dynamic image slider :p meaning uploading images and displaying them automatically :D
Great video with explanations and all. I am new to php. Suppose I wanted to search from a table or array located within the php file itself, what do I need to do differently?
Amazing tutorial! So simple, so straight to the point, clear and precise! Now I wonder about the performance of this search....Would we need to make some kind of PHP based binary search? Or perhaps MySQL handles it all as long as we've specified "firstname" and "lastname" as indexes inside of our table???
awesome video sir...but can you please create a search base on selected drop down list example if i want to search first name then i select first the drop down list and find it using textbox in php
Joseph Smith I have a program that I want to put a search inside it ...to look for songs that I have already in the list....can you tell me how? Thanks
it works .. thnaks. but when pressing search button while text area is empry outputing all information in mysql. how to fix this problem? i want show this message "please fill area" when text area is empty and button pressed. thanks
its good but my concern is that i am making a real estate website in this i have a search form that have property-location property-type and property id so how to search it from php search operation. i want to get in output property_location propertytype and id.... plz answer me
thank you very much. worked fine !!!! can you please make a tutorial how to update information in the db ? i can insert and delet in the db but cant update.
Hey dude, Nice tutorial, Any Idea how I can code up my search bar to allow more than 1 input? For example, using your data - if the user was to type "pip smith" both first and lastname.. I want mine to be able to show 2 different results, At the minute when I type a space into the search bar and submit it, it just echo's out no data at all, it doesn't recognise the space, I hope you can help, Thanks! :)
Can you search the records without clicked on the button. I mean keypress. Just type anything into the fields and record will display.. Can you help me in this?
If I have a local Database and not one created in phpmyadmin , what should I put after mysql_connect? Let's say my db is in "C:/Apache2.2/htdocs/MTDB/App_Data and it is called dbo.Table.sql Where do I get what I should put in those three arguements in mysql_connect? If I never set my password, can I leave it empty? Thank you very much!
How do you display multiple records with the same name ? I mean I've tried also your way but I still it doesn't display multiple results. Maybe because of some coding in java which is included in my code?
I've been quoted 8 hrs to implement a PHP Search function on a site I'm having built , seems like you knocked it out in a fraction of the time... would you say my developer is inflating their numbers a bit?
Even though this is an old post, it's been the most helpful! Got my assignment done using it. BIG THANK YOU!
best teacher i ever see, i like because you explain everything
+eosforfly s Agree
thanks
Joseph, I wanted to say thank you as this was a really solid tutorial. BTW, I always find it better to have the mistakes as part of the training so that we get the opportunity to troubleshoot. It enhances the training and really enforces what was covered.
This was VERY helpful!!!! I am actually glad you made those few mistakes. It shows us what to do when if those errors come up for us! Way to go man!!!!!!!
Awesome Tutorial! Btw mistakes are actually a good thing because it can shed some light for other programmers to keep them aware and on their toes :)
WOW that was really really good. Great job i have spent a week trying to understand what I just learned here in 5 minutes. Thank you very much
Yes, the mistakes you made were ironically very useful to help demonstrate and identify your debugging methods. I like how you knew you had a misspelling in one of the variables as opposed to panic about why it didn't work.
your tutorials are amazing we don't care about typos
AWESOME VIDEO !!!! been searching all day to find out how to do this and voila you explained exactly what i needed
thanks a lot u saved my life as a student
I will get around to it, I have been super busy these holidays doing Helping Develop's website when ever I can... I will get back to all the tutorials once that is done so I have somewhere to house my source code and download packages etc!
Thank you very much for your effort it still working untill now and i use it in my graduation project
I’m having some issues when I try your script; I’m getting a ‘500’ error code in my Chrome browser and in my Safari browser I just get a blank browser windows.. Regardless, yours is one of the best tutorials because not only do you explain WHAT you’re doing, you explain WHY you’re doing it!! Nice work!
dude i dont know ur name but ur tutorial is excellent it helped me to solve my prblm....keep on posting the videos......thanx a lot
Loved seeing how you corrected the mistakes...very helpful!
Great Video! Thanks for making this. Explains a lot and easy to understand for Cavemen-Minds like me.
Very very comprehensive and clearly explained . Thank you very much.
You are awesome!
I subscribed you, your teaching is very hearable.
Thank you!
Please teach for people for studying PHP!!
Thank you very much Joe, you made know I can search not by "=" operation only but I can also use the like clause in searching for both names from my database
this video helped me a lot in completing my assignment. thanks!
Oh my gash! What a great video bro!! Keep it up!! Your video was very helpful for us specially to us who were beginners! Ive learned so many things in this video. DONE SUBSCRIBE
You expletion is perfect. I like it 😊
Useful Tutorial for all advance & beginners!
Great! Tried it with mysql, simple and working! Thumbs up!
thank you so much . your coding manage to help me make a search . thank you . i really need this :)
This tutorial is great. This helps me a lot. Thanks a lot.
Cool. Thanks. Btw I think it is realy good to make mistakes, becouse by that You helping us realize eventual problems we can face with in our work. BW. thanks again.
haha yes I guess! I just try to make my tutorials are professional as I can! :D Thanks for the comment though it makes me feel a lot better :D
Thank you you have helped me learn how to create my first search engine! Thank you!
thank you for the tutorial sir!! please kindly make a sample how to make printout of those items?
Amazing explanation brother. That was very helpful for my projects!
Hi, great tutorial, just what I was looking for, thanks.
Know I'm being lazy - but is there a zip file with the code that I can download?
Great tut. Thank you so much for it. Best regards
from Serbia.
superb and excellent tutorial ! helps me a lot !
Hello, Mr. Smith.
You can explain very clear php possibilities. Your example works with me very stable with a few moderations. Can you explain how to grab data from table generated after search and use it for example to insert in another table?
this was a great tutorial thank you very much and as to the mistakes i think that's good it shows what you have to do if something goes wrong.
Nice tutorial, thanks.
To update to mysqli I added/edited the following
$dbc = mysqli_connect("localhost", "root", "PASSWORD") or die("Could not connect");
mysqli_select_db($dbc, "search_test") or die ("Could not find database. Please try again later");
$query = mysqli_query($dbc, "SELECT * FROM members WHERE firstname LIKE '%$searchq%' OR lastname LIKE '%$searchq%'") or die("Could not search");
Every reference to mysql should be changed to mysqli and obviously in the connection script make sure you enter the correct password and database name as well as the table name in the SELECT query.
works like a dream.
Hey! What should I write on preg_replace statement if I want my search to include Cyrilic keyboard? Utf-8? Thank you for that lesson! U are the best teacher! You explain everything, using simple words so we can understand you! God bless!
VERY NICE and very helpfull tutorial
Fantastic tutorial. Helped me more than you imagine!!
Actually the mistake is ok and also a tutorial so we will know how to solve the problem if we also encounter those errors, by the way you help me with your tutorial a good one
Nice tutorials.. I learnt some more interesting things about php. Thank you.
Este video es genial !!! todo funciona como lo especifica !!!
Thisvideo is great!!! everything works as you said !!!
I hope you could upload any tutorial video especific to OOP PHP, thanks for your help.
Yeah I understand what you mean if you watch my jquery image slider tutorial that teaches that part... I will do a third part maybe tomorrow night, (might be a forth part too) about how to make a dynamic image slider :p meaning uploading images and displaying them automatically :D
I like this guy! You are awesome !
Great video! Really helpful!
nice tutorial.....Well done friend......
i like the way you start this tutorial
Has helped tremendously!
Hey I actually already knew how this works but this is an awesome tutorial :)!
Very nice tutorial. I am expecting more video on php mysql tutorial.
wow great teach !
Dinesh mountain guide in Nepal.
What algorithm is used here(I mean like binary search, depth first search etc)? I want to know the algorithm. Thanks
wooh!! you took me where i want to be...thanks very much
Good suggest there ! I am very Happy on this tutorial. seriously I say that it's very good code for me.
Good tutorial you explained well and nicely woww...!
very good teacher i love this lesson
Thanks it really worked...
Can you upload a video for Boolean search using multiple skills with AND operator
Thanks for the tut. You helped me know new :-)
Great video with explanations and all. I am new to php. Suppose I wanted to search from a table or array located within the php file itself, what do I need to do differently?
better than other tutorial :)
Amazing tutorial! So simple, so straight to the point, clear and precise!
Now I wonder about the performance of this search....Would we need to make some kind of PHP based binary search? Or perhaps MySQL handles it all as long as we've specified "firstname" and "lastname" as indexes inside of our table???
Thanks so much this tutorial is so much helpful for me
great tutorial. and great teacher. so details wow. thanks for taking the time :)
really,it help me alot
\thanx for video
Still a good explanation video. Thanks for the help!
thanks dude for your tutorial, it make my project easier xD
awesome video sir...but can you please create a search base on selected drop down list example if i want to search first name then i select first the drop down list and find it using textbox in php
Thanks a lot! This has been very helpful!
Very good tutorial - its notable that to get this to work I had to remove the https from the google java url and just have //
This nice tutorial.
Please, can I get the next to the next video
Great tutorial, How can I allow a hyphen in preg_replace?
Nice....Quite good to learn..
Going to use this on my website for sure! Thanks Joe :)
What is your website i wanna know
Joseph Smith I have a program that I want to put a search inside it ...to look for songs that I have already in the list....can you tell me how? Thanks
If you email me I can explain it better. allenlg53@yahoo.com
it works .. thnaks. but when pressing search button while text area is empry outputing all information in mysql. how to fix this problem? i want show this message "please fill area" when text area is empty and button pressed. thanks
Im trying to add labels about the php output... in my case im outputting movie titles and actor’s names.. any suggestions ?
Hi when i press the the seach button nothing happens, have you any idea what i have done wrong, or how i could fix this? thanks
its good but my concern is that i am making a real estate website in this i have a search form that have property-location property-type and property id so how to search it from php search operation. i want to get in output property_location propertytype and id.... plz answer me
Great Video! Thanks
thank you very much.
worked fine !!!!
can you please make a tutorial how to update information in the db ?
i can insert and delet in the db but cant update.
yah i would like that i subbed to wait and see
UPDATE function.
very good tutorial, thanks.
Nice big font. It is easy to watch on iPad.
Instead of using a MySQL database is there a way to use a Microsoft access database instead (just for a local website)
Thanks , This was exactly the tutorial I am looking for .
I have question : How can I search between 2 tables ? please help me
Hey dude, Nice tutorial, Any Idea how I can code up my search bar to allow more than 1 input? For example, using your data - if the user was to type "pip smith" both first and lastname.. I want mine to be able to show 2 different results, At the minute when I type a space into the search bar and submit it, it just echo's out no data at all, it doesn't recognise the space, I hope you can help, Thanks! :)
Can you search the records without clicked on the button. I mean keypress. Just type anything into the fields and record will display.. Can you help me in this?
No problem dude! glad to help :)
Sorry Joe i wasn't the first thank you for the tuto
which software are you using..?
If I have a local Database and not one created in phpmyadmin , what should I put after mysql_connect?
Let's say my db is in "C:/Apache2.2/htdocs/MTDB/App_Data and it is called dbo.Table.sql
Where do I get what I should put in those three arguements in mysql_connect?
If I never set my password, can I leave it empty? Thank you very much!
May you create a video of using php to serach for data in a json file?
lovely job, so how do I use this to enter the database of my company software, whitch is basically sql
Is this support images, videos search?
Good tutorial. I like it.
How do you display multiple records with the same name ? I mean I've tried also your way but I still it doesn't display multiple results. Maybe because of some coding in java which is included in my code?
Thanks for the Tutorial bro. Big Help! (y)
I've been quoted 8 hrs to implement a PHP Search function on a site I'm having built , seems like you knocked it out in a fraction of the time... would you say my developer is inflating their numbers a bit?
I used pdo method to connect ? how do i replace the mysqlquery ?