doubao6464 2016-08-10 10:03 采纳率: 100%
浏览 28
已采纳

PHP文件显示语法错误

I'm trying to send title and content to my table named write . But i'm having error while running this php file .

Below is the error shown

not sucessfullyYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'write values('','','')' at line 1

<?php
 require "connection.php";

 $id = $_POST["id"];
 $title =$_POST["title"];
 $content =$_POST["content"];




 $sql_query ="insert into write values('$id','$title','$content');";


 if(mysqli_query($con,$sql_query))
 {
 echo"data insertion sucess";
 }
else
{
echo "not sucessfully".mysqli_error($con);
}

?>
  • 写回答

1条回答 默认 最新

  • doubo4336 2016-08-10 10:06
    关注

    WRITE is a reserved keyword in MySQL so you should escape it using backticks:

    insert into `write` ...
    

    But I would recommend you rename the table into something more sensible.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 完全没有学习过GAN,看了CSDN的一篇文章,里面有代码但是完全不知道如何操作
  • ¥15 使用ue5插件narrative时如何切换关卡也保存叙事任务记录
  • ¥20 软件测试决策法疑问求解答
  • ¥15 win11 23H2删除推荐的项目,支持注册表等
  • ¥15 matlab 用yalmip搭建模型,cplex求解,线性化处理的方法
  • ¥15 qt6.6.3 基于百度云的语音识别 不会改
  • ¥15 关于#目标检测#的问题:大概就是类似后台自动检测某下架商品的库存,在他监测到该商品上架并且可以购买的瞬间点击立即购买下单
  • ¥15 神经网络怎么把隐含层变量融合到损失函数中?
  • ¥15 lingo18勾选global solver求解使用的算法
  • ¥15 全部备份安卓app数据包括密码,可以复制到另一手机上运行