非框架内使用 ORM
composer.json
{
"require": {
"php": "^7.3",
"ext-curl": "*",
"ext-json": "*",
"ext-openssl": "*",
"ext-pdo": "*",
"ext-redis": "*",
"guzzlehttp/guzzle": "~7.0",
"laravel/lumen-framework": "~8.0",
"millionmile/get_env": "~1.0"
},
"config": {
"sort-packages": true
}
}
定义一个 DB 方法
use Illuminate\Database\Capsule\Manager as Capsule;
use MillionMile\GetEnv\Env;
function bootDB()
{
$capsule = new Capsule();
$capsule->addConnection([
'driver' => 'mysql',
'host' => Env::get('DB_HOST'),
'port' => Env::get('DB_PORT'),
'database' => Env::get('DB_DATABASE'),
'username' => Env::get('DB_USERNAME'),
'password' => Env::get('DB_PASSWORD'),
'charset' => Env::get('DB_CHARSET'),
]);
$capsule->setAsGlobal();
$capsule->bootEloquent();
}
在任意地方使用
use Illuminate\Database\Capsule\Manager as DB;
bootDB();
$list = DB::table('table')->where('where', '')->limit(5)->distinct()->pluck('oid')->toArray();
dump($list);
本作品采用《CC 协议》,转载必须注明作者和本文链接
推荐文章: