UPDATE:
I have a couple of errors and warnings I need help with in mysqli:
Fatal error: Call to undefined method mysqli_stmt::get_result() in ... on line 63
In my code below does anyone know how these warnings and errors can be dealt with?
$query = "SELECT * FROM Teacher WHERE TeacherAlias = ?";
// prepare query
$stmt=$mysqli->prepare($query);
// You only need to call bind_param once
$stmt->bind_param("s",$getid);
// execute query
$stmt->execute();
//get results
$result = $stmt->get_result();
$numrows = mysqli_num_rows($result);
if ($numrows == 0){
// don't use $mysqli->prepare here
$query = "SELECT * FROM Teacher WHERE TeacherUsername = ?";
// prepare query
$stmt=$mysqli->prepare($query);
// You only need to call bind_param once
$stmt->bind_param("s",$getuser);
// execute query
$stmt->execute();
}