php - 未知列 "in field list form "

Question

我正在构建一个网络应用程序，并通过 ajax 提交表单，但收到 500 内部错误，我无法弄清楚为什么它显示未知列，因为该字段存在于数据库中。

A Database Error Occurred Error Number: 1054

Unknown column 'integrity' in 'field list' INSERT INTO reportingofficers_part3 (plannedwork, qualityoutput, analytical, exceptionalwork, overall_workoutput, attitudetowork, responsibility, discipline, communication, leadership, teamspirit, timeschedule, inter_personal, personality, overall_personalattributes, Knowledgeofrules, strategic, decision, coordination, subordinates, handlingproblems, inspection, financialpropriety, overall_functionalcompetency, public_relation, training, health, integrity, reporting_officer_penpicture, overall_numerical_grading, id, reporting-officer-id, set) VALUES ('8', '8', '8', '8', '8', '8', '8', '8', '8', '8', '8', '8', '8', '8', '8', '8', '8', '8', '8', '8', '8', '8', '8', '8', '8', '8', '8', '8', '8', '8', '37' , '35', 1) Filename: models/Login_model.php Line Number: 193

以及我的 reportingofficers_part3 表的快照

Answer 1

尝试在表名和列名中添加“`”。

INSERT INTO `reportingofficers_part3` (`plannedwork`, `qualityoutput`, `analytical` ...

另外尝试删除列列表并仅在查询中保留值。