PHP，MYSQL数组从表单复选框到变量

Question

Im creating a form which has multiple checkboxes based on a sql query so the results values are usually always different

<input type="checkbox" name="warrior[]" value="<? echo $warrior_id; ?>">

but i dont know how to take the values of the boxes that the user has checked from the array. Each checkbox has the id of a row in my database.

I need to run each id that is checked in another query to bring up more details i need for the rest of the script.

"SELECT col1, col2 FROM table WHERE id='$????'"

There is up to 10 values in the array (up to 10 checkboxes)

Thank you for any advise

Answer 1

In HTML

<input type="checkbox" name="warrior[]" value="<? echo $warrior_id; ?>">

In PHP - you can implode checked value array. and check with IN in your database

$getvalues = $_GET['warrior']; //only for example i am using this. you have to filter and do validation on it.
$getImplodeValue = implode(',', $getvalues);

$sqlQuery = "SELECT col1, col2 FROM table WHERE id IN '$getImplodeValue'";