$stmt->get_result error 500

[NoiiiD]

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();

 

[Jacques1]

The get_result() method is only available for the MySQL native driver (which your server appearently doesn't have). You either have to change the PHP installation or fetch the data with the classical bind_result/fetch.

 

By the way, remove this filter_input() stuff. It will damage the incoming data and serves no purpose whatsoever.

 

 

[NoiiiD]

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

[Jacques1]

What do you mean? What's the problem?