In this tutorial I will show you how to connect to your MySQL server and retrieve information to insert into your dropdown menu. You will also learn a couple of …
source
Get dropdown items from mysql database
In this tutorial I will show you how to connect to your MySQL server and retrieve information to insert into your dropdown menu. You will also learn a couple of …
source
35 responses to “Get dropdown items from mysql database”
thanx alot after viewing so many videos this video helped me a lot in the last moment…tnx alot
first show how the value of drop down is inserted inside tha database…?
Hi.. thank you for the amazing tutorial. I am a beginner to PHP SQL and I have a question at 5.31 sec close function. If the entire code is inline, then the close function closes the database as soon as the database is connected.. I am confused how the SELECT query processes if the connection is closed. Kindly clarify.
Nice Tutorial. Helped me sort out my coding issue. Keep making these videos – many of us appreciate it! Well done.
i like it . simple and easy to understand.
I need help. All I get is a small box and an arrow identifying the dropbox but no data
Thank you for your tutorial, but if i want to save selected item to session, how can i do this?
You are amazing tutorial I saw today all day and only now thought to thank solution
TYYYYYYYYYYYYYY sorry for my english
Man great video
Thank u very much it was very helpful
All the best for U 🙂
Great video. Stop complaining about the bird you ungrateful bastards.
hi there, do you have a tip how to UPDate/Edit dropdown value. i mean if you enter a record to edit , then it need to load the saved value from DB,
OMG you guys are right…. PLS LET THE FOCKING BIRD SHUT UP!!!
HD bird tjirping. PLEASE RE-RECORD
MURDER YOUR BIRD PLZ!! but thanks for the tutorial.
Two points – 1.) MYSQL_CONNECT is depricated meaning it won't be around much longer. You should teach more current methods. 2.) That bird is annoying as shit. Put a blanket over its cage before you make a video.
Great another bird owner SMH
Jesus christ what the fuck is that squeaking sound.
Thanks for your help
I have used your tutorial and noticed that it could do with being updated due to mysqli. Is there any chance, without the bird? 🙂
Can't be doing with noisy birds!
Thanks for the help dude. The only criticism I have is that darn bird.
ER MER GURD he's annoying haha
Thanks again 🙂
Hi, thanks for such an interesting tutorial.
I would like to know, who can I select a value from the database in an <select> and also grab the another value from the same row in an Text box.
Example: I want to be able to select a name from a Combobox from my DB, and to have the email in and textbox.
Could you help me out?
this bird is annoying and plz zoom your videos next time.
Excellent tutorial!
I could not take the bird chirping in the background and the screen was very difficult to see.
Nice tutorial , but da*n kill that bird
Im sorry but this is just horrible. It makes no sense to create all those functions especially when you are creating a tutorial for beginners. Also why would you make a whole php connection file and not actually CONNECT to the data base!
Finally your recording volume is at like 0.1 and you have some bird/animal chirping away through the entire video!
How can i get the dropdown to search for e.g keywords from another table in the same database. I already have a working search box but im having trouble getting my dropdown to search. If you could help that would be great thanks.
Cool Tutorial ! Can you expand on this method in lesson 2 and show us how to make a floating drop down MySQL menu ?
nice tutorial, however, instead of;
echo '<option value = "' . $record['item'] . '">' . $record['item'] . ' "</option>";
my application needed
echo '<option value = "' . $record['id'] . '">' . $record['item'] . ' "</option>";
I don't store values for foreign keys, I store their record Ids. That way, if a value changes I don't have to go to all my tables that store that value and change them since the Id remains the same.
Except of course for BI tables, in which case the value is appropriate due to the historic nature of BI.
Great vid!!!
hey, do u have a tutorial like this that have a better resolution cause i can't see it? or codes? thank u :* .. good tutorial , nice voice 🙂
This was excellent. So clear!
Fantastic tutorial. I've been looking for a no-BS tutorial on this type of function for a few days now. Thanks!
Sorry …changed to 720p…lol my bad
This tutorial is great but ….but video resolution is terrible
I never normally leave comments but I just wanted to say thank you for this tutorial, helped me with my work, really appreciate it!