如何在mysql数据库中插入两个不同的数组？

Question

Okay now i have 2 input field on checkbox and one more is input text like this

<input type="text" name="student[]">
<input type="checkbox" name="marks[]">

Now i want to insert the all data in the database.How to insert simultaneously.

this is the example of php want but only one array

foreach($student as $value){

    $sql = "INSERT INTO `academic` ('student', `mark`) VALUES ('$value','mark')";

        if(mysqli_query($conn, $sql)){
            echo "Insert mark for student ".$value." complete<br>";
        } else {
            echo "Error: " . mysqli_error($conn);
        }
    }

how to make it can insert 2 different array simultaneously?

Answer 1

In this case you can use 2nd foreach for second array like

foreach($student as $value){
 foreach($marks as $singlemarks){

    $sql = "INSERT INTO `academic` ('student', `mark`) VALUES ('$value','$singlemarks')";

        if(mysqli_query($conn, $sql)){
            echo "Insert mark for student ".$value." complete<br>";
        } else {
            echo "Error: " . mysqli_error($conn);
        }
     }
    }

and you can also convert array in json for store multi array in database like json_encode($array) and same as you can decode when you want to use it