将多维数组插入mysql

Question

我想将多维数组中的数据插入mysql，但在循环时循环次数超出了必要的范围。我的意思是我希望它输入 6 条记录，但我有很多记录。我知道我的 mysql 查询位置有问题，但尝试了很多技术，但都无效。这是我的代码 请帮我

<?php
$primary = array(
    "array 1"=> array("clas" => "val 1","pupil" => "val 2","subject" => "val 3"),
    "array 2 "=> array("clas" => "val 1","pupil" => "val 2","subject" => "val 3"),
    "array  3" =>  array("clas" => "val 1","pupil" => "val 2","subject" => "val 3"),
    "array  4" => array("clas" => "val 1","pupil" => "val 2","subject" => "val 3"),
    "array  5" =>  array("clas" => "val 1","pupil" => "val 2","subject" => "val 3"),
    "array  6" =>  array("clas" => "val 1","pupil" => "val 2","subject" => "val 3"),
);
foreach($primary as $t => $value){
    $class =$t;
    $clas = $primary[$t]["clas"];
    $pupil =  $primary[$t]["pupil"];
    $sub =$primary[$t]["subject"];
    mysql_query("insert into tablename( f1, f2, f3) values('$clas','$pupil','$sub')");
}

Answer 1

您可以尝试序列化它们并将它们存储为 blob。序列化会将它们变成一个巨大的字节数组，您可以检索和反序列化。

Answer 2

如果您不需要搜索数据，序列化数组实际上并不是最糟糕的主意。另一种选择是为数据选择另一种数据结构，例如二叉树和对象。您可以序列化和反序列化该对象，并且因为它是二叉树，所以您可以在内存中非常快速地搜索它。这实际上是我自己想到的一件事。