This package creates a MySQL fulltext index for models and enables you to search through those.

1. Install with composer composer require swisnl/laravel-fulltext.
2. Publish migrations and config php artisan vendor:publish --tag=laravel-fulltext
3. Migrate the database php artisan migrate

The package uses a model observer to update the index when models change. If you want to run a full index you can use the console commands.

Add the Indexable trait to the model you want to have indexed and define the columns you'd like to index as title and content.

class Country extends Model
{

    use \Swis\Laravel\Fulltext\Indexable;

    protected $indexContentColumns = ['biographies.name', 'political_situation', 'elections'];
    protected $indexTitleColumns = ['name', 'governmental_type'];

}

You can use a dot notitation to query relationships for the model, like biographies.name.

You can search using the Search class.

$search = new \Swis\Laravel\Fulltext\Search();
$search->run('europe');

This will return a Collection of \Swis\Laravel\Fulltext\IndexedRecord which contain the models in the Polymorphic relation indexable.

If you only want to search a certain model you can use $search->runForClass('europe', Country::class);. This will only return results from that model.

Index all models for a certain class

 php artisan  laravel-fulltext:all
 
Usage:
  laravel-fulltext:all <model_class>

Arguments:
  model_class           Classname of the model to index

php artisan laravel-fulltext:all \\App\\Models\\Country

Usage:
  laravel-fulltext:one <model_class> <id>

Arguments:
  model_class           Classname of the model to index
  id                    ID of the model to index

php artisan laravel-fulltext:one \\App\\Models\\Country 4

Choose the database connection to use, defaults to the default database connection. When you are NOT using the default database connection, this MUST be set before running the migration to work correctly.

Results on title or content are weighted in the results. Search result score is multiplied by the weight in this config

Enable wildcard after words. So when searching for for example car it will also match carbon.

Please see CHANGELOG for more information on what has changed recently.

$ composer test

Please see CONTRIBUTING and CODE_OF_CONDUCT for details.

If you discover any security related issues, please email [email protected] instead of using the issue tracker.

• Björn Brala
• All Contributors

The MIT License (MIT). Please see License File for more information.

SWIS is a web agency from Leiden, the Netherlands. We love working with open source software.