PHP框架怎么连接数据库_PHP框架数据库连接配置与ORM使用指南

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=my_database
DB_USERNAME=root
DB_PASSWORD=password

DATABASE_URL="mysql://db_user:db_password@127.0.0.1:3306/my_database"

$db['default'] = array(
    'dsn'   => '',
    'hostname' => 'localhost',
    'username' => 'root',
    'password' => '',
    'database' => 'my_database',
    'dbdriver' => 'mysqli',
);

// 查询所有用户
$users = User::all();

// 查询单条记录
$user = User::find(1);

// 插入数据
User::create(['name' => 'John', 'email' => 'john@example.com']);

// 更新数据
$user = User::find(1);
$user->name = 'Jane';
$user->save();

// 获取实体管理器
$em = $this->getDoctrine()->getManager();

// 查询
$user = $em->getRepository(User::class)->find(1);

// 插入
$user = new User();
$user->setName('John');
$em->persist($user);
$em->flush();

$users = $this->db->get('users')->result();
$this->db->insert('users', $data);
$this->db->where('id', 1)->update('users', $data);