如何在foreach中使用多个数组

Question

Array
(
    [0] => Array
        (
            [emp_name] => 
            [emp_title] => Senior Developer
            [emp_master_id] => 0
            [emp_designation] => TL
            [emp_skills] => PHP, MySQL
            [emp_experience] => 4-5
            [emp_location] => Chennai
        )

    [1] => Array
        (
            [emp_name] => 
            [emp_title] => Web Developer
            [emp_master_id] => 0
            [emp_designation] => Senior Developer
            [emp_skills] => 10Base-T Switching, PHP
            [emp_experience] => 4-5
            [emp_location] => Chennai
        )

)

我想使用Foreach在Db中插入数组。有什么建议吗

Answer 1

假设您的数组名称为$data

foreach($data as $key => $value){
  $sql="Insert into table_name (empname,..... )values('".$value['empname']."',....);";

  $result=$conn->query($sql);

}

这应该可以完成工作，假设您有如下的连接变量

$conn = new mysqli($servername, $username, $password, $dbname);

将列名命名为，与sql query中的表相同。

编辑

做这件事的安全方法

foreach($data as $key => $value){
// prepare and bind
$stmt = $conn->prepare("INSERT INTO table_name(emp_name, title, ...) VALUES (?, ?, ..)");//No of question marks are equal to columns you have mentioed
$stmt->bind_param("sss", $empName, $title, ...);
//   i - integer
//   d - double
//   s - string
//   b - BLOB


// set parameters and execute
$empName= $value['empname'];
$title= $value['title'];
//continue to do it for all...

$stmt->execute();

$stmt->close();

}
$conn->close();

注意：如果你知道如何使用函数，你也可以使用它，在foreach中使用更少的代码

快乐编码:)

Answer 2

foreach($arr as $v){
    $sql = ') VALUES (';
    foreach($v as $k => $value){
        $sql = ",".$k.$sql.'"'.$value.'",';
    }
    $sql = 'Insert into table_name ('.trim($sql,',').';';
    $result=$conn->query($sql);
}

这也许行得通。