So lernen Sie das Laravel-Framework in PHP (Anfänger)

  {
    "name": "laravel/laravel",
    "description": "The Laravel Framework.",
    "keywords": ["framework", "laravel"],
    "license": "MIT",
    "type": "project",
    "require": {
        "php": ">=5.5.9",
        "laravel/framework": "5.1.*"
    },
    "require-dev": {
        "fzaninotto/faker": "~1.4",
        "mockery/mockery": "0.9.*",
        "phpunit/phpunit": "~4.0",
        "phpspec/phpspec": "~2.1"
    },
    "autoload": {
        "classmap": [
            "database"
        ],
        "psr-4": {
            "App\\": "app/"
        }
    },
    "autoload-dev": {
        "classmap": [
            "tests/TestCase.php"
        ]
    },
    "scripts": {
        "post-install-cmd": [
            "php artisan clear-compiled",
            "php artisan optimize"
        ],
        "pre-update-cmd": [
            "php artisan clear-compiled"
        ],
        "post-update-cmd": [
            "php artisan optimize"
        ],
        "post-root-package-install": [
            "php -r \"copy('.env.example', '.env');\""
        ],
        "post-create-project-cmd": [
            "php artisan key:generate"
        ]
    },
    "config": {
        "preferred-install": "dist"
    },
    "repositories": [
        {"type": "composer", "url": "http://packagist.phpcomposer.com"},
        {"packagist": false}
    ]
}```

'mysql' => array(
'driver'    => 'mysql',
'host'      => 'localhost',
'database'  => 'oss',
'username'  => 'root',
'password'  => '',
'charset'   => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix'    => '',
)

<?php
use Illuminate\Auth\UserTrait;
use Illuminate\Auth\UserInterface;
use Illuminate\Auth\Reminders\RemindableTrait;
use Illuminate\Auth\Reminders\RemindableInterface;
class User extends Eloquent implements UserInterface, RemindableInterface {
    use UserTrait, RemindableTrait;
    /**
     * The database table used by the model.
     *
     * @var string
     */
    protected $table = &#39;users&#39;;
    /**
     * The attributes excluded from the model&#39;s JSON form.
     *
     * @var array
     */
    protected $hidden = array(&#39;password&#39;, &#39;remember_token&#39;);
}

DB::table(‘tablename’)->insert([
        插入多个时要再加一个数组
        ['title'=>'title','name'=>'name']
        ['title'=>'title']
        ['title'=>'title']
        ])
        插入时要想得到ID
        DB::table('tablename')->insertGetId(['title'=>'titles'])
        更新数据要有ID
        DB::table('tablename')->where('id',1)->update(['title'=>'titles'])
        删除数据
        DB::table('tablename')->where('id',1)->delete();
        查询数据
        DB::table('tablename')->get();  得到全部的值
        DB::table('tablename')->get(['title']); 只查询title的值
        DB::table('tablename')->first();  只拿第一个
        DB::table('tablename')->orderBy('id','desc')->first(); 根据id排序
        DB::table('tablename')->where('id','!=',2)->get(); 不等于2
        DB::table('tablename')->where('id','!=',2)->where('id','>',5)->get(); 可以使用多个where
        DB::table('tablename')->where('id','!=',2)->OrWhere('id','>',5)->get(); 或者
        DB::table('tablename')->whereBetween('id',[2,5])->get();  闭包之间
        DB::table('tablename')->whereIn('id',[2,5,9])->get();
        DB::table('tablename')->whereNotIn('id',[2,5,9])->get();
        DB::table('tablename')->whereNull('id')->get();  为空的话就可以查询出来
        DB::table('tablename')->take(3)->get();  只查询3个
        DB::table('tablename')->limit(3)->get();  只查询3个
        DB::table('tablename')->skip(2)->take(3)->get();  只查询3个跳过第二个
        DB::table('tablename')->where('id','!=',2)->pluck('title'); 只返回它的title
        DB::table('tablename')->count();  有多少条记录
        DB::table('tablename')->max('id');
        DB::table('tablename')->min('id');
        DB::table('tablename')->avg('id');
        DB::table('tablename')->sum('id');

public function comment(){ return $this->hasMany('Comment','post_id') }
 正向关联   一对多   一对一是hasOne

public function post(){ return $this->belongsTo('Post','post_id') }
  反向关联

    Post::find(2)->comment  就可以得到Comment这张表的内容   //这样查询一个是可以的  查询多个就要设置预载入
            查询多个
                Post::with('comment')->get();
                Post::with(['comment'=>function($query){$query->where('id','>',2)}])->get();  加条件