一、数据库端
(1)配置 mysql 数据库,统一字符集
/* my.ini */
[mysqld]
default_authentication_plugin=mysql_native_password
port = 3308
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
(2)开启 mysql 服务
https://blog.csdn.net/weixin_41565755/article/details/107829339
(3)创建表
mysql -u root -p # 登录 root 账户
alter user 'root'@'localhost' identified by '123'; # 修改 root 密码
show databases; # 列出所有数据库
use db0806; # 进入数据库
show tables; # 列出所有表
# 创建 persion 表
CREATE TABLE persion (
name varchar(32),
age int(32),
sex char(1),
birthday date,
);
# 查看 persion 表
select * from persion;
二、laravel 端
(1)在 .env 中修改数据库参数
#DB_CONNECTION=mysql
#DB_HOST=127.0.0.1
#DB_PORT=3306
#DB_DATABASE=homestead
#DB_USERNAME=homestead
#DB_PASSWORD=secret
DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3308
DB_DATABASE=db0806
DB_USERNAME=root
DB_PASSWORD=123
(2)在 config/database.php 中找到
'mysql' => [
'driver' => 'mysql',
'host' => env('DB_HOST', '127.0.0.1'),
'port' => env('DB_PORT', '3306'),
'database' => env('DB_DATABASE', 'forge'),
'username' => env('DB_USERNAME', 'forge'),
'password' => env('DB_PASSWORD', ''),
'unix_socket' => env('DB_SOCKET', ''),
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
'prefix' => '',
'strict' => true,
'engine' => null,
],
将 ’strict‘ => 'true' 改为 ’strict‘ => 'false' ,不严格。
(3)简单的操作数据库,通过 DB 门面
在 myproject\app\Http\Controllers 下新建 Home 文件夹,然后在 myproject 下执行下面命令在 Home 下创建控制器 IndexController:
php artisan make:controller Home/IndexController # 在 Home/Controllers 目录下创建控制器
路由代码:
/* web.php */
Route::get('home/index/task', 'Home\IndexController@task');
Route::get('home/index/add', 'Home\IndexController@add');
控制器代码:
/* Home\IndexController.php */
<?php
namespace App\Http\Controllers\Home;
use Illuminate\Http\Request;
use App\Http\Controllers\Controller;
use DB;
class IndexController extends Controller
{
//
public function task() {
echo "hello";
}
public function add() {
$db = DB::table('persion');
//*
$result = $db -> insert(
[
'name' => 'tom1',
'age' => '21',
'sex' => 'man',
'birthday' => '1999-07-01'
]
);
//*/
dd($result);
echo "hello DB";
}
}
(4)开启 laravel 服务
php artisan serve
(5)网页访问
http://localhost:8000/home/index/add