致命错误：在非对象上调用成员函数execute（）

Question

I have a problem with the execute(): Fatal error: Call to a member function execute() on a non-object I seem to have used it correctly, I looked up other questions here on StackOverflow and I think it is just right.

  $db = dbConnect();
  $query = "SELECT * FROM 'users' WHERE 'username' = '".$username."'";
  $stmt = $db->prepare($query);
  $stmt->execute();

Where dbConnect() is the function:

  function dbConnect() {
      $db = mysqli_connect("localhost", "root", "example", "dbexample")
          or die("Errore nella connessione al db: " . mysqli_connect_error());
      return $db;
  }

Thanks

Answer 1

Please use this:

$query = "SELECT * FROM `users` WHERE 'username' = '".$username."'";

instead of:

$query = "SELECT * FROM 'users' WHERE 'username' = '".$username."'";