1、连接数据库
Laravel中数据库配置文件为config/database.php,打开该文件,默认内容如下:
<?php
return [
//默认返回结果集为PHP对象实例
//具体返回结果可参考PDO.php(php PDO文档)
// 数组格式 FETCH_ASSOC
'fetch' => PDO::FETCH_CLASS,
//默认数据库连接为mysql,可以在.env文件中修改DB_CONNECTION的值
'default' => env('DB_CONNECTION', 'mysql'),
'connections' => [
//sqlite数据库相关配置
'sqlite' => [
'driver' => 'sqlite',
'database' => storage_path('database.sqlite'),
'prefix' => '',
],
//mysql数据库相关配置
'mysql' => [
'driver' => 'mysql',
'host' => env('DB_HOST', 'localhost'),
'database' => env('DB_DATABASE', 'forge'),
'username' => env('DB_USERNAME', 'forge'),
'password' => env('DB_PASSWORD', ''),
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => '',
'strict' => false,
],
//Postgres数据库相关配置
'pgsql' => [
'driver' => 'pgsql',
'host' => env('DB_HOST', 'localhost'),
'database' => env('DB_DATABASE', 'forge'),
'username&