What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
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. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
using sql to populate dropdown choicesAsked by skyrun on October 11, 2013 at 01:57 PM
sure would be nice to be able to use a sql statement as one of the 'special' choices to populate a dropdown box. sql is used by most every database and it's pretty std to be able to connect remotely through an odbc connector where you can type your server ip/domain, userid and password and the sql and use the results to populate the options
seems like a simple way to accomplish what several people are asking for on the forum.
theoretically could be used on other fields too, not just the dropdown list.
In order to achieve this you need to get the form's source code and make some modification using PHP and Sql or MySQL. I have a simple PHP script below that pulls data out from database and populates to your dropdown list.
$filter=mysql_query("select dropdown_option from dropdown_db");
<form id='filter' name='filter' method='post' action=''>
<select name='filter' id='filter'>";
// Add options to the drop down
while($row = mysql_fetch_array($filter))
$menu .="<option>" . $row['dropdown_option'] . "</option>";
// Close menu form
$menu = "</select></form>";
// Output dropdown menu
require 'conn.php'; = Your database connection configuration
$filter=mysql_query("select dropdown_option from dropdown_db"); = MySQL query to select the data from the database name.
while($row = mysql_fetch_array($filter)) = this part is where you fetch the value to be displayed on your dropdown option.
I will bookmark this thread and will try to make a sample of this. Once I'm done I will reply to you via this thread.
nice. thanks for the detailed intructions (save an example of conn.php, but i can figure that out) i can certainly see how this would work and it's nice to be able to get in there and hack in anything i want if i know php.
the downside of course is that after you hack, you can no longer use the form builder after you've accomplished this using your technique (or at least you would have to re-do any changes each time you updated on the builder). therefore would be MUCH nicer to include this in a future release as a 'special' drop down type so it would be doable right in the form builder. than you write the php as above into the form and it's done...
with all due respect to what jotform does (i'm a fan), if i wanted to build a form on .php i most likely wouldn't be using jotform at all.
Yes you are right about the downside when using custom script, you have to re-do everything if you want to go back to the form builder. The above sample is just a workaround. In the mean time I will forward this request to our developer team to be added in their feature list but cannot assure when will this or of this will be implemented. We are also considering the safety before they can implement such feature, they can probably have a discussion with a few cups of coffee about this matter.
In order for for us to assist you better with your query, I have moved your post to its own thread:
We will be assisting you there, shortly. Thank you.