public static function SearchFull($query, $maxRows) { $conn = RPDatabase::createConnection(); $query = "%{$query}%"; $statement = $conn->prepare("SELECT\n `Room`.`Title`,\n `Room`.`ID`,\n `Room`.`Time_Created`,\n `Room`.`IP`,\n `Room`.`ID`,\n `Room`.`Number`,\n COUNT(*) AS `Found_Count`\n FROM `Message` LEFT JOIN `Room` ON (\n `Room`.`Number` = `Message`.`Room_Number`\n ) WHERE `Message`.`Content` LIKE ?\n GROUP BY `Room`.`ID`\n ORDER BY `Found_Count` DESC LIMIT {$maxRows}"); $statement->execute(array($query)); return $statement->fetchAll(); }
public function close() { RPDatabase::closeGracefully($this->db); }