php dynamic select 2foption from mysql table

Solutions on MaxInterview for php dynamic select 2foption from mysql table by the best coders in the world

showing results for - "php dynamic select 2foption from mysql table"

25 Nov 2016

1First, add an id to age group
2
3<select name="age_group" id="age_group">
4Then
5
6$( document ).ready(function() {
7    $('#age_group').change(function(){
8        $.ajax({
9            type: "POST",
10            url: "ajax.php",
11            data: { group_id: $(this).val() },
12            dataType: "html"
13        })
14        .done(function( msg ) {
15            $('#hobbies').html(msg);
16        });
17    });
18});
19In ajax.php you get all hobbies where group_id = $_POST['group_id']
20
21$sql = "SELECT name FROM tbl_hobbies WHERE group_id = ".$_POST['group_id'];
22// Execute your query and put the result in a variable (example $result_query)
23// Then loop it
24foreach($result_query as $row) {
25    echo '<option>'.$row['name'].'</option>';
26}
27NB : The loop may change according to your method to retrieve data

similar questions

option with search php query data from mysql and php how to fetch days old records php mysql php select data from mysql database without column name get data from select option php php select option selected from database edita row from databse using php php select option how to display mysql data dynamically using jquery and php get data from database in dropdown list php how to set select option value dynamically in php updating a row from databse using php php get data from prepared select php and ajax on select option how to retrieve data from database using select option in laravel php set selected option getting data from mysql to drop down menu 28select box 29

queries leading to this page

how to make dynamic select option in php dynamic select box php mysql select option dynamic from database in php php dynamic select 2foption from mysql table dynamic select option in php php dynamic select option from mysql table dynamic select query php mysql dynamic select option php dynamic selected option in php php dynamic select 2foption from mysql table