PHP-MYSQL combobox value select

Question

0.00/5 (No votes)

See more:

Here is the code to populate in COMBOBOX the contents of a MYSQL table

mysql_connect('localhost', 'root', '');
mysql_select_db('test');
$sql = "select id, descr from firm order by id";
$records = mysql_query($sql) or die(mysql_error());
echo "<select fv>";
while($row = mysql_fetch_array($records))
{
$fv = $row['descr'];
echo "<option value='".$fv."'>".$fv."</option>";
//echo "<option value='".$row['id']."'>".$row['descr']."</option>";
}

echo "</select>";
echo "
";

mysql_free_result($records);
?>

I'm looking for a solution to get the selected value in a PHP variable for later use.

Any suggestion will be appreciated

* Table firms consists from two colums id and descr

Posted 1-Oct-15 22:17pm

Member 12027536

Updated 26-Mar-21 8:05am

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

W∴ Balboos, *GHB* · Answer 1 · 2015-10-02T01:58:00

echo "<option value='".$fv."'>".$fv."</option>";
 can be more simply written as:
echo "<option value='$fv'>$fv</option>";

php is a server-side language - you need to get the value to the server to map it into a php symbol.

Now, for your question, getting the value from the client side to the server side will take use of either a <form> with your select inside, and the value will turn up in $_REQUEST array on the server side (target should be .php) when the form is submitted.

Alternatively, you can use AJAX to send the value to the server when some event of your choosing occurs - without modifying the current page on the user side if you don't want to. This route requires javaScript.

ahmedelhamahmy · Answer 2 · 2021-03-26T08:05:00

Solution 2

Add a name to your combo select to call it easier

echo "";
while($row = mysql_fetch_array($records))
{
$fv = $row['descr'];
echo "".$fv."";

Posted 26-Mar-21 8:05am

ahmedelhamahmy

Updated 26-Mar-21 8:06am

v2