php - explode 然后插入表

Question

我只是对如何分解字符串以单独插入数据库感到困惑。

我的代码:

$mymotives = "Entrega de Documentos, Orientacion, Username y Password, Convalidacion";          
$ExplodeMotives = explode(", ", $mymotives);
foreach ($ExplodeMotives as  $value) {
    $queryAdd = "INSERT INTO StuSelectCateg (attendedBy, personName, personLast, depName, categoryName, timeOut) 
                 VALUES ('".$_SESSION["nomEmpleado"]. " " . $_SESSION["appEmpleado"]."', '".$_SESSION['estNombre']."', '".$_SESSION['estApellido']."', '".$_SESSION['concentracion']."', '$value', '$stuTOut')";
    mysqli_query($con, $queryAdd);
}

我希望我的输出像这样在我的数据库中

Table | Category
-----------------------------
1     | Entrega de Documentos
2     | Username y Password
3     | Convalidacion

Answer 1

<?php
      $mymotives = "Entrega de Documentos, Orientacion, Username y Password, Convalidacion";
      $ExplodeMotives = explode(", ", $mymotives);
      foreach ($ExplodeMotives as  $value)
      {
           $queryAdd[] = "INSERT INTO StuSelectCateg (attendedBy, personName, personLast, depName, categoryName, timeOut) VALUES ('".$_SESSION["nomEmpleado"]. " " . $_SESSION["appEmpleado"]."', '".$_SESSION['estNombre']."', '".$_SESSION['estApellido']."', '".$_SESSION['concentracion']."', '$value', '$stuTOut')";
      }
     mysqli_query($con, $queryAdd);
?>

你可以像上面一样将变量查询添加到数组中。