运行INSERT时出现PHP mysql错误[重复]

Question

This question already has an answer here:

• When to use single quotes, double quotes, and backticks in MySQL 12 answers

Can someone help me understand this error?

Fatal error: Call to a member function bind_param() on a non-object in C:\MAMP\htdocs\MyCMS\insert_posttwo.php on line 64

<?php    

    $mysqli = mysqli_connect("localhost", "root", "root", "mycms");

    if (isset($_POST['submit'] )) {  
        $post_author    = $_POST['post_author'];

       $stmt = $mysqli->prepare ("INSERT INTO 'posts' ('post_author') VALUES(?)");

       $stmt->bind_param('s', $post_auth);

       $post_auth =     $post_author;
       $stmt->execute();


       echo "<script>alert('Post has been published')</script>";
       echo "<script>window.open('insert_post','_self')</script>";

       $stmt->close();

   }

?>

</div>

Answer 1

Instead of single quotes ' use backticks ` to escape field or table names .

$stmt = $mysqli->prepare ("INSERT INTO `posts` (`post_author`) VALUES(?)");