No video :(

search bar using Php and MySQL

Подписаться 9 тыс.

Просмотров 195 тыс.

50% 1

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.co...
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!

Опубликовано:

22 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 275

@khan.hassan 3 года назад

Simple and straight to the point..

@CodeFlix12 3 года назад

♥️♥️

@hortobagyiaxel7844 2 года назад

really nice and easy,ty! you saved my back

@codeflex5180 6 лет назад

Cool! Try in this! Love

@CodeFlix12 6 лет назад

Thanks!

@vusimbhamali1913 4 года назад

Brilliant tutorial. Here's a sub 👍👌

@CodeFlix12 4 года назад

Thank you so much🙌

@888glory9 2 года назад

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

@aliprogaming9240 Год назад

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

@mostafafighter Год назад

The background ncs song hits different remind me of 2016 2015

@raashidk352 2 года назад

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

@pie5233 4 года назад

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

@CodeFlix12 4 года назад

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 4 года назад

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 4 года назад

@@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 4 года назад

bro, help me please

@CodeFlix12 4 года назад

You should put it at the top

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

@sarthakkharade7112 9 месяцев назад

great video, helped alot, thank you so much

@CodeFlix12 9 месяцев назад

Glad you liked it

@abukmoha5092 3 года назад

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

@CodeFlix12 3 года назад

♥️♥️

@pranavan4055 Год назад

you saved my life thankyou so much 🙏

@masterv1676 2 года назад

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

@CodeFlix12 2 года назад

♥️♥️

@vulpine678 3 года назад

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 3 года назад

Yes you can

@theodore.katsuaki 6 месяцев назад

thank you

@CodeFlix12 6 месяцев назад

❤️❤️

@angelicamaemacaspac6212 3 года назад

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 3 года назад

Instead of = use like operator in sql query

@angelicamaemacaspac6212 3 года назад

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

@CodeFlix12 3 года назад

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

@hongcai4617 4 года назад

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 4 года назад

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

@alikaalbright1422 2 года назад

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

@vistemaj Год назад

Your life saver thanks a lot

@jeppie4984 4 года назад

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 4 года назад

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

@GamingMatt 4 года назад

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

@pulpo2882 4 месяца назад

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

@CodeFlix12 4 месяца назад

Just populate input field with those values.

@TeckTales 2 года назад

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

@pharoahstvrr3447 4 года назад

The music is unnecessary and voice over would be preferred.

@CodeFlix12 4 года назад

❤️❤️ thanks

@HariBo27307 2 года назад

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

@CodeFlix12 2 года назад

🤣 I agree

@shellyaka3539 3 года назад

Thanks you very much

@CodeFlix12 3 года назад

❤️❤️

@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

@mexavier3888 Год назад

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

@greenbranch8383 4 года назад

this is perfect

@CodeFlix12 4 года назад

❤️❤️

@hooonngda.0112 4 года назад

Great tutorial...

@CodeFlix12 4 года назад

Thank you❤️

@gkossatzgmxde 4 года назад

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 4 года назад

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

@nxson8727 2 года назад

PDO does not work for me

@m.abrarrubaiyatislam3431 Год назад

It Worked! Thanks

@FunkyColonoCat 3 года назад

Excellent! Thanks.

@CodeFlix12 3 года назад

♥️♥️

@alikaalbright1422 2 года назад

It work but only select one item form the search

@fanjarwijaksono552 2 года назад

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?

@patriciahodos215 4 года назад

It works, thank you! :)

@CodeFlix12 4 года назад

Yes🙌🙌

@OmarkhaledYG 2 года назад

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 2 года назад

Check table name

@OmarkhaledYG 2 года назад

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

@CodeFlix12 2 года назад

❤️❤️❤️

@cbrown3936 Год назад

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

@nichel773 3 года назад

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 3 года назад

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

@B_Hghlights1 2 года назад

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

@CodeFlix12 2 года назад

What is the scale of the site you are thinking

@Starix-jp2gi 3 года назад

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 3 года назад

Yes it does the same

@zy_simpamba8298 3 года назад

hero

@CodeFlix12 3 года назад

♥️♥️

@seneladovcata7776 3 года назад

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

@CodeFlix12 3 года назад

Maybe you might have hard coded column names

@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 :(

@khanshayena2401 5 лет назад

tysm your code is really works

@CodeFlix12 5 лет назад

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

@pie5233 4 года назад

Bro, can you help me?

@pie5233 4 года назад

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

@CodeFlix12 4 года назад

Can you tell me the error sir

@pie5233 4 года назад

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

@danylayton7582 2 года назад

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

@andresgallardo5225 3 года назад

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 3 года назад

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

@TheEnthraller 3 года назад

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

@CodeFlix12 3 года назад

🙌

@EyBossPusi 6 месяцев назад

@TheEnthraller how bout sanitize input?

@execute7836 3 года назад

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

@CodeFlix12 3 года назад

Check if the sql query is working

@greenbranch8383 4 года назад

keep going

@CodeFlix12 4 года назад

❤️❤️

@joaopedro-cs1zv 2 года назад

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 6 месяцев назад

strlen like conversion i forgot

@leeonsr 2 года назад

How can I add pictures to my output?

@nordalila7164 3 года назад

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 3 года назад

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 3 года назад

Im getting the same error. How do i check?

@CodeFlix12 3 года назад

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

@animegeeks1835 4 года назад

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 4 года назад

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

@abhson 4 года назад

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 4 года назад

Try my ajax search and retrieval video

@abhson 4 года назад

@@CodeFlix12 ok i will thnks

@user-wl1zo8yz8e 5 месяцев назад

veryyy niceee!

@CodeFlix12 5 месяцев назад

❤️❤️

@lavanyapushpakar1648 3 года назад

When i put the url i get Error 404 not found

@CodeFlix12 3 года назад

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

@lavanyapushpakar1648 3 года назад

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

@CodeFlix12 3 года назад

Please email me

@lavanyapushpakar1648 3 года назад

@@CodeFlix12 I sent you an email please check it

@CodeFlix12 3 года назад

Sure

@wastedart1794 2 года назад

Party!

@CodeFlix12 2 года назад

❤️❤️

@ishikasharma4045 4 года назад

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 4 года назад

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

@sarmanyabhiwaniwala910 3 года назад

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 3 года назад

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

@applepeh1582 4 года назад

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

@CodeFlix12 4 года назад

Check is query returning data.?

@markmark5441 3 года назад

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

@CodeFlix12 3 года назад

I have a video on that

@chrisguise6428 3 года назад

@@CodeFlix12 whats the video called?

@CodeFlix12 3 года назад

It is this video

@rangikumar9789 2 года назад

thank u very much

@CodeFlix12 2 года назад

♥️♥️

@taariikhyahan7362 2 месяца назад

can you please tell me what do you mean PDO

@CodeFlix12 2 месяца назад

It is database object

@weeseong1 4 года назад

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 4 года назад

You have to change the query

@weeseong1 4 года назад

@@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 4 года назад

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

@frankkwamehammond945 4 года назад

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 4 года назад

Just give   and append a comma

@abukarieinus4745 4 года назад

Bro just used div and some bootstrap classes to beautify it

@CodeFlix12 4 года назад

Great sir

@frankkwamehammond945 4 года назад

@@abukarieinus4745 Thanks bro

@anikettejpal1599 3 года назад

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

@CodeFlix12 3 года назад

What's error?

@toxicgem6845 3 года назад

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

@CodeFlix12 3 года назад

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

@nadirahakbar5466 3 года назад

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

@CodeFlix12 3 года назад

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

@hazirahmusa2840 4 года назад

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

@hazirahmusa2840 4 года назад

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

@CodeFlix12 4 года назад

Yep

@thishmadasanayaka8155 4 года назад

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

@CodeFlix12 4 года назад

Can you explain me more on it

@lavanyapushpakar1648 3 года назад

Hey what is dbname

@CodeFlix12 3 года назад

CodeFlix

@lavanyapushpakar1648 3 года назад

@@CodeFlix12 Hey check your Instagram

@Peeeacee 5 лет назад

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

@CodeFlix12 5 лет назад

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 5 лет назад

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

@CodeFlix12 5 лет назад

Okay great 🙌

@koubiack7846 4 года назад

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 4 года назад

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

@koubiack7846 4 года назад

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

@koubiack7846 4 года назад

@@CodeFlix12In the ? in the table ?

@koubiack7846 4 года назад

sorry to bother you i found the technique

@CodeFlix12 4 года назад

Ok sure🙌🙌

@ValShiPhp Год назад

hello friend, 500 error pops up

@ValShiPhp Год назад

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

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

@toxicgem6845 3 года назад

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 3 года назад

Sure

@devanshukhachane5659 4 года назад

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 4 года назад

❤️❤️

@anthonyaruta7140 4 года назад

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

@CodeFlix12 4 года назад

You mean just like in an e-commerce website?

@hazirahmusa2840 4 года назад

@@CodeFlix12 yes

@CodeFlix12 4 года назад

I have a video on that

@baraaalhamedi6670 3 года назад

Thank U Soooo

@CodeFlix12 3 года назад

❤️❤️

@VevoZeitoun 3 года назад

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 3 года назад

Just return id also when you search name

@garrysingh11 3 года назад

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

@CodeFlix12 3 года назад

♥️♥️

@VevoZeitoun 3 года назад

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

@CodeFlix12 3 года назад

🙌🙌

@rajshinde2811 4 года назад

thank u bro

@CodeFlix12 4 года назад

Pleasure!🙌🙌

@rajshinde2811 4 года назад

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 4 года назад

By using session, new video on that coming up soon

@rajshinde2811 4 года назад

@@CodeFlix12 waiting for it

@CodeFlix12 4 года назад

Thanks man

@mrrahin10 4 года назад

bro this does not work are you there ?

@CodeFlix12 4 года назад

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

@mrrahin10 4 года назад

@@CodeFlix12 when i try your codes nothing happens brother

@CodeFlix12 4 года назад

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

@CodeFlix12 4 года назад

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 4 года назад

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

@kekoketa-tiendaderopademuj2905 4 года назад

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

@CodeFlix12 4 года назад

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

@sunitakailey2594 4 года назад

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

@CodeFlix12 4 года назад

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

@dfacooks9155 3 года назад

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

@CodeFlix12 3 года назад

Problem in query maybe

@nabhanmohtesham8090 4 года назад

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

@CodeFlix12 4 года назад

What error does it show?

@nabhanmohtesham8090 4 года назад

@@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 4 года назад

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

@nabhanmohtesham8090 4 года назад

@@CodeFlix12 no it is not getting

@nabhanmohtesham8090 4 года назад

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