Slim 3 Framework でMySQLとテンプレつかってみる。その２ ref: https://qiita.com/murachi1208/items/bef385f76d055388179f

book_api.phtml

<table class="pure-table">
  <tr>
    <th>id</th>
    <th>title</th>
    <th>name</th>
  </tr>
<?php foreach($data['books'] as $test): ?>
  <tr>
    <td><?=$test['id'] ?></td>
    <td><?=$test['title'] ?></td>
    <td><?=$test['name'] ?></td>
  </tr>
<?php endforeach; ?>
</table>

dependencies.php

// MySQL
$container['db'] = function ($c) {
    $settings = $c->get('settings')['db'];
    $pdo = new PDO("mysql:host=" . $settings['host'] . ";dbname=" . $settings['dbname'] . ";port=" . $settings['port'],
        $settings['user'], $settings['pass']);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
    return $pdo;
};

file0.txt

sudo yum --enablerepo=epel,remi,remi-php70 install php70 php70-php-mcrypt php70-php-mbstring php70-php-fpm php70-php-gd php70-php-pecl-xdebug php70-php-pecl-redis php70-php-pecl-imagick-devel php70-php-pecl-imagick php70-php-mysqlnd php70-php-intl php70-php-bcmath php70-php-pecl-zip php70-php-xmlrpc php70-php-xml  php70-php-pecl-http php70-php-pecl-http-devel php70-php-opcache phpunit

file1.txt

$ composer create-project slim/slim-skeleton slim3

file11.txt

array(3) { [0]=> array(4) { ["id"]=> string(1) "1" ["title"]=> string(15) "双子の帝國" ["name"]=> string(24) "ふたごのていこく" ["price"]=> string(3) "300" } [1]=> array(4) { ["id"]=> string(1) "2" ["title"]=> string(15) "進撃の巨人" ["name"]=> string(7) "singeki" ["price"]=> string(3) "500" } [2]=> array(4) { ["id"]=> string(1) "3" ["title"]=> string(21) "となりの関くん" ["name"]=> string(24) "となりのせきくん" ["price"]=> string(5) "50000" } }

file14.txt

id  title   name
1   双子の帝國 ふたごのていこく
2   進撃の巨人 singeki
3   となりの関くん   となりのせきくん

file2.txt

slim3
├── composer.json
├── composer.lock
├── classes     ←　こいつだけ作成した
├── logs
├── public
│   └── index.php
├── src
│   ├── dependencies.php
│   ├── middleware.php
│   ├── routes.php
│   └── settings.php
├── templates
│   └── index.phtml
└── vendor

file3.sql

CREATE TABLE `book` (
  `id` int(11) NOT NULL,
  `title` varchar(64) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL,
  `price` int(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8   

file4.sql

INSERT INTO `book` VALUES (1,'双子の帝國','ふたごのていこく',300),(2,'進撃の巨人','singeki',500),(3,'となりの関くん','となりのせきくん',50000);

index.php

// class load
spl_autoload_register(function ($classname) {
  require (__DIR__ . "/../classes/" . $classname . ".php");
});

Mapper.php

abstract class Mapper {
  protected $db;
  public function __construct($db) {
    $this->db = $db;
  }
}

routes.php

$app->get('/book_api2', function ($request, $response, $args) {
  $mapper = new TestMapper($this->db);
  $test = $mapper->getTests();
  $response = $this->renderer->render($response, "book_api.phtml", ["books" => $test]);
});

settings.php

  // DataBase(MySQL) settings
  'db' => [
      'host' => 'hostname',
      'port' => '3306',
      'user' => 'user',
      'pass' => 'passwd',
      'dbname' => 'test',
  ],

TestMapper.php

class TestMapper extends Mapper
{
  public function getTests() {
    $sql = "select * from book";
    $stmt = $this->db->query($sql);
    $results = [];
    while($row = $stmt->fetch()) {
      $results[] = $row;
    }
    return $results;
  }
}