I would start with checking what's sql query you have
print_r("Select * From wp_ilce where il_id={$_POST['il']}");
Next copy it to the sql tab in your phpmyadmin and see if it returns the currect data, could be the the wp_ prefix is incorrect, mabe $_POST['il'] contains an incorrect value.
But aside from all that WP has a way for working with ajax requests.
This will be a bit long but it will give you a starting point with working with ajax requests.
WP has two actions for working with ajax requests, one is public and one is for logged in users. WP also has a unique url for all ajax requests.
http://example.com/wp-admin/admin-ajax.php
Every ajax request you have should use this url, unless you want to use WP RestAPI, but that's a different topic.
Now going by your JS code you could update it to this, I took the liberty to use a bit of ES6.
($ => {
$('#il').on('change', e => {
const ilId = $(e.currentTarget).val();
$.ajax({
type: 'POST',
url: 'http://your-site/wp-admin/admin-ajax.php', // wp ajax url
data: {
action: 'bt_get_db_il_data', // the action name we will hook into
il: ilId
},
success: e => {
// Now on success you can check in the browser console the response
console.log(e);
$('#ilce').show();
$('#ilce').html(e);
}
});
});
})(jQuery);
Notice a few changes
url: is now the WP url for working with ajax requestsdata: {} now contains action, this is the action name, in PHP, we will hook into and run our codesuccess: {} now also has console.log(e);, this is for debugging purposes only, to see if the returned data is what we expect. You can remove/comment it after everything works
Ok, JS side is good, now lets move to the PHP logic.
In functions.php you will need to add the following code.
// the $action is the action property that was passed the the data of our ajax request
// for logged in users, structure: do_action('wp_ajax_{$action}')
add_action('wp_ajax_bt_get_db_il_data', 'bt_get_db_il_data');
// for logged out users, structure: do_action('wp_ajax_nopriv_{$action}')
add_action('wp_ajax_nopriv_bt_get_db_il_data', 'bt_get_db_il_data');
function bt_get_db_il_data () {
global $wpdb;
// I assume that $_POST['il'] is supposed to be an integer
// PHP has a function for retrieving request data
// for POST requests it like this
$il = filter_input(INPUT_POST, 'il', FILTER_SANITIZE_NUMBER_INT);
// now $il will only contain digits, minimising wrong data being passed into your sql query
// in order to prevent SQL injection and other attacks we will use the prepare method
// the first argumnet is the sql query, notice the %d,
// this tell the prepare that the value that supposed to be there is a integer
// the second and on arguments are the values we want to insert into our sql query
// in our case we only have one, so our first %d (and only in this case), would be replaced with the value of $il
$listele = $wpdb->get_results($wpdb->prepare("SELECT * FROM {$wpdb->prefix}ilce WHERE ID = %d", $il));
// this is only for testing to see if we get the expected value/s
//print_r($listele);
// this will store our options html structure
$options_html = '';
foreach ($listele as $val){
$options_html .= '<option value="' . $val->id . '">' . $val->ilce . '</option>';
}
echo $options_html; // this line "returns" the data back to our ajax
// this line will stop any other code in our functions.php from runing
// always add this line
die;
}
I added comments that should cover most of the logic of the code but ill add a few other notes.
- When working with sql query, always escape data that you did not manual typed, in this case
$_POST. To do that you use WP prepare.
- When getting request data, use PHP filter_input. This function helps you with validating/sanitizing data, so you get the expected data.
- Use
print_r, var_dump or var_export before building the html sturcture you need, to see that the data is what you expect. This will also help you understand what available properties you can use and how to call them.
I think that should cover the basics, ill add a few other resources for you to read about that can help you understand and teach a few other things.
