Download the PHP package faithfm/smart-search-php without Composer

smart-search-php

Simple (yet powerful) PHP search/filter providing unified results in multiple contexts:

• MySQL/other databases (ie: "where" clause builder)
• PHP arrays
• Laravel Collections
• Laravel Models
• Laravel Nova Resources

Simple Google-style search strings perform complex filter operations across multiple fields.

(PHP backend equivalent of miking/smart-search-filter javascript library JS library)

Screenshot:

Installation:

Require this package in the composer.json of your project.

Note: an additional dependency must be manually installed for Laravel Models & Nova Resources. (Applies to Laravel <= 8.x)

Usage Examples:

Start by creating an instance of SmartSearch with the search string, and a list of default search fields:

The parsed search-string can now be used to perform filtering in one or more contexts:

• Context 1 - PHP Array filtering:

• Context 2 - Laravel Collection filtering:

• Context 3 - SQL Database where-clause filtering:

• Context 4 - Laravel Database Query Builder (DB or Model) filtering:

• Context 5 - Laravel Eloquent Model filtering:

• Context 6 - Laravel Nova Resource filtering: (ie: as shown in the screenshot above)

Search Syntax:

The related miking/smart-search-filter javascript library includes documentation of how a simple Google-style search syntax is used to perform complex filter operations across multiple fields.

Note: Used together these two libraries provide a simple, unified, yet powerful approach to front-end/back-end filtering in modern web applications.

Debug Information:

Under the hood, a "filter operations" array is created when a search string is parsed.
The getFilterOpsDescription() function provides a human-readable representation showing the parsed intent of the search string, and parsing errors are also available:

Advanced Options:

The above examples have demonstrated the simple case where only two arguments are provided to the SmartSearch constructor, however a number of other advanced options are also available.

Notes:

• $allowedFields are the same as $defaultFields if not specified explicitly.

• Fields lists can be specified in a many different ways:

• The $options parameter accepts an associative array or StdClass object and allows things like case sensitivity and sql wildcard characters to be defined. Default options are:

Note: all filters are currently case-insensitive. The caseSensitive option does not currently work.

• The $sqlEscapeStringFn can be specified in the constructor instead of calling setSqlEscapeStringFn() later.