PHP search Using multiple Criteria submitted from a form. : $query = "SELECT * FROM student WHERE idStudent = ? AND Student_Fname = ? AND Student_Sname = ? AND Program_idProgram = ? AND Class_idClass = ?";
        
        $stmt = mysqli_prepare($dbc, $query);
        
        mysqli_stmt_bind_param($stmt, 'sssss', $idStudent,
                               $Student_Fname, $Student_Sname, $Program_idProgram, $Class_idClass);
        
        mysqli_stmt_execute($stmt);
        
        $result = @mysqli_query($dbc, $query);

        if($result){  // display results here} 