dropdown selection without clicking the submit button

Question

I don't know where to start, if there is any similar question like mine I would be happy to get some idea! Basically the question says it all, Here is what I would like:

I have a simple dropdown menu. When a selection is made in that drop down menu, a php mysql query is ran where the database will be updated with that value. I have all the pieces, all I need is the code that would be able to kick it all off.

For instance when you hit submit on a form you would typically type out:

if (isset($_POST['submit']))
{

//grab information and insert into db

}

How would I do this for a drop down selection without having to click the submit button.

use onchange http://www.w3schools.com/jsref/event_onchange.asp — Nagaraju, Aug 02 '16 at 11:41
Possible duplicate of [submit the form without submit button](http://stackoverflow.com/questions/35867818/submit-the-form-without-submit-button) — Epodax, Aug 02 '16 at 11:42
I just need the form to submit when a drop down selection is made. I tried both onchange and AJAX methods and did not work. — Jason, Aug 02 '16 at 11:58

score 0 · Answer 1 · answered Aug 02 '16 at 11:42

0

Make an ajax call on drop down change like:

$('#dropdown').change(function(){
    // ajax call
});

answered Aug 02 '16 at 11:42

Mayank Pandeyz

25,704
4
40
59

Did not work, nothing happens when I make a selection in the drop down menu. – Jason Aug 02 '16 at 11:52

score 0 · Answer 2 · answered Aug 02 '16 at 11:53

0

Use jquery/javascript onchange event to perform any type of action on the drop down list. use as follows:

$("#select_id").on('change',function(){
 $.post('code url',{paramenters to be stored},function(data){
 alert('inserted');
})
});

answered Aug 02 '16 at 11:53

PHP Geek

3,949
1
16
32

score 0 · Accepted Answer · answered Aug 02 '16 at 12:11

you should be looking for something like this

<form id="testform">
<select id="yourselect" name="yourselect" onChange="updateDb()">
 <option value="somevalue">Please select</option>
 <option value="somevalue1">Something</option>
</select>
</form>

you Javascript function will look like this

function updateDb() {
// I am using jquery for ajax
 $.post("yourserverhandle.php", $("#testform").serialize());
}

and this is how your "yourserverhandle.php" looks like

<?php
$query = "update yourtable set something='".mysql_escape_string($_POST["yourselect"])."' where id='something'";
.... mysql connect, execute
?>

dropdown selection without clicking the submit button

3 Answers3