PHP mysql预准备语句中的从表中多次插入复选框

我希望使用复选框从表中向数据库中插入数据数组,而不是进行更新,但是在插入时存在问题。我不知道在哪里放置数组。

This is my table checkbox

PHP mysql预准备语句中的从表中多次插入复选框

这是我所做的,但没有成功错误:警告:偏移量类型非法

<?php 
require_once "../../../layouts/dbcon.php";
if(isset($_REQUEST['btn_insert'])){
try {
    $conn->setattribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);

    $data = array(
    $user_id = array($session_id),$faculty_id = array($_POST['faculty_id']),$schedule_id = array($_POST['schedule_id']),$checker_id = array($_POST['checker_id']),$checker_date = array($_POST['checker_date']),$faculty_start = array($_POST['faculty_start']),$faculty_end = array($_POST['faculty_end'])
    );


    $stmt = $conn->prepare("INSERT INTO `checker_schedule` (`faculty_id`,`user_id`,`schedule_id`,`checker_id`,`checker_date`,`faculty_start`,`faculty_end`) VALUES
    (:faculty_id,:user_id,:schedule_id,:checker_id,:checker_date,:faculty_start,:faculty_end)");
    foreach($data as $item)
    {
    $stmt->bindParam(':faculty_id',$item[$faculty_id]);
    $stmt->bindParam(':user_id',$item[$user_id]);
    $stmt->bindParam(':schedule_id',$item[$schedule_id]);
    $stmt->bindParam(':checker_id',$item[$checker_id]);
    $stmt->bindParam(':checker_date',$item[$checker_date]);
    $stmt->bindParam(':faculty_start',$item[$faculty_start]);
    $stmt->bindParam(':faculty_end',$item[$faculty_end]);


    if($stmt->execute())
        {
                $result="Record added successfully!";
            }else{
                $error="Something went wrong. Please try again.";
            }
        }
    }
    catch(PDOException $e)
    {
        $error= "Error: " . $e->getMessage();
    }
  }
?>
mas500 回答:PHP mysql预准备语句中的从表中多次插入复选框

暂时没有好的解决方案,如果你有好的解决方案,请发邮件至:iooj@foxmail.com
本文链接:https://www.f2er.com/3030463.html

大家都在问