search bar using Php and MySQL

Hello Guys,
This video is on how to search for anything from the MySQL database using the search bar and displaying the search results using a table.
SOURCE CODE : www.dropbox.com/s/42s8mse7ts3...
Link to my Previous Videos
CURL Function and Making HTTP and HTTPS requests to browser : • CURL Function and Maki...
Retrieving Data From Database Using PDO object in PHP : • Retrieving Data From D...
Upload a File to MySQL Database using PHP : • Upload a File to MySQL...
Insert data into MySQL Database using PHP : • Insert data into MySQL...
Login Form In PHP And MySQL : • Login Form In PHP And ...
NCS: Music Without Limitations
NCS Spotify: spoti.fi/NCS
Download / Stream: ncs.io/blank
Want to use this track? Please copy & paste this into your description:
Song: Jim Yosef - Link [NCS Release]
Music provided by NoCopyrightSounds.
Watch: • Jim Yosef - Link | Hou...
Download/Stream: ncs.io/LinkYO
Thanks For Watching!

[@hortobagyiaxel7844]

really nice and easy,ty!
you saved my back

[@Gmarkooo]

may i ask how do you make the search much easier like if you only use some letters not whole and it will still pop the information in the search menu. thnxx

[@raashidk352]

Bro, love the vid thanks so much for getting right to the point!! just a small question.. how can i show multiple records at once? it is only showing one record at a time?
if (isset($_POST["submit"])) {
$str = $_POST["search"];
$sth = $con->prepare("SELECT * FROM `users` WHERE profession = '$str'");
$sth->setFetchMode(PDO:: FETCH_OBJ);
$sth -> execute();
this is the code you have used, what should i change in the query??

[@fanjarwijaksono552]

hi, i get error on this
Parse error: syntax error, unexpected 'else' (T_ELSE) in C:\xampp\htdocs\CodeFlix.php on line 44. Can u pls help?

[@codeflex5180]

Cool! Try in this! Love

[@CodeFlix12]

Thanks!

[@andreeabalan6696]

Hi! Your video was really helpful but i was wondering how can i open in php a html page when i am searching something?

[@khan.hassan]

Simple and straight to the point..

[@CodeFlix12]

♥️♥️

[@aliprogaming9240]

thank you you helped a lot I am gonna save this video for one more time

[@sarmanyabhiwaniwala910]

I needed some help! I do not get any syntax errors but my code does not work online for some reason. It might have to do with using mysqli_connect instead of PDO. Do you have any idea how I can fix that?

[@CodeFlix12]

Is db connected? If so is the query returning data?

[@pranavan4055]

you saved my life
thankyou so much 🙏

[@abukmoha5092]

your The best ....your legend....thank u soo much ....much appreciated

[@CodeFlix12]

♥️♥️

[@m.abrarrubaiyatislam3431]

It Worked! Thanks

[@vusimbhamali1913]

Brilliant tutorial. Here's a sub 👍👌

[@CodeFlix12]

Thank you so much🙌

[@patriciahodos215]

It works, thank you! :)

[@CodeFlix12]

Yes🙌🙌

[@mexavier3888]

I have a problem displaying the error after I search sa data Uncaught Error: Cannot use object of type stdClass as array

[@sarthakkharade7112]

great video, helped alot, thank you so much

[@CodeFlix12]

Glad you liked it

[@TeckTales]

?? why is it POST method instead of GET especially for search

[@vistemaj]

Your life saver thanks a lot

[@leeonsr]

How can I add pictures to my output?

[@FunkyColonoCat]

Excellent! Thanks.

[@CodeFlix12]

♥️♥️

[@masterv1676]

thank you....it was very useful for my project

[@CodeFlix12]

♥️♥️

[@weeseong1]

HI, a quick question, is there a method where it can search the same thing but with less words? For example, in your vid, I'm searching for first name, but I'd like to search for it using the word 'first' only.

[@CodeFlix12]

You have to change the query

[@weeseong1]

@@CodeFlix12 i'd assume the query you meant is the table? problem is i have over thousands of entry and i don't think i can change them all

[@CodeFlix12]

No not the table, the sql query which is used to search

[@pie5233]

Today, when I have time I will try and tell you if it worked for me! Thank you very much

[@CodeFlix12]

Yes sir do tell me! It definitely works for others so surely it should for you! Let me know if you get stuck somewhere

[@CodeFlix12]

Yes sir do tell me! It definitely works for others so surely it should for you! Let me know if you get stuck somewhere

[@pie5233]

@@CodeFlix12 Hi, it seems that so far everything works (I'm still at the minute 5:09) I was wondering where should I put the host name mysql password and mysql password

[@pie5233]

bro, help me please

[@CodeFlix12]

You should put it at the top

[@greenbranch8383]

this is perfect

[@CodeFlix12]

❤️❤️

[@animegeeks1835]

hi can you tell me where to make database because I don't know about php I'm designing a website with HTML/CSS but I need a working searchbar like this in my site.

[@CodeFlix12]

Create one on phpmyadmin or download MySQL workbench and create one there

[@kimbalcita03]

INSERT INTO 'search'('id','Name','Description') VALUES (1,'first name','Description of first name');
INSERT INTO 'search'('id','Name','Description') VALUES (2,'second name','Description of second name');
INSERT INTO 'search'('id','Name','Description') VALUES (3,'third name','Description of third name');
I enter the same codes as yours but mine is not working. Can you please help me, I'm almost dying thinking what error I've done :(

[@joaopedro-cs1zv]

thanks a lot!!
how can i search for multiple keywords in more than one row at a time?
For example: the user is looking for a vet in Boston so he types "vet boston"
is there a way to search in the row where it specifies its a vet and in the row that specifies its in boston, separating the keywords and looking at multiple rows?

[@EyBossPusi]

strlen like conversion i forgot

[@andresgallardo5225]

Hello sir, I'm very new to php and mysql, but I'm concerned about how secure is this method.
I need to create a search bar that looks for 'asset_id' insted of title,( main) id, name or description, so I guess that I should write ("SELECT * FROM 'dbname' WHERE asset_id = '$str'"), right?
Thanks in advance for the tutorial.

[@CodeFlix12]

Yes right, and don't worry it is secure. To create more secure one try to create a stored procedure and run

[@TheEnthraller]

There's possibility of sql injection
So instead you can use bind_param

[@CodeFlix12]

🙌

[@EyBossPusi]

​@TheEnthraller how bout sanitize input?

[@user-wl1zo8yz8e]

veryyy niceee!

[@CodeFlix12]

❤️❤️

[@Starix-jp2gi]

any idea how to make the search bar chose a keyword from the name ? for example if the column name is "aaa bbb ccc ddd" and i search "aaa" it shows , bit lost

[@CodeFlix12]

Yes it does the same

[@hooonngda.0112]

Great tutorial...

[@CodeFlix12]

Thank you❤️

[@888glory9]

this isnt working it gives me a warning "Warning: Undefined property: stdClass::$Name" bruhhh🤦🏽

[@alikaalbright1422]

Why is the result not more than one even if it is using like

[@WasikaHausaNews]

Thank you very good

[@CodeFlix12]

Thank you too

[@B_Hghlights1]

Sir how can I use PHP and MYSQL only to build a site like Facebook what about the design of the site

[@CodeFlix12]

What is the scale of the site you are thinking

[@hongcai4617]

9/10 videos only explain searching one column, need some more dynamic data inputs instead of just one Name column,but still thank you for your work

[@CodeFlix12]

You just have to change your query likewise and you can get the same

[@nadirahakbar5466]

Hye Sir, can i know what can i do if i want the search function to show videos?

[@CodeFlix12]

You have to add tags in videos db table and search on tags

[@abhson]

What results will show if I will search half word like only first
...
.. I want to make search that will return relative words of alfabates.

[@CodeFlix12]

Try my ajax search and retrieval video

[@abhson]

@@CodeFlix12 ok i will thnks

[@rangikumar9789]

thank u very much

[@CodeFlix12]

♥️♥️

[@mostafafighter]

The background ncs song hits different remind me of 2016 2015

[@VevoZeitoun]

Hey, thanks for the video.
I have one question : I can search for a (unique) 'username' in my table but how can I get the corresponding id of this username please? Knowing that it is in the same row
Thanks!

[@CodeFlix12]

Just return id also when you search name

[@garrysingh11]

IN YOUR output Table Print the id as well
Name
Discription
ID
also do the same for the bottom line of code
ex.

[@CodeFlix12]

♥️♥️

[@VevoZeitoun]

@@CodeFlix12 I realised I forgot to answer you back, sorry for that and thanks for the help !

[@CodeFlix12]

🙌🙌

[@pulpo2882]

But what if I want to show search results in input fields
How I can do that?

[@CodeFlix12]

Just populate input field with those values.

[@jeppie4984]

typing in SQL database doesn't work
can you help me?
code:
INSERT INTO 'search'('id', 'Name', 'Description') VALUES (1,'first name','Description of first name');
INSERT INTO 'search'('id', 'Name', 'Description') VALUES (2,'second name','Description of second name');
INSERT INTO 'search'('id', 'Name', 'Description') VALUES (3,'third name','Description of third name');

[@CodeFlix12]

Try inserting manually in the table by right clicking on the table

[@GamingMatt]

try: _INSERT INTO `search`(`id`,`Name`,`Description`) VALUES (1,'first name', 'Description of first name')_ *you have done the wrong quotation marks/syntax*

[@OmarkhaledYG]

i did as i see in the video but that what i get every time i click submit :
Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found

[@CodeFlix12]

Check table name

[@OmarkhaledYG]

thank you very much
realy helpful
best tutorials ever
realy thank you

[@CodeFlix12]

❤️❤️❤️

[@gkossatzgmxde]

definitely does not work. I search and always get it does not exist - but the term does exist in DB. however, very few error checks in the code so I have no idea where the flaw could be

[@CodeFlix12]

Error might be in bringing the data from the db with the SQL, either the term is going wrong or the data coming is wrong

[@theodore.katsuaki]

thank you

[@CodeFlix12]

❤️❤️

[@seneladovcata7776]

i have more than 1 row in my table but doesn't show each row with the same column name

[@CodeFlix12]

Maybe you might have hard coded column names

[@zy_simpamba8298]

hero

[@CodeFlix12]

♥️♥️

[@cbrown3936]

Wow this works. How can I get the search results in another page?

[@greenbranch8383]

keep going

[@CodeFlix12]

❤️❤️

[@vulpine678]

Thanks for a great tutorial... but can i search it using id, email or address? for now i only can search using name only

[@CodeFlix12]

Yes you can

[@nxson8727]

PDO does not work for me

[@nordalila7164]

when i'm done...i want to test , then i put my data in database, but it still said name does not exist...why ?

[@CodeFlix12]

Check first in the db that the query you are using is returning any data or not. If not modify the query or db

[@fivegreatthings4416]

Im getting the same error.
How do i check?

[@CodeFlix12]

Run the query in phpmyadmin and see if the query returns any result

[@ishikasharma4045]

Uncaught Error: Call to undefined method mysqli_stmt::setFetchMode() in C:
Call to undefined method mysqli_stmt::setFetchMode() in C
I am using wamp and these are the errors showing

[@CodeFlix12]

You have an error in your query, either in results coming or the query itself

[@applepeh1582]

Hi, is no show the error but cannot come out the data

[@CodeFlix12]

Check is query returning data.?

[@angelicamaemacaspac6212]

it perfectly works. but can you help me to show multiple data in the table? because it shows one data match only. thank you!

[@CodeFlix12]

Instead of = use like operator in sql query

[@angelicamaemacaspac6212]

@@CodeFlix12 can you show me the whole query please? i keep on getting errors. this would be so helpful to me.

[@CodeFlix12]

What is the error? Because I don't have the query

[@thishmadasanayaka8155]

I need search bar with category list please can you give me the code for it please

[@CodeFlix12]

Can you explain me more on it

[@frankkwamehammond945]

i tried it and it works but the search results are compact to each other, how do we give adequate spacing between each column

[@CodeFlix12]

Just give   and append a comma

[@abukarieinus4745]

Bro just used div and some bootstrap classes
to beautify it

[@CodeFlix12]

Great sir

[@frankkwamehammond945]

@@abukarieinus4745 Thanks bro

[@nichel773]

im getting Error
SQL query:
INSERT INTO `search`(`id`, `Name`, `Description`) VALUES (1,'first name' , 'Description of first name')
MySQL said: Documentation
#1062 - Duplicate entry '1' for key 'PRIMARY'

[@CodeFlix12]

Try with Id 2 i.e (2, 'first name','desc')

[@khanshayena2401]

tysm your code is really works

[@CodeFlix12]

Yes! Other videos with such codes also do!! You can check them out also 🙌 thanks❤️

[@pie5233]

Bro, can you help me?

[@pie5233]

hard-questions.com/try/ggg.php it does not work

[@CodeFlix12]

Can you tell me the error sir

[@pie5233]

@@CodeFlix12 I'm going to bed, I'm going to let you know tomorrow. Thank you for your availability

[@toxicgem6845]

I want to make similar to search engine how to do that by using GET

[@CodeFlix12]

Just pass the search parameter in the get api and you will get results which you can show

[@danylayton7582]

hello,
I want to buy this tools with paypal, can I pay for it with paypal?

[@koubiack7846]

Hello your code works just fine but it shows me only the first result of the sql command and i want all of them can you help me ?

[@CodeFlix12]

Yes select all that match and run a simple loop over the results and it should work

[@koubiack7846]

@@CodeFlix12And how would you do that ? i tried to put a while($row = $sth->fetch()) and i gave me errors

[@koubiack7846]

@@CodeFlix12In the ? in the table ?

[@koubiack7846]

sorry to bother you i found the technique

[@CodeFlix12]

Ok sure🙌🙌

[@Peeeacee]

I'm not able to run php file. It says access forbidden!

[@CodeFlix12]

No it's not possible! You can email me and I will send you the PHP file. Or try to follow the steps from from the video to code. Thanks

[@Peeeacee]

@@CodeFlix12 Okay Thanks. It worked! Issue was with my XAMPP 😅

[@CodeFlix12]

Okay great 🙌

[@anthonyaruta7140]

How to display images along with product id using search query ?

[@CodeFlix12]

You mean just like in an e-commerce website?

[@hazirahmusa2840]

@@CodeFlix12 yes

[@CodeFlix12]

I have a video on that

[@execute7836]

it doesnt show what ive searched. even its in the table

[@CodeFlix12]

Check if the sql query is working

[@JaspreetSingh-gv9wc]

Hey bro! really educational video. But I don't know why I'm getting this error. Can you please help me out in it:
Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''search' WHERE Name = 'first name'' at line 1 in C:\xampp\htdocs\practice_2\index.php:27 Stack trace: #0 C:\xampp\htdocs\practice_2\index.php(27): PDOStatement->execute() #1 {main} thrown in C:\xampp\htdocs\practice_2\index.php on line 27

[@katongochilufya3802]

type using backtick quotes on `search` is different from 'search'

[@alikaalbright1422]

It work but only select one item form the search

[@taariikhyahan7362]

can you please tell me what do you mean PDO

[@CodeFlix12]

It is database object

[@baraaalhamedi6670]

Thank U Soooo

[@CodeFlix12]

❤️❤️

[@anikettejpal1599]

Hi, i followed exactly however mine still doesnt work :(

[@CodeFlix12]

What's error?

[@HariBo27307]

What the hell is the background music? Is this 2010 :DD Thanks for vid tho

[@CodeFlix12]

🤣 I agree

[@hazirahmusa2840]

can you make a video for search bar using html Php where it shows suggestion and also connected to Mysql

[@hazirahmusa2840]

also filter sorting alphabetical order, numeric price high to low and so on?

[@CodeFlix12]

Yep

[@Suiren1230]

hello is this object oriented?

[@CodeFlix12]

No its not, but you always can convert :)

[@rajshinde2811]

thank u bro

[@CodeFlix12]

Pleasure!🙌🙌

[@rajshinde2811]

how we can logout from the admin form perfectly and when we click on backword button of browser it goes into again in the admin without asking the password or username

[@CodeFlix12]

By using session, new video on that coming up soon

[@rajshinde2811]

@@CodeFlix12 waiting for it

[@CodeFlix12]

Thanks man

[@markmark5441]

How to show all the all the result? Not only the first one? Please help me

[@CodeFlix12]

I have a video on that

[@chrisguise6428]

@@CodeFlix12 whats the video called?

[@CodeFlix12]

It is this video

[@lavanyapushpakar1648]

When i put the url i get Error 404 not found

[@CodeFlix12]

You might be putting wrong url, use naming convention like me

[@lavanyapushpakar1648]

@@CodeFlix12 Hey I sent you messages on instagram
Please check your instagram

[@CodeFlix12]

Please email me

[@lavanyapushpakar1648]

@@CodeFlix12 I sent you an email please check it

[@CodeFlix12]

Sure

[@pharoahstvrr3447]

The music is unnecessary and voice over would be preferred.

[@CodeFlix12]

❤️❤️ thanks

[@wastedart1794]

Party!

[@CodeFlix12]

❤️❤️

[@lavanyapushpakar1648]

Hey what is dbname

[@CodeFlix12]

CodeFlix

[@lavanyapushpakar1648]

@@CodeFlix12 Hey check your Instagram

[@nabhanmohtesham8090]

php code not workingwhen i run it with boootstrap framework..need help!!

[@CodeFlix12]

What error does it show?

[@nabhanmohtesham8090]

@@CodeFlix12 i have solved that..but now i want to get multiple rows which matches the search..hut i am getting only the first match.
Any idea on whether to apply foreach loop or any other?

[@CodeFlix12]

It will get you multiple rows sir, fill multiple data in it

[@nabhanmohtesham8090]

@@CodeFlix12 no it is not getting

[@nabhanmohtesham8090]

@@CodeFlix12 i'll mail you the code; can u look in to it?

[@toxicgem6845]

how to do this thing in 000wehostapp.com can you make video for how to do this search like from 000webhostap.com data manager.

[@CodeFlix12]

Sure

[@kekoketa-tiendaderopademuj2905]

i wanna cry, it doesn´t work. dont show the results

[@CodeFlix12]

Is it throwing any kindof error or something? Because That's not possible because it's working perfectly

[@sunitakailey2594]

@@CodeFlix12 yeah it doesn't work for me and no error show. why?

[@CodeFlix12]

Does the table have data? Did you search for correct results

[@dfacooks9155]

Same thing happening to me. How did you fix this?

[@CodeFlix12]

Problem in query maybe

[@ValShiPhp]

hello friend, 500 error pops up

[@ValShiPhp]

oh, figured it out, wrong db name))🤪

[@devanshukhachane5659]

thank u for giving this - www.dropbox.com/s/42s8mse7ts32hys/index.php?dl=0
love u bro
thank u
u are the best php youtuber
roses are red
sky blises blue
you are the best
all love is for u

[@CodeFlix12]

❤️❤️

[@madhusudanvratesh4272]

hey can you make it same for autocomplete search...thank you for this also..it worked!!^_^

[@CodeFlix12]

❤️❤️

[@mrrahin10]

bro this does not work are you there ?

[@CodeFlix12]

Yes brother I am here for your help!! What error does it show?

[@mrrahin10]

@@CodeFlix12 when i try your codes nothing happens brother

[@CodeFlix12]

Any error thrown in the console or something? If not, I guess the SQL you are implementing is not working as per requirements

[@CodeFlix12]

Did you follow my exact same code? I tried it right now and it's working for me brother! Let me know if I can help

[@mrrahin10]

@@CodeFlix12 i send you tommorow i go sleep now its 00:27 here NL

[@kazimkaraboga9264]

Errroooorrrr 👎👎👎

[@CodeFlix12]

Which part? Or what error?

[@omerfarukkaraboga8974]

👎👎👎👎👎👎👎👎👎👎👎👎

[@CodeFlix12]

❤️

[@CodeFlix12]

That's just how I work

[@omerfarukkaraboga8974]

@@CodeFlix12 Your expression is very complicated.

[@CodeFlix12]

If you don't understand it doesn't mean it's complicated

[@omerfarukkaraboga8974]

@@CodeFlix12 okAy

[@shellyaka3539]

Thanks you very much

[@CodeFlix12]

❤️❤️

[@harsha_karambaru]

thank you

[@CodeFlix12]

♥️♥️