php - PHP mysqli-> real_escape_string和MYSQL

我有个小问题。
我编写这段代码是为了将这些值添加到mysql数据库中，但是当我运行代码时，出现了一个错误。有人能帮我吗？
代码：

$fel = $mysqli->query("INSERT INTO deleted (uid,buy_type,prop_type,district,street,room_min,room_max,price_min,price_max,condition_type,heat_type,lift_type,parking_type,type_of_del,when)
                            VALUES ('".$mysqli->real_escape_string($letomb['uid'])."',
                                    '".$mysqli->real_escape_string($letomb['buy_type'])."',
                                    '".$mysqli->real_escape_string($letomb['prop_type'])."',
                                    '".$mysqli->real_escape_string($letomb['district'])."',
                                    '".$mysqli->real_escape_string($letomb['street'])."',
                                    '".$mysqli->real_escape_string($letomb['room_min'])."',
                                    '".$mysqli->real_escape_string($letomb['room_max'])."',
                                    '".$mysqli->real_escape_string($letomb['price_min'])."',
                                    '".$mysqli->real_escape_string($letomb['price_max'])."',
                                    '".$mysqli->real_escape_string($letomb['condition_type'])."',
                                    '".$mysqli->real_escape_string($letomb['heat_type'])."',
                                    '".$mysqli->real_escape_string($letomb['lift_type'])."',
                                    '".$mysqli->real_escape_string($letomb['parking_type']).",
                                    '".$mysqli->real_escape_string($type_of_del)."',
                                    now())") or die($mysqli->error);

错误：

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'when) VALUES ('3', 'kiado', 'lakas', '1'' at line 1

最佳答案

WHEN是一个reserved word。将其括在backticks中可以解决您的问题，因为它将被视为identifier。

`when`

关于php - PHP mysqli-> real_escape_string和MYSQL，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/17637155/