PHP-Web入門編4:Eloquentでデータベースを操作しよう

動作確認のため、print_r()で、取得したデータを出力する。

public_html/show_player.php

<?php

    require_once './vendor/autoload.php';
    $db = new Illuminate\Database\Capsule\Manager;
    $db->addConnection([
        'driver'    => 'mysql',
        'host'      => 'localhost',
        'database'  => 'mydb',
        'username'  => 'root',
        'password'  => ''
    ]);
    $db->setAsGlobal();
    $db->bootEloquent();

    use Illuminate\Database\Eloquent\Model;

    class Player extends Model {
        public $timestamps = false;
        public function job() {
            return $this->belongsTo('Job');
        }
    }

    class Job extends Model {
    }

    if(isset($_REQUEST['id'])) {
        $id = $_REQUEST['id'];
    }

    $player = Player::find($id);
	$message = 'This is paiza';
    // require_once 'views/index.tpl.php';
    print_r($player);

- Eloquent をおさらい - Qiita
https://qiita.com/shosho/items/5ca6bdb880b130260586

- Eloquent ORMについてなにも知らなかった（1） - 基本的な使い方編 - - zuckey blog
https://blog.zuckey17.org/entry/2018/01/14/214919

- Eloquent：利用の開始 5.6 Laravel
https://readouble.com/laravel/5.6/ja/eloquent.html

- Eloquent: Getting Started - Laravel - The PHP Framework For Web Artisans
https://laravel.com/docs/5.6/eloquent