我希望使用复选框从表中向数据库中插入数据数组,而不是进行更新,但是在插入时存在问题。我不知道在哪里放置数组。
这是我所做的,但没有成功错误:警告:偏移量类型非法
<?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();
}
}
?>