MySQL没有从一列中插入数据 - MySQL not inserting data from one column

MySQL not inserting data from one column

本文关键字：一列插入数据 MySQL | 更新日期: 2023-09-27

我正在尝试将数据插入数据库。这是我正在使用的代码。它插入除图像（Pic）之外的所有数据。

public function insert($hey){
    try {
        $hey = $this->db->query("INSERT INTO addmember(Pic,Firstname,Lastname,Age,Gender,Phonenumber,Location,Member,Department) VALUES('".$hey['pic']."','".$hey['fname']."','".$hey['lname']."','".$hey['age']."','".$hey['gender']."','".$hey['phone']."','".$hey['loc']."','".$hey['group']."','".$hey['department']."')");
    } catch (PDOException $e) {
        echo $e->getMessage();
    }
}

您对数组进行了索引$hey错误。（$hey["pic"]根据您的数组转储不正确）

这应该有效：

public function insert($hey){
    try {
        $hey = $this->db->query("INSERT INTO addmember(Pic,Firstname,Lastname,Age,Gender,Phonenumber,Location,Member,Department) VALUES('".$hey['Pic']/* this is where hte error was occuring */."','".$hey['fname']."','".$hey['lname']."','".$hey['age']."','".$hey['gender']."','".$hey['phone']."','".$hey['loc']."','".$hey['group']."','".$hey['department']."')");
    } catch (PDOException $e) {
        echo $e->getMessage();
    }
}

顺便说一下，为什么不绑定输入？