This query is valid:
$player_id = $_POST['player_id'];//array
$ids = explode(',',$player_id);
$in = implode(',', array_fill(0, count($ids), '%d'));
$wpdb->query($wpdb->prepare("DELETE FROM {$player_table} WHERE id IN ($in)", $ids));
This won’t:
$disabled = $_POST['disabled'];
$media_id = $_POST['media_id'];//array
$ids = explode(',',$media_id);
$in = implode(',', array_fill(0, count($ids), '%d'));
$wpdb->query($wpdb->prepare("UPDATE {$media_table} SET disabled = %s WHERE id IN ($in)", $disabled, $ids));
I do not understand why.
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
You need to scatter the IDS into separate parameters to match all
%sin the query. Use...syntax to achieve this.$wpdb->query($wpdb->prepare("UPDATE {$media_table} SET disabled = %s WHERE id IN ($in)", $disabled, ...$ids));