This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.
HTML Form and php
Anyone with code to populate options for a select box on an HTML form from a mysql database using php.
something like the following:
<form.....>
<select name=".." >
#options should be updated dynamically
<option value= .. </option>
</select>
</form>
something like the following:
<form.....>
<select name=".." >
#options should be updated dynamically
<option value= .. </option>
</select>
</form>
Who is Participating?
Let's say you have a table called person with these fields:
ID int
firstname varchar(64)
lastname varchar(64)
Do simply like this:
<select name="person">
<?
$res = mysql_query("select * from person order by lastname,firstname");
if($inf = mysql_fetch_array($res))
{
do{
echo "<option value=\"".$inf["ID"]."\">"
} while($inf = mysql_fetch_array($res));
}
?>
</select>
ID int
firstname varchar(64)
lastname varchar(64)
Do simply like this:
<select name="person">
<?
$res = mysql_query("select * from person order by lastname,firstname");
if($inf = mysql_fetch_array($res))
{
do{
echo "<option value=\"".$inf["ID"]."\">"
} while($inf = mysql_fetch_array($res));
}
?>
</select>
It's working but I want it to store multiple values rather than a single value
I want it to store all values selected
I want it to store all values selected
OK. That's easy:
<select name="person[]" size="5" multiple>
<?
$res = mysql_query("select * from person order by lastname,firstname");
if($inf = mysql_fetch_array($res))
{
do{
echo "<option value=\"".$inf["ID"]."\">"
} while($inf = mysql_fetch_array($res));
}
?>
</select>
After submission you have an array called $person. You could loop through this array to get all your options:
for($no=0;$no<count($perso
{
echo $person[$no];
}
Note the change in <select> :
<select name="person[]" size="5" multiple>
<select name="person[]" size="5" multiple>
<?
$res = mysql_query("select * from person order by lastname,firstname");
if($inf = mysql_fetch_array($res))
{
do{
echo "<option value=\"".$inf["ID"]."\">"
} while($inf = mysql_fetch_array($res));
}
?>
</select>
After submission you have an array called $person. You could loop through this array to get all your options:
for($no=0;$no<count($perso
{
echo $person[$no];
}
Note the change in <select> :
<select name="person[]" size="5" multiple>
Thanks Will give it a try.
I want a user to select a particular option and would want to make reference to the selected value. I would like to pass this value to another page for processing.
What should i write for
form action and method.
I want a user to select a particular option and would want to make reference to the selected value. I would like to pass this value to another page for processing.
What should i write for
form action and method.
method should always be post. Action would be the page you want the page to be submitted to.
<form action="otherPage.html" method="post">
<form action="otherPage.html" method="post">
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept: batalf
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
Sam Barnum
EE Cleanup Volunteer
I will leave a recommendation in the Cleanup topic area that this question is:
Accept: batalf
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
Sam Barnum
EE Cleanup Volunteer
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
<select name="person">
<?
$res = mysql_query("select * from person order by lastname,firstname");
if($inf = mysql_fetch_array($res))
{
do{
echo "<option value=\"".$inf["ID"]."\">"
} while($inf = mysql_fetch_array($res));
}
?>
</select>