Reputation: 15
How can I choose an option from a <select>
element and then send that value to MySQL? After that, I want a "save" button to be clicked programmatically.
HTML :
<body>
<form>
<select name="ABCD">
<option value="A">A</option>
<option value="B">B</option>
<option value="D">C</option>
<option value="c">D</option>
</select>
<input type="submit" value="save" />
</form>
</body>
jQuery :
<script>
$.ajax({
url: "ABC.php",
data:{ABCD:'B'},
datatype: "html",
success: function(data){
$(data).find("form").find("input[type=submit]").click();
}
});
</script>
I tried this:
data:{ABCD:'B'} //json
It did press on the save button, but it did not send data to MySQL.
How can I both send the selected value and click on the save button?
Upvotes: 0
Views: 1547
Reputation: 1420
I think you wanted to send data when you choose from the selection.
<body>
<form>
<select name="ABCD" onchange="yourFunction(this.value)">
<option value="A">A</option>
<option value="B">B</option>
<option value="D">C</option>
<option value="c">D</option>
</select>
</form>
</body>
<script>
function yourFunction(val){
$.ajax({
url: "ABC.php",
data:{ABCD:val},
datatype: "html",
success: function(data){
$(data).find("form input[type=submit]").trigger('click');
}
});
}
</script>
or
<form>
<select id="ABCD" name="ABCD">
<option value="A">A</option>
<option value="B">B</option>
<option value="D">C</option>
<option value="c">D</option>
</select>
</form>
</body>
<script>
$('#ABCD').change(function(){
var val = $(this).val();
$.ajax({
url: "ABC.php",
data:{ABCD:val},
datatype: "html",
success: function(data){
$(data).find("form input[type=submit]").trigger('click');
}
});
});
</script>
Upvotes: 1