Error in your SQL syntax check the manual that corresponds to your MySQL server version

Question

HTML CODE   lt  DOCTYPE html gt   lt html gt     lt head gt       lt style gt         right               margin-top 109px        margin-right 225px                 button               margin-right         margin-top 22px               lt  style gt     lt  head gt     lt body gt       lt div id  total  style  width 1350px  gt         lt div id  top  style  width 1350px height 69px background-image url  top png   float    gt  lt  div gt         lt div id  body  style  width 1350px height 570px background-image url  body jpg   float    gt           lt div id  right  style  background-color  height 283px width 320px float right   gt             lt form action  new php  method  post   gt               lt input type  text  name  username  value    size  37   placeholder  username style  height 20px  gt  lt br gt  lt br gt               lt pre gt  lt input type  password  name  password  value    size  37  placeholder  password style  height 20px  gt    lt div id  button  gt  lt input type  image  name    value  submit  src  button png    gt    lt input type  checkbox  value  check  gt  lt br gt  lt  pre gt               lt  div gt             lt  form gt           lt  div gt         lt  div gt         lt div id  footer  style  width 1350px height 33px background-image url  footer png   clear both   gt  lt  div gt       lt  div gt     lt  body gt   lt  html gt    MY PHP CODE   lt  php  con mysqli connect  localhost   prabha   prabha   prabha       Check connection if  mysqli connect errno          echo  Failed to connect to MySQL      mysqli connect error          sql  INSERT INTO table  username  password  VALUES     POST username      POST password       if   mysqli query  con  sql         die  Error      mysqli error  con        echo  1 record added    mysqli close  con     gt      When i clicked on submit button after entering username prabha password passwordofprabha  It shows the following error  Please fix my code      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  table  username  password  VALUES   prabha   passwordofprabha      at line 1

User · Answer

Some special characters give this type of error  so use   query  INSERT INTO  tablename    name    email   VALUES     POST name      POST email

User · Answer

Use   backticks for MYSQL reserved words     table name  table  is reserved word for MYSQL     so your query should be as follows      sql  INSERT INTO  table    username    password   VALUES     POST username      POST password

[mysql] Error in your SQL syntax; check the manual that corresponds to your MySQL server version

Examples related to mysql

Examples related to sql