用惯了laravel Illuminate Database数据库组件,维护公司的老CMS系统,也把laravel 的 ORM整理过来使用。
简单使用过程:
- 新建composer.json文件。
{
"require": {
"illuminate/database": "^8.12"
}
}
- 安装composer包
composer install
- 新增一个index.php
<?php
use Illuminate\Database\Capsule\Manager as DB;
require 'vendor/autoload.php';
require 'UserModel.php';
$capsule = new DB;
$capsule->addConnection([
'driver' => 'mysql',
'host' => '127.0.0.1',
'database' => 'test',
'username' => 'root',
'password' => 'root',
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => '',
]);
$capsule->setAsGlobal();
$capsule->bootEloquent();
$result = DB::table('users')->select('*')->first();
$result = UserModel::first();
print_r($result);
- 新增一个Model文件UserModel.php
<?php
use Illuminate\Database\Eloquent\Model;
class UserModel extends Model
{
protected $table = 'users';
}
- 访问index.php文件。即可通过laravel的ORM组件直接访问数据库