PHPackages                             janfish/db-finder - 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. [Database & ORM](/categories/database)
4. /
5. janfish/db-finder

ActiveLibrary[Database & ORM](/categories/database)

janfish/db-finder
=================

DB Finder

15PHP

Since Jul 15Pushed 5y ago1 watchersCompare

[ Source](https://github.com/zeng444/DBDataFinder)[ Packagist](https://packagist.org/packages/janfish/db-finder)[ RSS](/packages/janfish-db-finder/feed)WikiDiscussions master Synced today

READMEChangelogDependenciesVersions (1)Used By (0)

JANFISH DATA FINDER
-------------------

[](#janfish-data-finder)

#### MAIN FEATURE

[](#main-feature)

```
$finderer = new Finder(Finder::MONGO_MODE);
//$finder = new Finder(Finder::MYSQL_MODE);
$finder->setConnection((Di::getDefault())->get('mongo'));
$finder->setAliasDirectives([
    Finder::EQUAL_DIRECTIVE => '='
]);
$finder->setSchema('insurance');
$finder->setTable('orderDraft');
$finder->defineAliasColumns([
    'id'=>'nid'
]);
$finder->defineFullTextColumns(['queryValue', 'engineNo', 'vin', 'accountNo']);
$finder->defineDateColumns(['createdAt', 'updatedAt', 'quotedAt', 'paidAt', 'insuredAt', 'startAt', 'endAt']);
$finder->setSort(['id' => 'ASC']);
$finder->setColumns(['adminId', '_id', 'createdAt','queryValue']);
//$finder->defineHideColumns(['_id']);
$finder->setPagination(0, 100);
$finder->setConditions([

     //SEARCH "=" OPERATION
    'id' => 1,
    'companyId' => ['eq' => 1],

    //SEARCH "!=" OPERATION
    'col3' => ["neq" => '2'],

    //SEARCH ">=" AND "="  OPERATION
    'col4' => ["gte" => '2'],

    //SEARCH ""  OPERATION
    'col7' => ["gt" => '2'],

    // SEARCH "