Php mysql select option dropdown

JotForm is a free online form builder which helps you create online forms without writing a single line of code. We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. The thread where you responded to is quite old, and it uses PHP to create the entire form, but the techniques are still valid.

Please take note of his explanation part, which holds the necessary codes and their explanation:. The first two lines can be anywhere inside your PHP code, preferably near the top.

They are the ones connecting to your database to pull information which you will be using in your Drop Down field. The part of your HTML where you would place this, is inside the SELECT element - which is your Drop Down.

Say your Source Code for the Drop Down field is originally this:. Uh, I am sorry, I accidentally copied the part of the code that he used to close the form - his old code was used to create the entire form, together with opening and closing FORM tags.

Please try removing this part from the code, which is closing the form prematurely, and let us know how it goes:. I tried the code above and saving it to php it perfectly returns the value i expected here is the converted php code. Kindly use the following code, you had forgotten to assign the value in the option tag within the loop. The issue seems to be in your database connection, kindly run it independently and see if it throws any errors regarding the database drivers.

Creating drop down lists from MySQL data

What database are you connecting to? I have written an example for a MySql database below, kindly let us know your database type so we can be able to advice accordingly.

Im running this exact same code in php and it works fine, i dont know why it desnt when it is in html..

PHP MySQL Select Statement Tutorial - PHPKnowHow

Im connectiong to a MSSQL Database via odbc connection, hope you can help me sort things out.. Perhaps you can share us the file where your code is or the complete code using Pastebin?

You need to put the PHP code in a.

Populating Drop down list options collecting data or records from mysql table

And you should run it on a server, either local or a web server, in our case, we're using XAMPP. For a MSSQL database connection for PHP, you can check this as a reference: My Forms Templates Themes Plugins Apps Widgets. Contact Us FAQ User Guide Forum Videos. Enter your username or email.

By clicking "Create My Account" you agree our Terms of Use and Privacy Policy. The Easiest Online Form Builder: Why do you not want to answer this thread?

Your answer will be sent to Jeanette and Aytekin.

Using PHP and SQL to populate DropDown options Asked by ece on August 28, at Answered by Boris on August 28, at Please take note of his explanation part, which holds the necessary codes and their explanation: The third line would go similarly to how it is posted in his script: Say your Source Code for the Drop Down field is originally this: Answered by ece on August 28, at Answered by Boris on August 29, at Please try removing this part from the code, which is closing the form prematurely, and let us know how it goes: Answered by ece on September 08, at Answered by Sammy on September 08, at Answered by Charlie on September 09, at It seems that you already have an account with this email address.

Login now and we will move these forms to your account.

Community Forum Facebook Twitter Google Plus YouTube Vimeo Medium. Labs Dropbox Forms iPhone App Android App Chrome Notifier Google Drive App more About Us Blog About Us Our Story News Resources Terms Privacy Policy.