PHPackages basharqarat/simsearch - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Search & Filtering](/categories/search) 4. / 5. basharqarat/simsearch ActiveLibrary[Search & Filtering](/categories/search) basharqarat/simsearch ===================== v1.0.0(3y ago)0168PHP Since May 15Pushed 1y ago1 watchersCompare [ Source](https://github.com/BasharQarat/simsearch)[ Packagist](https://packagist.org/packages/basharqarat/simsearch)[ RSS](/packages/basharqarat-simsearch/feed)WikiDiscussions master Synced 3w ago READMEChangelog (1)DependenciesVersions (3)Used By (0) Simsearch ========= [](#simsearch) dynamic simple search Installation ------------ [](#installation) composer require basharqarat/simsearch Usage ----- [](#usage) lets talk about the function signature and response ``` Model::search($var1,$var2,$var3,$var4); ``` $var1(required) : is the string we searching about it . $var2(optional) : is array of relations models we want to search in it too ,and if it empty => the function will ignore it. $var3(optional) : is array of strings (if we want to search in defined columns) ,adn if it empty => the function will ignore it. $var4(optional) : is array and keys of expressions response : collection of model data ,or empty array. usage in model ============== [](#usage-in-model) after the Installation. in your models you want to search in it: ``` use BasharQarat\Simsearch\Traits\Searchable; class User extends Authenticatable { use Searchable; public $mySearchableFields = [ 'name', 'fname', 'lname', 'phone_code', 'phone_number' 'email', ]; /** * return array */ public function getSearchableFields(){ return array_merge($this->mySearchableFields, [ \DB::raw('CONCAT(phone_code," ",phone_number)'), \DB::raw('CONCAT(fname," ",lname)') ]; ); } } ``` 1- use the Searchable Traits. 2- add $mySearchableFields array and put inside it your columns name you want to search dynamically on It. 3- if you want to use expressions in with your fields like(concat(fname,'',lname)) so you should use the getSearchableFields() function in your model like the previuos 4- now you can use it in your code. logic ===== [](#logic) search in same model ==================== [](#search-in-same-model) after the initiallizing a model. 1- this will search in the user model in all columns inside $mySearchableFields array ``` User::search($search_key) ->get(); ``` but what if i want to search in defined column every time ? you can do this the below . 2- this will search in the user model in name column and ignored the $mySearchableFields ``` User::search($search_key,[],['name',...]) ->get(); ``` 3- if you want to use expressios in defined query you should use unique doesnt declared in your model name in fields array like(full\_name) and pass the expressions array parameter and declare the same name of the new declared name as key and the value its the expression ``` User::search($search_key,[],['full_name'],['full_name'=>\DB::raw('CONCAT(fname," ",lname)')]) ->get(); ``` search in relations too ======================= [](#search-in-relations-too) first you should have the relations functions in your models and use the searchable trait in all models you want to search in it. ``` class User extends Authenticatable { use Searchable; public $mySearchableFields = [ 'name', 'email', ]; public function UserTypes(){ return $this->hasMany('App\Models\UserType'); } } class UserType extends Model { use Searchable; public $mySearchableFields = [ 'type', ]; public function User(){ return $this->belongsTo('App\Models\User'); } } ``` and then you can use it like : 1- search in the User model and in his related UserTypes records ``` User::search($search_key,['UserTypes']) ->get(); ``` 2- search in defined columns in the relations ``` User::search($search_key,['UserTypes:type']) ->get(); ``` and also we still can search in defined column from the user model too ``` User::search($search_key,['UserTypes:type'],['name']) ->get(); ``` or we can write it in this way: ``` User::search($search_key,[],['name','UserTypes.type']) ->get(); ``` what if we want more than one defined column? so ... ``` User::search($search_key,['UserTypes:type,id']) ->get(); ``` or ``` User::search($search_key,[],['name','UserTypes.[type,id]']) ->get(); ``` (when we want to put relation in same model fileds array must being in that way \[for defined columns\] ) in nested relations =================== [](#in-nested-relations) what if you want to search in nested relations and pass from one model to another? so.. 1- this will search in User model and UserTypes model and RelationNameRelatedToUserTypeModel model depends on the name column in user model and $mySearchableFields array in other models of them. (but in this way should the User model have UserTypes() function and UserType model should have inside it RelationNameRelatedToUserTypeModel() function ) ``` User::search($search_key,['UserTypes.RelationNameRelatedToUserTypeModel'],['name']) ->get(); ``` 2- as same for this one: ``` User::search($search_key,['UserTypes.RelationNameRelatedToUserTypeModel.AnotherOneRelated_to_the_previous_RelationNameRelatedToUserTypeModel'],['name']) ->get(); ``` 3- if you want to search in 2 relations or more are related to the same model ``` User::search($search_key,['UserTypes'=>['firstRelationRelatedToUserTypesModel','secondRelationRelatedToUserTypesModel',..]]) ->get(); ``` and we still use defined columns with all the AnotherOneRelated\_to\_the\_previous\_RelationNameRelatedToUserTypeModel: ``` User::search($search_key,['UserTypes:type'=>['firstRelationRelatedToUserTypesModel:firstColumnName,secondColumnName','secondRelationRelatedToUserTypesModel',..]]) ->get(); ``` 4- we can use the 2 types of nested relations together ``` User::search($search_key,['UserTypes.RelationInsideUserTypes'=>['firstRelationRelatedToRelationInsideUserTypesModel','secondRelationRelatedToRelationInsideUserTypesModel',..]]) ->get(); ``` \#note we can use the expressions with the relation too in all the previuos states ``` User::search($search_key,['UserTypes:expression_name'],[],['expression_name'=>\DB::raw('any expression here...')]) ->get(); ``` Support ------- [](#support) contact at ### Health Score 27 — LowBetter than 47% of packages Maintenance34 Infrequent updates — may be unmaintained Popularity13 Limited adoption so far Community7 Small or concentrated contributor base Maturity46 Maturing project, gaining track record Bus Factor1 Top contributor holds 100% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Unknown Total 1 Last Release 1136d ago ### Community Maintainers ![](https://www.gravatar.com/avatar/ec8afa91553e6a6b18fadc2401284cfc89699e037344868885a888ed77913cdb?d=identicon)[Bashar Qarat](/maintainers/Bashar%20Qarat) --- Top Contributors [![BasharQarat](https://avatars.githubusercontent.com/u/76533862?v=4)](https://github.com/BasharQarat "BasharQarat (14 commits)") ### Embed Badge ![Health badge](/badges/basharqarat-simsearch/health.svg) ``` [![Health](https://phpackages.com/badges/basharqarat-simsearch/health.svg)](https://phpackages.com/packages/basharqarat-simsearch) ``` ### Alternatives [ircmaxell/filterus A library for filtering variables in PHP 44613.4k6](/packages/ircmaxell-filterus)[awesome-nova/dependent-filter Dependent filters for Laravel Nova 26190.2k](/packages/awesome-nova-dependent-filter) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)