Populating Drop Down menus from Database

[@louisjennings5203]

I've been researching this for two days solid and this is the first time I found a clear and concise explanation of what to do and why. Thank you immensely!

[@OsukaX]

It worked, I was hitting my head against a wall before I've found this video. Thanks pal.

[@chandresh.t6405]

you are teaching very well sir thank you

[@senju31]

Much love from Jamaica. This is exactly what I was looking for and the video is very short. *Gracias*

[@pavanvspk8928]

bro... iam struggling with normal Mysql functions and wexed. But with this procedure...i am continuing with my work. Good Job from your side on posting this valuable video. TQ

[@kaivanDoshi]

A small tip if using bootstrap then dont' forget to add class="custom-select mr-sm-2" id="inlineFormCustomSelect" in the select tag

[@auroraseco5746]

a simple and practical example, thanks for the video

[@dbean2321]

Would love to see more videos on PHP PDO and advanced topics connecting Front and Backend

[@johnvins2884]

A real novice here---I get the gist of it but not how to run it? What editor are you using and are you on windows or linux? Save the file where and then when you say go to localhost to see the dropdown list, doesn't the db and this file need to be in the same directory? I'm on Centos 6.5, have LAMP and phpmyadmin. A good start for me to learn how to start a subquery when I click on a name in the list and to show a hyperlink to it for more information about the selection.

[@silviopontes9832]

It was very good! If we have another information in table; How to fill in another field with according to the data on option selection?

[@jacopieterse4674]

Nice, but how about in a relational db where you'd store the code of the Dept and not the name even though you'd like to display the name?

[@christiancolewan]

Great tutorial, can you explain how we can set the value of each line/option so that each line will have the same value as the text once submitted, because I got blank data whenever I press on submit.

[@phpBasics]

That's what I'm demonstrating in this video. If you're still having issues, you can hit me up on Skype: CoolEditz

[@christiancolewan]

@@phpBasics I appreciate your fast reply, I was able to pass the text into the option 'value' here's what I did. class="ass"id="xyz" onChange="window.location.href=this.value"> Actions

[@kumaratul484]

Can we populated it in sign up form which will comes from plugin. If possible then please let me know.

[@binoythomas2974]

Simple but powerful. Thanks a lot.

[@iamsarb_0017]

1 more question is - Is it compulsory to add data in column earlier so we can fetch& then again put it in another table is there any other way for this?

[@ZetaHook]

Good tutorial, but how do i get the array result to use it on another query? if I use this method the variable just select the last item show in the manu

[@jgonsuron]

I had the same problem. I solved it by creating multiple instances of the query - ie. $resultSet1, $resultSet2, $resultSet3, etc... it looks like once a query is run, the data generated can only be used in one while loop. I'm new and could be wrong, but this worked for me.

[@azeeomole2083]

Hello thank you for the tutorial. How can I give the dropdown a scroll bar?

[@dougbrown2035]

great video! I'm very new to PHP, is there a good way to take the selection and populate another page with the choice? for example if the selection is "Administration", the user selects it, clicks a submit button and it takes them to another page populated by sql data related to that selection.

[@phpBasics]

Yep, that's very doable in a variety of ways. Hit me up on Skype if you want to discuss it further - CoolEditz

[@dougbrown2035]

@@phpBasics I appreciate it - I'll reach out sometime this week.

[@snowfallztech]

Based on your idea it helped me complete my university project issue but codes works on different work criteria .This Code doesn't helped but idea helped me though Thanks Buddy

[@willemjacobusblom]

You're the best! Thanks so much

[@wamoka9381]

👏 👏 Nice tutorial. I have a question 🙋. How do you make a dropdown select from a table in a database and insert the selected value into another table?

[@phpBasics]

I have a tutorial on that coming up shortly! If you need some help, send me a message on Skype: CoolEditz

[@nitindhamale8789]

Nice one very good explanation

[@iTzBoosTerZx]

Great tutorial! But can you show how to do this with an external PHP file if this is possible in some way?

[@senju31]

External php file?

[@Random-xs8dp]

Big thank you bro

[@wixwixy3025]

Thanks for the tutorials - amazing stuff! Have used your search box tutorial as well as the dropdown one above to great success (on the same page) . I was wondering if it's possible to display more 'fields' from the database on a page, whilst using the dropdown as a trigger? thanks again!!

[@phpBasics]

You can, but you would need to introduce JQUERY or another AJAX wrapper since PHP doesn't update in real-time.

[@iamsarb_0017]

how to insert value from dropdown list to database(from php code to database just like different country name in list select it & stored in database )??

[@phpBasics]

You would give the select tag a name and process it like a normal form value.

[@KingVega73]

Great Video. I am searching a solution with a problem I am stuck in and maybe your code can help, but i need some more suggestion. Imagine to have a database with the classical fields State, Cities address, telephone, email, ecc... I wish that a the name of the state appears only once and add a dropdown with all the cities and when a city is selected, all the other fields showing the correct value. Thanks in advance.

[@phpBasics]

Greetings. You will need to download and import a database of cities and states. The rest could be done with JQUERY and AJAX. Things like this are typically done with .NET, PYTHON, or Ruby on Rail. However, I've done it with PHP and JQUERY and it does the job. If you have Skype, we may be able to work through it together.

[@KingVega73]

Hi. Thanks foer your fast answer. I have already my own db with all the fields i told you before, the problem is that while i have some basic knowledge of PHP my culture on JQUERY and AJAX is more than limited... Yes I have skype. If is not a problem for You, just send me your username there and i will contact You if it's not a problem.

[@phpBasics]

CoolEditz

[@nikilasandarage1066]

Thank you very much buddy!! This helped alot!! Explained precisely. Thanks again!

[@heartattackingirl]

thank u so much it was super easy and very helpful

[@oyekunleogunsina5266]

Very concise. Thanks a lot

[@abbasalibhai9815]

THANK YOU SO MUCH. You literally saved me! Thanks man!

[@christiannibarger4996]

You're a God. Thank you for this

[@cybreed]

simple and nice, thank you!

[@mayazoughbi6224]

its not taking from the database all content its only taking one from it what should i do? example from departments its taking accounting.

[@phpBasics]

Hi Maya, feel free to reach out on Skype: Cooleditz

[@johnattipoe7440]

How do you add the selected value to a new table

[@aliyegulduk5166]

Thank you very much!

[@kingking-qj5bp]

very simple, the best simple one ever.

[@MrMajorYT]

Hi, I was wandering if you could help me. I have set the session and connected to MySQL Database fine, The problems come when i place the while loop around the existing IF statement for my session. It seems to be picking the records up individually rather than as a group. Any Suggestions?

[@phpBasics]

Send your source code to [e-mail] and I'll take a look at it.

[@lakruwansenadheera]

how can we do it on android studio? please help

[@sofienmefteh993]

Thank you so much sir. You helped me . I was blocked for two days becose of this code.

[@sleepyScush11ie_]

is there a python way to do this ?

[@mohamudrashid4528]

what if you want to save the selected item in another table

[@phpBasics]

You name of the option passes through the form. Save it to whatever table you want after you process it.

[@neymat3257]

Thank you sir 👍

[@nurnaafizahmohammadrapi9285]

huhuuu, i am beginner i still get stuck doing this, i followed your step sudah..whats wrong with my code , can u help me

[@nurnaafizahmohammadrapi9285]

Warning: mysqli::mysqli(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO) in C:\Program Files (x86)\Ampps\www\Test111\Index.php on line 3 Warning: mysqli::query(): Couldn't fetch mysqli in C:\Program Files (x86)\Ampps\www\Test111\Index.php on line 5

[@nurnaafizahmohammadrapi9285]

[@phpBasics]

@@nurnaafizahmohammadrapi9285 You aren't connecting to the database correctly. The password for root is incorrect.

[@deepakkumarthangavel9574]

Thanks bro it helped me

[@kennyrobertson9027]

Hey, thank you, it works for me. Now I am trying to save dropdown data over multiple pages but are unable to keep the data when I go back to the previous page, please help.

[@phpBasics]

Send me a message on skype: CoolEditz

[@aymanmustafa2378]

dude, would be great if you provide your code so we can copy and paste it.

[@phpBasics]

The idea behind this channel is to teach people how to code, not provide free source code for lazy people.

[@cjellal]

How can i retain them after I press the submit button sir?

[@phpBasics]

I believe I have a video on that.

[@พิชาภพบุญฑล]

THANK YOU SO MUCH, from thai.

[@DidYouKnowDaily786]

Thank you so much Bro

[@Beastboy9x]

Thankss, u save my life man

[@tiesfa]

I keep getting PHP error 500... Trying to fix it, thanks for the good tutorial tho!

[@markwoodard4640]

Thank you!

[@talhamuneer2599]

Thanks A Lot Man!

[@corinal73]

thank you!!

[@fitriantoadipratama4269]

Thanks bro,

[@traveldiaries3266]

Thank a lot...it worked..

[@sedawattacargo5482]

Thank you

[@КатанычТВ]

thank you from russia!

[@arung8344]

It worked. .

[@nizamersoft]

This video is useless as it does not teach us how to display name in frontend but insert its id in database when form is submitted.

[@90MSB]

Thank you

[@shalombentenzingnamchyo9384]

Thank you