PHP Search Box Tutorial - Filter Data in HTML Table Using PHP & MySQL Database

[@celestusnyalugwe7943]

wonderful video which was so easy to follow through. Thank you for including an explanation as you went along, really helps one to understand what you are doing , rather than just following blindly along.💪🏾💪🏾

[@betwixtandbetweentechnolog5917]

This is probably the best tutorial I've ever seen on building search box! Absolutely amazing. I used it on my project, added some necessary changes and it worked! Thank you man! Keep doing what you do! Good luck! One day this channel will probanly reach 100k subscribers ;)

[@SenaidBacinovic]

You're very welcome!

[@zareenremendies]

Great sir👍👍👍

[@zahed1696]

wow thank you bro i needed this so much

[@alpachino468]

Much appreciated, Tovarishch!

[@jorgeordonez7747]

Was great help, thanks a lot!

[@lisykim3631]

i watch till the end to support you

[@SenaidBacinovic]

Appreciate you, thank you.

[@ramseselgrande1555]

Gracias por compartir conocimiento...

[@jcmadetaydon]

Hello sir do you have any search videos for the comments system you have made?

[@JinTwisT]

Sve i jedan ti je video uživancija za gledati. Svaka čast. Dal ćeš se držati samo PHP-a ili ćeš krenuti i na druge programske jezike?

[@SenaidBacinovic]

Hvala puno! Vjerovatno ću se držati samo web programiranja i možda budem imao Java tutoriale, ali to ćemo još vidjeti.

[@gloriabukachi1]

Thank you very much, very good explanation

[@SenaidBacinovic]

My pleasure, thank you!

[@tarekhusam]

i love you man ! nice work

[@SenaidBacinovic]

thank you :)

[@gloriyapacheko]

Hi. It is very well explained.

[@SenaidBacinovic]

thank you :)

[@ChunTix713]

Good work. Thank you

[@SenaidBacinovic]

thank you :)

[@janeonielperez6546]

Thank you so much

[@SenaidBacinovic]

My pleasure, thank you!

[@AtomTCP]

Bravo bosanac

[@SenaidBacinovic]

Hvala!

[@AtomTCP]

@@SenaidBacinovic Nema na čemu kolega!

[@prabeshdebbarma7674]

Good job coding passive in.... can you provide video for multiple keyword search box to display data like youtube, dailymotion search box I am waiting for your next tutorial have a nice day bro...

[@SenaidBacinovic]

PRABESH DEBBARMA Sure. I will make it for you. However, at the moment you can find a video tutorial on my channel about jQuery AutoComplete for PHP Search Box, which is similar on how KZbin search box is working. :)

[@prabeshdebbarma7674]

Thanx ....for reply :)

[@SenaidBacinovic]

Thank you so much! Appreciate the support. :)

[@sonoftroy8572]

Thanks for the content, this really helps me a lot

[@SenaidBacinovic]

Awesome, glad I could help. :)

[@Tracks777]

Great! Keep it up!

[@SenaidBacinovic]

MisterBassBoost thank you :)

[@VFRodriguez]

Good tutorial. thanks. I tried to visit you site in order to download the source code but I got an error message.

[@bushwhack12]

Hi, the ':' next to to the word 'host' is giving me an error. I wonder why since yours is working @ 11:30 in your video. im using sublime text 3 to follow this tutorial. Can you help? Thanks man. this is the error im getting. Parse error: syntax error, unexpected ':', expecting ',' or ')' in C:\xampp\htdocs\projects\tutorials\PHP Search Engine\search.php on line 3

[@SenaidBacinovic]

Those ":" are just shown by my PHPStorm so that it's easier for me, but you actually don't need those. The correct line of the code would be: $connection = new mysqli("localhost", "root", "", "phpSearch");

[@bushwhack12]

Oh ok, total newbie here still learning the ropes . Hey thanks man.

[@SenaidBacinovic]

We all start at the beginning, keep it up!

[@malithlakmal7971]

thank you! :-)

[@rsartandmedia]

how to create share button in php from which we can share our content to whatsapp and facebook?

[@abhidita143]

yes and thank you! :-)

[@SenaidBacinovic]

Dee Boxer Amazing, thank you :)

[@fjb46]

Hi Senaid! in the Dutch language - as in French - we use many special characters such as: é, è, à, ç, ë. When reading and displaying my data, the pagination stops every time a record has to be shown that contains such a special character! How can I bypass this? I could replace the special characters with characters without accent, but then the spelling and pronunciation is wrong! Greetings, and thanks you already for all the examples I eagerly devour.

[@chrismakri8474]

This is really good, is there a way to show more than one column?

[@desirocker9099]

I would have come so far if it wasn't for you, Sir. Thank you very much.

[@jasonfrazee5508]

Is there a way to incorporate this into a wordpress theme? I have been learning alot of stuff lately and have some questions haha

[@jasonfrazee5508]

I have made a blank wordpress theme and am struggling to figure out how to link phpmyadmin database to it. Your video is the closest tutorial I can find to what i am trying to do...

[@elisantos1156]

How to do search with function type function search () instead of via /search.php, in this case using model and controller

[@SenaidBacinovic]

Are you using some framework or ?

[@elisantos1156]

Hi, I'm using a simple MVC structure, other than CodeIgniter and others

[@SenaidBacinovic]

I am not an expert in CodeIgniter, also I never worked with it, but I did some research for you and came up with this answer: stackoverflow.com/questions/8821844/how-to-create-mvc-for-search-in-codeigniter Hope it will help you...

[@elisantos1156]

Our, helped a lot, but so thank you very much for offering me this information, which added a lot in my project, Thank you very much lol

[@FaTaLDRAG0NZ]

Hey, I've done all what you've said but I keep getting the 'Your search query doesn't match' at the top of the screen permanently without changing. Any ideas what part of my code may not be workin. I think it may be line 10/11. I had to remove the word query: before the select statement. Does this matter? Cheers man!

[@SenaidBacinovic]

Yes, you need to remove it from all places, because that is not supposed to be there, it's just PHPStorm feature to help coder with parameters needs for that specific function.

[@sha8639]

why it does not work for me. no error but no output. can you help me I have been stuck a week ago for this coding search.

[@SenaidBacinovic]

Can you show me the code?

[@arunagrawal6270]

Dear Sir awesome tutorial. Can you please make a video tutorial with source code how to search database on matching 2 inputs for example id and name in php? Thanking you Sir

[@techcanyon411]

I would advise you to join the Patreon community as a developer so peoples can cherish your hard work.

[@nathannelson5645]

Nice video! Can you explain to me how we can get multiple info out of search, say a first and last name?

[@SenaidBacinovic]

Thank you. As you can see in our SQL query, we are asking only for firstName (SELECT firstName ....), and if you want to ask for some others, you just need to specify the name of those columns. For example: SELECT firstName, lastName, email FROM ...

[@nathannelson5645]

Oh, ok, so you can put them in an array I take it? Or is that field an array already? Very new to PHP, so thank you for your help!

[@SenaidBacinovic]

At the moment you're getting firstName from database inside while loop with $data['firstName'], and you can do it the same way for other columns too. For example for lastName: $data['lastName'];

[@nathannelson5645]

Ok, I'm almost understanding this, right now what I did was just copied this and used it 6 times in the code so I could call different things back for the database $sql = $connection->query("SELECT distributor_id FROM searchID WHERE $column LIKE '%$q%' "); if ($sql->num_rows > 0) { while ($data = $sql->fetch_array()) echo $data['distributor_id'] . ""; } else echo "Error: Your search query doesn't match any data!"; wondering if their is a way to put all the information in an array? Would you be kind enough to give me that info. This is helping me out so much and I will share your channel with all my coding buddies as well! Thank you for the help!

[@SenaidBacinovic]

Let me try. Let's say that from the video above we want to print email, firstName and lastName for each customer, the code for it will be: $sql = $connection->query("SELECT firstName, lastName, email FROM users WHERE $column LIKE '%$q%'"); if ($sql->num_rows > 0) { while ($data = $sql->fetch_array()) echo $data['firstName'] . " " . $data['lastName'] . " " . $data['email'] . " "; } else echo "Your search query doesn't match any data!"; Get it now? Btw, thank you for sharing it with your friends!

[@samikshyamishra8039]

Hi Senaid Thank you for the video.. I want to know how to execute the search query for showing multiple infos in output as table. Also I want the user to see the output table in another page,not in same search page. Waiting for your reply.

[@SenaidBacinovic]

Thank you. What you want is very simple. To display multiple pieces of information on the table, just select them in the SQL query and display through while loop, and to show it in another page just change the action of the form.

[@ahmedatya6226]

Thank you For the Video but when i press button it bring me all names without search

[@mithungupta9897]

i want to make classified website but i dont know how to make searchbox to get data from category and display please help

[@SenaidBacinovic]

Just watch the video above and see how I filtered the data. The same way you will filter data from different categories.

[@PriyaSingh-lz4ip]

How we make it came in random table raw?

[@Happystoreup]

Thank you so much! I will try! anyway...............you're handsome!

[@SenaidBacinovic]

Thank you :)

[@BucurIonNiculae]

5:00

[@niketanpatil5594]

Parse error: syntax error, unexpected ':' in C:\xampp\htdocs\Sear\test.php on line 5 can u please solve this..thanks anyways

[@SenaidBacinovic]

Copy/paste that line here...

[@niketanpatil5594]

@@SenaidBacinovic $connection = new mysqli(host: "localhost", username: "root", passwd: "", dbname: "search");

[@niketanpatil5594]

@@SenaidBacinovic can u help?

[@SenaidBacinovic]

Write line like this: $connection = new mysqli('localhost', 'root', '', 'search');

[@niketanpatil5594]

@@SenaidBacinovic Thanks

[@behappey8494]

thanks for you sir can please do search with filter but filter countery like in linkedin

[@SalmanMemon_Sam]

can you plz post some thing about security in php

[@SenaidBacinovic]

I already have two tutorials on how to protect your forms in PHP (you can find them on my channel). Is there anything specific that you would love to learn about?

[@SalmanMemon_Sam]

I want to build an online php editor for that i want all those commands which are dangerous for my server

[@SenaidBacinovic]

Here is the list of most popular dangerous PHP functions: apache_child_terminate, apache_setenv, define_syslog_variables, escapeshellarg, escapeshellcmd, eval, exec, fp, fput, ftp_connect, ftp_exec, ftp_get, ftp_login, ftp_nb_fput, ftp_put, ftp_raw, ftp_rawlist, highlight_file, ini_alter, ini_get_all, ini_restore, inject_code, mysql_pconnect, openlog, passthru, php_uname, phpAds_remoteInfo, phpAds_XmlRpc, phpAds_xmlrpcDecode, phpAds_xmlrpcEncode, popen, posix_getpwuid, posix_kill, posix_mkfifo, posix_setpgid, posix_setsid, posix_setuid, posix_setuid, posix_uname, proc_close, proc_get_status, proc_nice, proc_open, proc_terminate, shell_exec, syslog, system, xmlrpc_entity_decode

[@Prince-gn5fs]

Sir Can tell me how i can get image after search like. Firstname, lastname, email, image Please sir help me

[@bindumadhavi4059]

you are given for one table how can use three tables and run this query

[@SenaidBacinovic]

Check this tutorial: kzbin.info/www/bejne/hqKXYqyCfpiFrck

[@maciejwisniewski5026]

Nice tiger :)

[@SenaidBacinovic]

hehe, thx :)

[@aks6923]

download link not working?

[@SenaidBacinovic]

What is the problem?

[@venomoctopus4060]

thank you but we need multiple data filter

[@mrmoocow7666]

This didnt work out, u only get like 20 warnings and errors when u try to search for a name !

[@tinasheromeo6510]

Am building a customises search engine in education using LI not AI.

[@RickiFlashPro]

Your search query doesn't match any data!

[@SenaidBacinovic]

Ooook, and?

[@shahindomar3958]

Sir You tell me That how i can get image after search like. Firstname, lastname, email, image Please sir help me, Thank Sir