Laravel基础（二）--连接数据库

mysql下建立数据库、表、字段

# Host: localhost  (Version: 5.5.53)
# Date: 2018-03-16 21:30:43
# Generator: MySQL-Front 5.3  (Build 4.234)

/*!40101 SET NAMES utf8 */;

#
# Structure for table "kcb"
#

DROP TABLE IF EXISTS `kcb`;
CREATE TABLE `kcb` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `branch` tinyint(3) DEFAULT NULL COMMENT '学部：1职大2沈药3电大4北医5培训',
  `class` varchar(255) DEFAULT NULL COMMENT '班级',
  `course` varchar(255) DEFAULT NULL COMMENT '课程',
  `datetime` int(11) DEFAULT '0' COMMENT '日期时间',
  `heban` tinyint(3) DEFAULT '0' COMMENT '合班：合班的课程生成同样的随机数',
  `status` tinyint(3) DEFAULT '0' COMMENT '状态：表示是否提交、验证、发布',
  `created_at` int(11) DEFAULT '0' COMMENT '创建时间',
  `updated_at` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='课程表';

#
# Data for table "kcb"
#

INSERT INTO `kcb` VALUES (1,1,'17春药学','药理学',0,NULL,NULL,0,0);

phpstorm中laravel 数据库设置

config/database.php中确认默认数据库为mysql

'default' => env('DB_CONNECTION', 'mysql'),

设置数据库host

        'mysql' => [
            'driver' => 'mysql',
            'host' => env('DB_HOST', 'localhost'),

.env中设置数据连接字符串

DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=laravel
DB_USERNAME=root
DB_PASSWORD=root

Laravel中的MVC准备工作

新建Model文件Kcb.php

<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
class Kcb extends model
{
//  指定表名
    protected $table = 'kcb';
//    指定主键
    protected $primaryKey = 'id';
}

新建Controller文件Http/Controllers/KcbController.php

<?php
namespace App\Http\Controllers;
use App\Kcb;
use Illuminate\Support\Facades\DB;
class KcbController extends Controller
{
    public function ormselect()
    {
        //all()
        $kcbs = Kcb::all();
        dd($kcbs);
    }
}

routes/web.php添加ormselect路由

<?php
Route::get('/', function () {
    return view('welcome');
});
Route::any('ormselect',['uses' => 'KcbController@ormselect']);

访问http://localhost/laravel56/public/ormselect

Collection {#450 ▼
  #items: array:1 [▼
    0 => Kcb {#448 ▼
      #table: "kcb"
      #primaryKey: "id"
      #connection: "mysql"
      #keyType: "int"
      +incrementing: true
      #with: []
      #withCount: []
      #perPage: 15
      +exists: true
      +wasRecentlyCreated: false
      #attributes: array:9 [▼
        "id" => 1
        "branch" => 1
        "class" => "17春药学"
        "course" => "药理学"
        "datetime" => 0
        "heban" => null
        "status" => null
        "created_at" => 0
        "updated_at" => 0
      ]
      #original: array:9 [▶]
      #changes: []
      #casts: []
      #dates: []
      #dateFormat: null
      #appends: []
      #dispatchesEvents: []
      #observables: []
      #relations: []
      #touches: []
      +timestamps: true
      #hidden: []
      #visible: []
      #fillable: []
      #guarded: array:1 [▶]
    }
  ]
}