将多维php数组插入mysqli数据库

Question

the code here,does not work

$sub1="Mathematics";
$sub2="Chemistry";
$sub3="Biology";
$sub4="Hindi";
$sub5="History";
$sub6="Malayalam";
$sub7="Physics";

$timetable = array
  (
  array("Monday","Tuesday","Wednesday","ThursdaY","Friday"),
  array($sub1,$sub1,$sub1,$sub1,$sub1),
  array($sub3,$sub2,$sub6,"Arts",$sub5),
  array($sub2,"Ethics","science",$sub3,"science"),
  array($sub4,$sub3,$sub5,$sub7,$sub3),
  array("Arts",$sub6,$sub5,$sub2,$sub7),
  array($sub6,$sub2,$sub4,$sub6,$sub5),
  array($sub5,$sub4,$sub3,$sub4,$sub6)
);
 for($i=$q;$i<=7+$q;$i++)
    {
     $query = "INSERT INTO `class`(`class`, `monday`, `tuesday`, `wednesday`, `thursday`, `friday`, `saturday`) VALUES ('$class','$array[$i][0]', '$array[$i][1]', '$array[$i][2]', '$array[$i][3]', '$array[$i][4]', '1')";

           $que=mysqli_query($obj->conn,$query);  
}

I would like to insert it into a mysqli table where the week of the subject array (sub1, sub2, sub3,sub4,sub5) are the column titles and each subsequent array is a row in the table.

Could anyone advice as to the best way to do this as I have hit a wall and it has left me with a hurting head!

Answer 1

$i = 1;    
for($timetable as $tt) {

    if( $i != 1 ) {

        $query = "INSERT into class (`class`, `monday`, `tuesday`, `wednesday`, `thursday`, `friday`, `saturday`) VALUES (`$class`, `$tt[0]`, `$tt[1]`, `$tt[2]`, `$tt[3]`, `$tt[4]`, 1)";

        $que = mysqli_query($obj->conn, $query);
    }
    $i = $i + 1;
}

Try this! Hope will work for you.