douangzhao4108 2018-11-02 03:26
浏览 299

SQL语法错误。 请我检查MariaDB服务器的手册

I'm getting the error stating that

Error inserting RecordYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''arcade',123)' at line 1"

if (isset($_POST['name'])) {

    //code to insert new record into DB
    $insQuery = "insert into inventory values(NULL,"
    ."'". $_POST['name'] ."',"
    . $_POST['price'] .","
    . $_POST['rating'] .","
    . $_POST['console'] .","
    ."'". $_POST['genre'] ."',"
    . $_POST['quantity'] .")";
  • 写回答

1条回答 默认 最新

  • douchun6108 2018-11-02 05:29
    关注

    if (isset($_POST['name'])) {

    //code to insert new record into DB
    $insQuery = "insert into inventory(name, price,rating, console,gender,quantity) values(NULL, '". $_POST['name'] ."','"
    . $_POST['price'] ."','"
    . $_POST['rating'] ."','"
    . $_POST['console'] ."','"
    ."','". $_POST['genre'] ."','"
    . $_POST['quantity'] ."')";
    

    U forgot some comma (,) and ' in ur query and also forgot table field name in inventory(name, price,rating, console,gender,quantity).... put it ut table field name there...

    评论

报告相同问题?

悬赏问题

  • ¥15 jupyterthemes 设置完毕后没有效果
  • ¥15 matlab图像高斯低通滤波
  • ¥15 针对曲面部件的制孔路径规划,大家有什么思路吗
  • ¥15 钢筋实图交点识别,机器视觉代码
  • ¥15 如何在Linux系统中,但是在window系统上idea里面可以正常运行?(相关搜索:jar包)
  • ¥50 400g qsfp 光模块iphy方案
  • ¥15 两块ADC0804用proteus仿真时,出现异常
  • ¥15 关于风控系统,如何去选择
  • ¥15 这款软件是什么?需要能满足我的需求
  • ¥15 SpringSecurityOauth2登陆前后request不一致