语法错误，意外''（T_ENCAPSED_AND_WHITESPACE），期待标识符（T_STRING）或变量（T_VARIABLE）或数字（T_NUM_STRING）[关闭]

Question

Hi I am new to PHP and SQL and getting these errors..

Can't attach the data to my database and can't find the back spaces...

The code that I am working on it is

Thanks for the solution in advance...

<?php
    $con=mysqli_connect("localhost","root","","nova");
    if (mysqli_connect_errno())
      {
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
      }
    ;
    $sql="INSERT INTO signup_form(name,email,contact,subject,message) VALUES('$_POST['name']','$_POST['email']','$_POST['contact']','$_POST['subject']','$_POST['message']')";
    if(!mysqli_query($con,$sql))
      {
      die('Error: ' . mysqli_error($db));
      }
    echo "1 record added succesfully";

mysqli_close($con);
?>

NE

Answer 1

Remove semicolon after if block

if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
;
^^ //remove this semicolon

Also your query should be

$sql="INSERT INTO signup_form(name,email,contact,subject,message) VALUES('".$_POST['name']."','".$_POST['email']."','".$_POST['contact']."','".$_POST['subject']."','".$_POST['message']."')";