PHPackages                             nutter-nut/mongodb-sqlquery - 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. nutter-nut/mongodb-sqlquery

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

nutter-nut/mongodb-sqlquery
===========================

Mongodb using SQL style

v1.0.1(5y ago)07MITPHPPHP >=7.2.0

Since Jun 30Pushed 5y ago2 watchersCompare

[ Source](https://github.com/nutter-nut/mongodb-sqlquery)[ Packagist](https://packagist.org/packages/nutter-nut/mongodb-sqlquery)[ Docs](https://github.com/nutter-nut/mongodb-sqlquery)[ RSS](/packages/nutter-nut-mongodb-sqlquery/feed)WikiDiscussions master Synced 1mo ago

READMEChangelog (2)Dependencies (1)Versions (3)Used By (0)

mongodb-sql-style
=================

[](#mongodb-sql-style)

Mongodb using SQL style

- Configuraton add setting in config/database.php of laravel

```
'mongodb' => [
    'driver' => 'mongodb',
    'host' => env('MONGO_DB_HOST', '127.0.0.1'),
    'port' => env('MONGO_MONGO_DB_PORT', 27017),
    'database' => env('MONGO_DB_DATABASE', 'marcompany'),
    'username' => env('MONGO_MONGO_DB_USERNAME', 'maradmin'),
    'password' => env('MONGO_DB_PASSWORD', 'password'),
    'options' => [
        'database' => env('DB_AUTHENTICATION_DATABASE', 'admin'),
    ],
],

```

---

- Using Laravel for SQL query style example below
    - Create Model - using command ` php artisan make:model UserDbModel` at laravel root project and insert `use Nantaburi\Mongodb\MongoNativeDriver\Model  ` on top

```

use Nantaburi\Mongodb\MongoNativeDriver\Model

class UserDbModel  extends Model {

    protected $collection = "users" ;
    protected $database = "marcompany" ;

}

```

- Create Laravel controller
    - using command ` php artisan make:controller --model=Userdatabase` at laravel root project
    - then edit and insert basic SQL example : `select * from user where  username like 'suphacha%' and age > 18 or mooban = 'Pangpoi' ;`
    - using SQL transform showing below :

```
use App\UserDbModel ;

   $users= UserDbModel::query()
                         ->where("username" , "like" , "suphacha%" )
                         ->andwhere("age" ,">", 18)
                         ->orwhere("mooban" ,"=" ,"Pangpoi" )
                         ->get() ;

   return view('userlist')->with("users",$users) ;

```

- insert Data to collection
- Model file in app/UserModel.php

```