數(shù)據(jù)庫(kù)操作之-DB facade
- 新建數(shù)據(jù)表與連接數(shù)據(jù)庫(kù)
- 使用DB facade實(shí)現(xiàn)CURD
創(chuàng)建數(shù)據(jù)表
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL COMMENT '姓名',
`age` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '年齡',
`sex` tinyint(3) unsigned NOT NULL DEFAULT '10' COMMENT '性別',
`created_at` int(11) NOT NULL DEFAULT '0' COMMENT '新增時(shí)間',
`update_at` int(11) NOT NULL DEFAULT '0' COMMENT '修改時(shí)間',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1001 DEFAULT CHARSET=utf8;
連接數(shù)據(jù)庫(kù)
數(shù)據(jù)庫(kù)配置文件路徑laravel\config\database.php
//默認(rèn)選擇數(shù)據(jù)庫(kù)
'default' => env('DB_CONNECTION', '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,
'engine' => null,
],
更改數(shù)據(jù)庫(kù)配置文件
env對(duì)應(yīng)文件路徑laravel\ .env
DB_HOST=localhost
DB_DATABASE=laravel
DB_USERNAME=root
DB_PASSWORD=root
- 使用DB facade實(shí)現(xiàn)CURD
- 新建StudentController.php控制器案站，代碼如下
文件所在位置laravel\app\Http\Controllers\StudentController.php
<?php
namespace App\Http\Controllers;
use Illuminate\Support\Facades\DB;
class StudentController extends Controller
{
public function test1()
{
$students = DB::select('select * from student');
var_dump($students);
}
}
配置路由宙址，代碼如下
文件所在位置laravel\app\Http\routes.php
Route::get('test1',['uses'=>'StudentController@test1']);
瀏覽器地址欄 http://localhost:8090/laravel/public/test1
頁(yè)面輸出：array(0) { }
說(shuō)明數(shù)據(jù)庫(kù)連接成功酿愧。
