search bar using Php and MySQL

great video, helped alot, thank you so much

Thank you very good

Your life saver thanks a lot

The background ncs song hits different remind me of 2016 2015

you saved my life
thankyou so much 🙏

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

hello friend, 500 error pops up

It Worked! Thanks

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

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

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

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

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

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

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?

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

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

PDO does not work for me

really nice and easy,ty!
you saved my back

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

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

It work but only select one item form the search

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

How can I add pictures to my output?

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?

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

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

Party!

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

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

thank u very much

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

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

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

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

thank you

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

Simple and straight to the point..

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!

hero

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?

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.

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

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

Excellent! Thanks.

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

Thank U Soooo

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

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