[$stmt->get_result error 500]

I tried what you said and it works. Thank you very much. BTW, how should I handle strings with quotes?

[$stmt->get_result error 500]

Im having trouble on my php script. it is working on my computer but when I put it in x10hosting it fails and gives an error 500.  I tried tracing the problem and I found out that it happens if I call get_result. Here is the part code:

 

 

$username = strtolower(filter_input(INPUT_POST, 'username'));
  $password = filter_input(INPUT_POST, "password");
  $remember = filter_input(INPUT_POST, "remember");
  $result = array();
  include 'Connection.php';
  $query = "SELECT Number, Username, Password, Alias, Level FROM user WHERE Username = ?;";
  $stmt = $conn->prepare($query);
if(!$stmt->prepare($query))
{
    die( "Failed to prepare statement.");
}
  $stmt->bind_param("s", $username);

  $stmt->execute();
  echo $stmt->error;

//error hapens here
  $selectResult = $stmt->get_result();