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!

[@zahed1696]

wow thank you bro i needed this so much

[@zareenremendies]

Great sir👍👍👍

[@alpachino468]

Much appreciated, Tovarishch!

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

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

[@tarekhusam]

i love you man ! nice work

[@SenaidBacinovic]

thank you :)

[@malithlakmal7971]

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.

[@gloriyapacheko]

Hi. It is very well explained.

[@SenaidBacinovic]

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.

[@rsartandmedia]

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

[@AtomTCP]

Bravo bosanac

[@SenaidBacinovic]

Hvala!

[@AtomTCP]

@@SenaidBacinovic Nema na čemu kolega!

[@gamerunnerstaydon]

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

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

[@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 RUclips search box is working. :)

[@prabeshdebbarma7674]

Thanx ....for reply :)

[@SenaidBacinovic]

Thank you so much! Appreciate the support. :)

[@ChunTix713]

Good work. Thank you

[@SenaidBacinovic]

thank you :)

[@janeonielperez6546]

Thank you so much

[@SenaidBacinovic]

My pleasure, thank you!

[@sonoftroy8572]

Thanks for the content, this really helps me a lot

[@SenaidBacinovic]

Awesome, glad I could help. :)

[@desirocker9099]

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

[@techcanyon411]

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

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

[@ahmedatya6226]

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

[@chrismakri8474]

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

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

[@Tracks777]

Great! Keep it up!

[@SenaidBacinovic]

MisterBassBoost thank you :)

[@shahindomar3958]

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

[@abhidita143]

yes and thank you! :-)

[@SenaidBacinovic]

Dee Boxer Amazing, thank you :)

[@behappey8494]

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

[@maciejwisniewski5026]

Nice tiger :)

[@SenaidBacinovic]

hehe, thx :)

[@Prince-gn5fs]

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

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

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

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

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

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

[@Happystoreup]

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

[@SenaidBacinovic]

Thank you :)

[@PriyaSingh-lz4ip]

How we make it came in random table raw?

[@tinasheromeo6510]

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

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

[@venomoctopus4060]

thank you but we need multiple data filter

[@bindumadhavi4059]

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

[@SenaidBacinovic]

Check this tutorial: ruclips.net/video/Pq41yLI3Rwg/видео.html

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

[@BucurIonNiculae]

5:00

[@mrmoocow7666]

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

[@aks6923]

download link not working?

[@SenaidBacinovic]

What is the problem?

[@RickiFlashPro]

Your search query doesn't match any data!

[@SenaidBacinovic]

Ooook, and?