php kodning

Class MySearchClass {

    public function __construct(PDO $conn) {
        $this->pdo=$dbc;  
    }

    public function search_name($keyword){

        $query = "SELECT * FROM players WHERE name = '$keyword' OR WHERE playerid = '$keyword'";  
        $result = $this->pdo->prepare($query);  
        $result ->execute();  

        return $result;
    }

    public function view_all(){
        $query = "SELECT * FROM players";  
        $result = $this->pdo->prepare($query);  
        $result ->execute();  

        return $result;
    } 
}