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