<?php

class Search_Engine {

    public function search(){
        if(isset($_POST['search'])) {
            $searchq = $_POST['search'];
            $searchq = preg_replace ("#[^0-9a-z]#i","",$searchq);
            $sql = "SELECT * FROM users WHERE username LIKE :ls or password LIKE :searchq or content LIKE :l";
            $stmt = $conn->prepare($sql);
            $stmt->execute();
            $count = $stmt->rowCount();
            if($count == 0) {
                $output = '<tr><tr>Nessun risultato trovato.</tr></td>';
            } else {
                while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
                    $Username = $row['username'];
                    $password = $row['password'];

                    $output .= '<tr><td><p>' .$username.'</p>';
                }
            }
                 return $output;
        }
    }

}