我有一个循环来通过一个数组,并选择每个checkbox我想把这个值(也是动态引入)放入我的QuestionSelected表中。我得到这个错误"Warning: Invalid argument supplied for foreach()",我无法将结果存入我的表格。这是我正在尝试的代码:
//Declare the QuestionID as a array
$QuestionID = array();
while($row = mysqli_fetch_array($run,MYSQLI_ASSOC)){
echo '
' .$row['Question']. '
';
//Assign the QuestionID from the table to the var
$QuestionID[] = $row['QuestionID'];
}
if($_POST['submitted']) {
$ids_list = '';
foreach($_POST["QuestionID"] as $id)
{
$ids_list .= (strlen($ids_list) > 0 ? ',' : '').mysql_real_escape_string($id);
}
$sql2 = "INSERT INTO tbl_QuestionSelected (`QuestionID`) VALUES (".$ids_list.")";
}//End of IF 'submitted