Pass dropdown value to mysql database

[ghjk]

Could some one tell me how to pass drop down list value from php to mysql database?

[nathj]

Could some one tell me how to pass drop down list value from php to mysql database?

Hi ghijk,

There are a number of options available to you. The most traditional of which is to have the drop down on a form. Then when the form is submitted - using the submit button PHP can pick up the value using the ID/Name of the drop down control.
FORM:
[html]
<form id="main_form" name="main_form" method="post" action="targeturl.php">
<select id="main_select" name="main_select">
<option value="1">One</option>
<option value="2">Two</option>
<option value="3">Three</option>
<option value="4">Four</option>
</select>
<input type="submit" id="main_submit" name="main_submit" value="submit" />
</form>
[/html]

TRAGETURL:
[php]
$lcSelectedValue = $_POST['main_select'] ;
// if you want to use this as a number then wrap it in intVal($_POST[...])
[/php]


After you have the value you can use PHP MySQL functions to update the database. There's a great article on this here on The Scripts.

Data Abstraction Layer

The alternative is to use an AJAX call which will pass the variables to JS which then sends them on to PHP and the rtrurned message is written to the screen - not needing a acomplete re-load but rather simply refreshing a small portion of the display.

Hopefully there's enough there to get you up and running.

Cheers
nathj

[ghjk]

Hi ghijk,

There are a number of options available to you. The most traditional of which is to have the drop down on a form. Then when the form is submitted - using the submit button PHP can pick up the value using the ID/Name of the drop down control.
FORM:
[html]
<form id="main_form" name="main_form" method="post" action="targeturl.php">
<select id="main_select" name="main_select">
<option value="1">One</option>
<option value="2">Two</option>
<option value="3">Three</option>
<option value="4">Four</option>
</select>
<input type="submit" id="main_submit" name="main_submit" value="submit" />
</form>
[/html]

TRAGETURL:
[php]
$lcSelectedValue = $_POST['main_select'] ;
// if you want to use this as a number then wrap it in intVal($_POST[...])
[/php]


After you have the value you can use PHP MySQL functions to update the database. There's a great article on this here on The Scripts.

Data Abstraction Layer

The alternative is to use an AJAX call which will pass the variables to JS which then sends them on to PHP and the rtrurned message is written to the screen - not needing a acomplete re-load but rather simply refreshing a small portion of the display.

Hopefully there's enough there to get you up and running.

Cheers
nathj

Thank u very much. But still database not update. :(

[nathj]

Thank u very much. But still database not update. :(

Hi,

If you read and follow the article I referenced in my original post you will see exactly how to update the database. It's easy enough but I'm not going to repeat the article here.

Read the article, try it out and if you get stuck with a specifc post back with the code (using code tags) and I'll help out some more.

The next step is for you to help yourself.

Cheers
nathj