CakePHP3のお勉強：ブログチュートリアルを一発でBake

$ su -
Password:
# cd /var/www/
# composer create-project --prefer-dist cakephp/app cake_blog

# まず、articles テーブルを作成します
CREATE TABLE articles (
    id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(50),
    body TEXT,
    created DATETIME DEFAULT NULL,
    modified DATETIME DEFAULT NULL
);
 
# それから、テスト用に記事をいくつか入れておきます
INSERT INTO articles (title,body,created)
    VALUES ('タイトル', 'これは、記事の本文です。', NOW());
INSERT INTO articles (title,body,created)
    VALUES ('またタイトル', 'そこに本文が続きます。', NOW());
INSERT INTO articles (title,body,created)
    VALUES ('タイトルの逆襲', 'こりゃ本当にわくわくする！うそ。', NOW());

# cd /var/www/cake_blog/
# nano config/app.php

• 「’username’」「’password’」「’database’」を作成したデータベースの内容に変更。

  /*
  * CakePHP will use the default DB port based on the driver selected
  * MySQL on MAMP uses port 8889, MAMP users will want to uncomment
  * the following line and set the port accordingly
  */
  //'port' => 'non_standard_port_number',
  'username' => 'my_app',
  'password' => 'secret',
  'database' => 'my_app',
  

# cd /etc/nginx/conf.d/
# nano default.conf (または https.conf)

# systemctl restart nginx.service

# bin/cake bake all articles
:
Creating file /var/www/cake_blog/src/Model/Table/ArticlesTable.php
:
Creating file /var/www/cake_blog/src/Model/Entity/Article.php
:
Creating file /var/www/cake_blog/tests/Fixture/ArticlesFixture.php
:
Creating file /var/www/cake_blog/tests/TestCase/Model/Table/ArticlesTableTest.php
:
Creating file /var/www/cake_blog/src/Controller/ArticlesController.php
:
Creating file /var/www/cake_blog/tests/TestCase/Controller/ArticlesControllerTest.php
:
Creating file /var/www/cake_blog/src/Template/Articles/index.ctp
:
Creating file /var/www/cake_blog/src/Template/Articles/view.ctp
:
Creating file /var/www/cake_blog/src/Template/Articles/add.ctp
:
Creating file /var/www/cake_blog/src/Template/Articles/edit.ctp
:
Bake All complete.

# cd /var/www/cake_blog
# nano config/routes.php

• $routes->connect(…)の記述を以下に変更。

  // コメントアウト
  //$routes->connect('/', ['controller' => 'Pages', 'action' => 'display', 'home']);
  $routes->connect('/', ['controller' => 'Articles', 'action' => 'index']);
  

# systemctl restart nginx.service