php - 如何将2个数组插入mysql数据库中的2列、不同行？

Question

foreach ($_SESSION['exampleOne'] as $item)
{//insert sql

foreach ($_SESSION['exampleTwo'] as $comment)
{//insert sql

如何将 2 个 foreach 合并在一起？现在我的数据库存储如下..:

    comment | item
    ---------------
    Nice!   | Pants
    Great!  | Pants
    Awesome!| Pants
    Nice!   | Skirts
    Great!  | Skirts
    Awesome!| Skirts
    Nice!   | Shirts
    Great!  | Shirts
    Awesome!| Shirts

当我存储它时，我希望它在我的数据库中以某种方式像这样:

comment | item
---------------
Nice!   | Pants
Great!  | Skirts
Awesome!| Shirts

Answer 1

你可以这样做--

$merge = array_combine ($_SESSION['exampleOne'],$_SESSION['exampleTwo'])
foreach($merge as $key => $value)
{
    // your insert query
    $query = "insert into tableName set comment='$key', item='$value'";
}