-
Notifications
You must be signed in to change notification settings - Fork 0
tutorial
Joe Huss edited this page Nov 10, 2022
·
1 revision
webmanThe database defaults to using illuminate/database,is alsolaravelmost,Usage withlaravelsame。
Of course you can refer toUsageThis feature is disabled by defaultChapterUsageThinkPHPor other databases。
composer require -W psr/container ^1.1.1 illuminate/database illuminate/pagination illuminate/events symfony/var-dumper
hint If you don't need paging, database events, or printing SQL, then just execute
composer require -W psr/container ^1.1.1 illuminate/database
config/database.php
return [
// Default database
'default' => 'mysql',
// Various database configurations
'connections' => [
'mysql' => [
'driver' => 'mysql',
'host' => '127.0.0.1',
'port' => 3306,
'database' => 'test',
'username' => 'root',
'password' => '',
'unix_socket' => '',
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => '',
'strict' => true,
'engine' => null,
'options' => [
\PDO::ATTR_TIMEOUT => 3
]
],
],
];<?php
namespace app\controller;
use support\Request;
use support\Db;
class UserController
{
public function db(Request $request)
{
$default_uid = 29;
$uid = $request->get('uid', $default_uid);
$name = Db::table('users')->where('uid', $uid)->value('username');
return response("hello $name");
}
}