【CakePHP2】HABTMモデルの練習

2015/03/13

いくつか CakePHP でコンテンツを作成してきたのですが、HABTM（HasAndBelongsToMany）を利用したリレーションを作成したことがなかったので、どんなものなのか作成してみました。

HABTMで検索し、blogですかいさんで紹介されていたアニメと声優の関係を作成するというケースがなかなか分かりやすかったので、それに挑戦してみました。

CakePHPの「HABTM」作成

テーブル作成

今回は

animes テーブル
voiceactors テーブル
animes_voiceactors テーブル

の３つのテーブルを用意します。

[]

↑ ER図もどき

肝は「animes_voiceactors」テーブル。

テーブルの命名規則でアルファベット順、どちらも複数形のテーブル名を付ける必要があります。
アルファベット順が逆になる「voiceactors_animes」テーブルでは「テーブルが無いよ！」というエラーが出ます。

ではチャチャッとテーブルをSQLで作成、データを放り込みます。
”atn_”はテスト用につけたプレフィックスです。

animes テーブル

CREATE TABLE `atn_animes` (
    `id` INT UNSIGNED AUTO_INCREMENT,              -- 
    `created` DATETIME DEFAULT NULL,               -- 
    `modified` DATETIME DEFAULT NULL,              -- 
    `delete_flg` TINYINT NOT NULL default '0',     -- 削除フラグ
    `publish_flg` TINYINT NOT NULL default '1',    -- 公開フラグ
    `title` VARCHAR(255),                          -- タイトル
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `atn_animes` 
    (id, created, modified, delete_flg, publish_flg, title) 
VALUES 
    (null, NOW(), NOW(), 0, 1, 'うる星やつら');

INSERT INTO `atn_animes` 
    (id, created, modified, delete_flg, publish_flg, title) 
VALUES 
    (null, NOW(), NOW(), 0, 1, 'シティハンター');

INSERT INTO `atn_animes` 
    (id, created, modified, delete_flg, publish_flg, title) 
VALUES 
    (null, NOW(), NOW(), 0, 1, 'ハイスクール！奇面組');

INSERT INTO `atn_animes` 
    (id, created, modified, delete_flg, publish_flg, title) 
VALUES 
    (null, NOW(), NOW(), 0, 1, 'ルパン三世 風魔一族の陰謀');

CREATE TABLE `atn_animes` (

`id` INT UNSIGNED AUTO_INCREMENT, --

`created` DATETIME DEFAULT NULL, --

`modified` DATETIME DEFAULT NULL, --

`delete_flg` TINYINT NOT NULL default '0', -- 削除フラグ

`publish_flg` TINYINT NOT NULL default '1', -- 公開フラグ

`title` VARCHAR(255), -- タイトル

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `atn_animes`

(id, created, modified, delete_flg, publish_flg, title)

VALUES

(null, NOW(), NOW(), 0, 1, 'うる星やつら');

INSERT INTO `atn_animes`

(id, created, modified, delete_flg, publish_flg, title)

VALUES

(null, NOW(), NOW(), 0, 1, 'シティハンター');

INSERT INTO `atn_animes`

(id, created, modified, delete_flg, publish_flg, title)

VALUES

(null, NOW(), NOW(), 0, 1, 'ハイスクール！奇面組');

INSERT INTO `atn_animes`

(id, created, modified, delete_flg, publish_flg, title)

VALUES

(null, NOW(), NOW(), 0, 1, 'ルパン三世風魔一族の陰謀');

voiceactors テーブル

CREATE TABLE `atn_voiceactors` (
    `id` INT UNSIGNED AUTO_INCREMENT,              -- 
    `created` DATETIME DEFAULT NULL,               -- 
    `modified` DATETIME DEFAULT NULL,              -- 
    `delete_flg` TINYINT NOT NULL default '0',     -- 削除フラグ
    `publish_flg` TINYINT NOT NULL default '1',    -- 公開フラグ
    `name` VARCHAR(255),                           -- 氏名
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `atn_voiceactors` 
    (id, created, modified, delete_flg, publish_flg, name) 
VALUES 
    (null, NOW(), NOW(), 0, 1, '古川　登志夫');

INSERT INTO `atn_voiceactors` 
    (id, created, modified, delete_flg, publish_flg, name) 
VALUES 
    (null, NOW(), NOW(), 0, 1, '神谷　明');

INSERT INTO `atn_voiceactors` 
    (id, created, modified, delete_flg, publish_flg, name) 
VALUES 
    (null, NOW(), NOW(), 0, 1, '千葉　繁');

CREATE TABLE `atn_voiceactors` (

`id` INT UNSIGNED AUTO_INCREMENT, --

`created` DATETIME DEFAULT NULL, --

`modified` DATETIME DEFAULT NULL, --

`delete_flg` TINYINT NOT NULL default '0', -- 削除フラグ

`publish_flg` TINYINT NOT NULL default '1', -- 公開フラグ

`name` VARCHAR(255), -- 氏名

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `atn_voiceactors`

(id, created, modified, delete_flg, publish_flg, name)

VALUES

(null, NOW(), NOW(), 0, 1, '古川　登志夫');

INSERT INTO `atn_voiceactors`

(id, created, modified, delete_flg, publish_flg, name)

VALUES

(null, NOW(), NOW(), 0, 1, '神谷　明');

INSERT INTO `atn_voiceactors`

(id, created, modified, delete_flg, publish_flg, name)

VALUES

(null, NOW(), NOW(), 0, 1, '千葉　繁');

animes_voiceactors テーブル

-- HABTM
CREATE TABLE `atn_animes_voiceactors` (
    `id` INT UNSIGNED AUTO_INCREMENT,              -- 
    `created` DATETIME DEFAULT NULL,               -- 
    `modified` DATETIME DEFAULT NULL,              -- 
    `delete_flg` TINYINT NOT NULL default '0',     -- 削除フラグ
    `publish_flg` TINYINT NOT NULL default '1',    -- 公開フラグ
    `voiceactor_id` INT NOT NULL,                  -- 
    `anime_id` INT NOT NULL,                       -- 
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `atn_animes_voiceactors` 
    (id, created, modified, delete_flg, publish_flg, voiceactor_id, anime_id) 
VALUES 
    (null, NOW(), NOW(), 0, 1, 1, 1);


INSERT INTO `atn_animes_voiceactors` 
    (id, created, modified, delete_flg, publish_flg, voiceactor_id, anime_id) 
VALUES 
    (null, NOW(), NOW(), 0, 1, 1, 4);


INSERT INTO `atn_animes_voiceactors` 
    (id, created, modified, delete_flg, publish_flg, voiceactor_id, anime_id) 
VALUES 
    (null, NOW(), NOW(), 0, 1, 2, 1);


INSERT INTO `atn_animes_voiceactors` 
    (id, created, modified, delete_flg, publish_flg, voiceactor_id, anime_id) 
VALUES 
    (null, NOW(), NOW(), 0, 1, 2, 2);


INSERT INTO `atn_animes_voiceactors` 
    (id, created, modified, delete_flg, publish_flg, voiceactor_id, anime_id) 
VALUES 
    (null, NOW(), NOW(), 0, 1, 3, 1);

INSERT INTO `atn_animes_voiceactors` 
    (id, created, modified, delete_flg, publish_flg, voiceactor_id, anime_id) 
VALUES 
    (null, NOW(), NOW(), 0, 1, 3, 3);

-- HABTM

CREATE TABLE `atn_animes_voiceactors` (

`id` INT UNSIGNED AUTO_INCREMENT, --

`created` DATETIME DEFAULT NULL, --

`modified` DATETIME DEFAULT NULL, --

`delete_flg` TINYINT NOT NULL default '0', -- 削除フラグ

`publish_flg` TINYINT NOT NULL default '1', -- 公開フラグ

`voiceactor_id` INT NOT NULL, --

`anime_id` INT NOT NULL, --

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `atn_animes_voiceactors`

(id, created, modified, delete_flg, publish_flg, voiceactor_id, anime_id)

VALUES

(null, NOW(), NOW(), 0, 1, 1, 1);

INSERT INTO `atn_animes_voiceactors`

(id, created, modified, delete_flg, publish_flg, voiceactor_id, anime_id)

VALUES

(null, NOW(), NOW(), 0, 1, 1, 4);

INSERT INTO `atn_animes_voiceactors`

(id, created, modified, delete_flg, publish_flg, voiceactor_id, anime_id)

VALUES

(null, NOW(), NOW(), 0, 1, 2, 1);

INSERT INTO `atn_animes_voiceactors`

(id, created, modified, delete_flg, publish_flg, voiceactor_id, anime_id)

VALUES

(null, NOW(), NOW(), 0, 1, 2, 2);

INSERT INTO `atn_animes_voiceactors`

(id, created, modified, delete_flg, publish_flg, voiceactor_id, anime_id)

VALUES

(null, NOW(), NOW(), 0, 1, 3, 1);

INSERT INTO `atn_animes_voiceactors`

(id, created, modified, delete_flg, publish_flg, voiceactor_id, anime_id)

VALUES

(null, NOW(), NOW(), 0, 1, 3, 3);

80年台の香りがプンプンですな（笑）

CakePHPのモデル作成

次にモデルの作成。

Anime.php
Voiceactor.php
AnimesVoiceactor.php

上記３つを用意。
HABTM用のモデルは前が複数形、後が単数形の単語になるというややこしい命名規則です。

Anime.php

<?php
class Anime extends AppModel
{
    public $name = 'Anime';

    // アソシエーション
    public $hasAndBelongsToMany = array(
        'Voiceactor' => array(
            'className'             => 'Voiceactor',
            'joinTable'             => 'animes_voiceactors',  // 中間テーブルの名称(Model名ではなくテーブル名) 
            'foreignKey'            => 'anime_id',            // animes_voiceactorsの中のAnimeとのforeignKey
            'associationForeignKey' => 'voiceactor_id',       // アソシエーションしている中のforeignKey.ここではAnimesVoiceactorのvoiceactor_id
            'unique'                => true,
            'conditions'            => '',
            'fields'                => '',
            'order'                 => '',
            'limit'                 => '',
            'offset'                => '',
            'finderQuery'           => '',
            'deleteQuery'           => '',
            'insertQuery'           => ''
        )
    );
}

<?php

class Anime extends AppModel

{

public $name = 'Anime';

// アソシエーション

public $hasAndBelongsToMany = array(

'Voiceactor' => array(

'className' => 'Voiceactor',

'joinTable' => 'animes_voiceactors', // 中間テーブルの名称(Model名ではなくテーブル名)

'foreignKey' => 'anime_id', // animes_voiceactorsの中のAnimeとのforeignKey

'associationForeignKey' => 'voiceactor_id', // アソシエーションしている中のforeignKey.ここではAnimesVoiceactorのvoiceactor_id

'unique' => true,

'conditions' => '',

'fields' => '',

'order' => '',

'limit' => '',

'offset' => '',

'finderQuery' => '',

'deleteQuery' => '',

'insertQuery' => ''

)

);

}

Voiceactor.php

<?php
class Voiceactor extends AppModel
{
    public $name = 'Voiceactor';

    // アソシエーション
    public $hasAndBelongsToMany = array(
        'Anime' => array(
            'className'             => 'Anime',
            'joinTable'             => 'animes_voiceactors',  // 中間テーブルの名称(Model名ではなくテーブル名) 
            'foreignKey'            => 'voiceactor_id',       // animes_voiceactorsの中のVoiceactorとのforeignKey
            'associationForeignKey' => 'anime_id',            // アソシエーションしている中のforeignKey.ここではAnimesVoiceactorのanime_id
            'unique'                => true,
            'conditions'            => '',
            'fields'                => '',
            'order'                 => '',
            'limit'                 => '',
            'offset'                => '',
            'finderQuery'           => '',
            'deleteQuery'           => '',
            'insertQuery'           => ''
        )
    );
}

<?php

class Voiceactor extends AppModel

{

public $name = 'Voiceactor';

// アソシエーション

public $hasAndBelongsToMany = array(

'Anime' => array(

'className' => 'Anime',

'joinTable' => 'animes_voiceactors', // 中間テーブルの名称(Model名ではなくテーブル名)

'foreignKey' => 'voiceactor_id', // animes_voiceactorsの中のVoiceactorとのforeignKey

'associationForeignKey' => 'anime_id', // アソシエーションしている中のforeignKey.ここではAnimesVoiceactorのanime_id

'unique' => true,

'conditions' => '',

'fields' => '',

'order' => '',

'limit' => '',

'offset' => '',

'finderQuery' => '',

'deleteQuery' => '',

'insertQuery' => ''

)

);

}

AnimesVoiceactor.php

<?php
class AnimesVoiceactor extends AppModel
{
    public $name = 'AnimesVoiceactor';


    // アソシエーション
    public $belongsTo = array(
        'Anime' => array(
            'className'  => 'Anime',
            'foreignKey' => 'anime_id',
            'dependent'  => false,
            'conditions' => '',
            'fields'     => '',
            'order'      => '',
        ),

        'Voiceactor' => array(
            'className'  => 'Voiceactor',
            'foreignKey' => 'voiceactor_id',
            'dependent'  => false,
            'conditions' => '',
            'fields'     => '',
            'order'      => '',
        ),
    );

}

<?php

class AnimesVoiceactor extends AppModel

{

public $name = 'AnimesVoiceactor';

// アソシエーション

public $belongsTo = array(

'Anime' => array(

'className' => 'Anime',

'foreignKey' => 'anime_id',

'dependent' => false,

'conditions' => '',

'fields' => '',

'order' => '',

'Voiceactor' => array(

'className' => 'Voiceactor',

'foreignKey' => 'voiceactor_id',

'dependent' => false,

'conditions' => '',

'fields' => '',

'order' => '',

);

}

CakePHPの「HABTM」結果

Anime一覧

Anime一覧のデバッグ

// Anime一覧取得
$anime_data = $this->Anime->find( 'all',
    array(
        'conditions' => array('Anime.publish_flg' => 1),
        'fields'     => null,
        'order'      => array('Anime.id' => 'ASC'),
        'recursive'  => 1
    )
);

// Anime一覧取得

$anime_data = $this->Anime->find( 'all',

array(

'conditions' => array('Anime.publish_flg' => 1),

'fields' => null,

'order' => array('Anime.id' => 'ASC'),

'recursive' => 1

)

);

HABTM設定前

Array
(
    [0] => Array
        (
            [Anime] => Array
                (
                    [id] => 1
                    [created] => 2015-03-12 17:21:25
                    [modified] => 2015-03-12 17:21:25
                    [delete_flg] => 0
                    [publish_flg] => 1
                    [title] => うる星やつら
                )

        )

    [1] => Array
        (
            [Anime] => Array
                (
                    [id] => 2
                    [created] => 2015-03-12 17:21:25
                    [modified] => 2015-03-12 17:21:25
                    [delete_flg] => 0
                    [publish_flg] => 1
                    [title] => シティハンター
                )

        )

    [2] => Array
        (
            [Anime] => Array
                (
                    [id] => 3
                    [created] => 2015-03-12 17:21:25
                    [modified] => 2015-03-12 17:21:25
                    [delete_flg] => 0
                    [publish_flg] => 1
                    [title] => ハイスクール！奇面組
                )

        )

    [3] => Array
        (
            [Anime] => Array
                (
                    [id] => 4
                    [created] => 2015-03-12 17:21:25
                    [modified] => 2015-03-12 17:21:25
                    [delete_flg] => 0
                    [publish_flg] => 1
                    [title] => ルパン三世 風魔一族の陰謀
                )

        )
)

Array

(

[0] => Array

(

[Anime] => Array

(

[id] => 1

[created] => 2015-03-12 17:21:25

[modified] => 2015-03-12 17:21:25

[delete_flg] => 0

[publish_flg] => 1

[title] => うる星やつら

)

[1] => Array

(

[Anime] => Array

(

[id] => 2

[created] => 2015-03-12 17:21:25

[modified] => 2015-03-12 17:21:25

[delete_flg] => 0

[publish_flg] => 1

[title] => シティハンター

)

[2] => Array

(

[Anime] => Array

(

[id] => 3

[created] => 2015-03-12 17:21:25

[modified] => 2015-03-12 17:21:25

[delete_flg] => 0

[publish_flg] => 1

[title] => ハイスクール！奇面組

)

[3] => Array

(

[Anime] => Array

(

[id] => 4

[created] => 2015-03-12 17:21:25

[modified] => 2015-03-12 17:21:25

[delete_flg] => 0

[publish_flg] => 1

[title] => ルパン三世風魔一族の陰謀

)

AnimeモデルのHABTM設定後

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

Array

(

[0] => Array

(

[Anime] => Array

(

[id] => 1

[created] => 2015-03-12 17:21:25

[modified] => 2015-03-12 17:21:25

[delete_flg] => 0

[publish_flg] => 1

[title] => うる星やつら

)

[Voiceactor] => Array

(

[0] => Array

(

[id] => 1

[created] => 2015-03-12 17:16:36

[modified] => 2015-03-12 17:16:36

[delete_flg] => 0

[publish_flg] => 1

[name] => 古川　登志夫

[AnimesVoiceactor] => Array

(

[id] => 1

[created] => 2015-03-12 17:21:55

[modified] => 2015-03-12 17:21:55

[delete_flg] => 0

[publish_flg] => 1

[voiceactor_id] => 1

[anime_id] => 1

)

[1] => Array

(

[id] => 2

[created] => 2015-03-12 17:16:36

[modified] => 2015-03-12 17:16:36

[delete_flg] => 0

[publish_flg] => 1

[name] => 神谷　明

[AnimesVoiceactor] => Array

(

[id] => 3

[created] => 2015-03-12 17:21:55

[modified] => 2015-03-12 17:21:55

[delete_flg] => 0

[publish_flg] => 1

[voiceactor_id] => 2

[anime_id] => 1

)

[2] => Array

(

[id] => 3

[created] => 2015-03-12 17:16:36

[modified] => 2015-03-12 17:16:36

[delete_flg] => 0

[publish_flg] => 1

[name] => 千葉　繁

[AnimesVoiceactor] => Array

(

[id] => 5

[created] => 2015-03-12 17:21:55

[modified] => 2015-03-12 17:21:55

[delete_flg] => 0

[publish_flg] => 1

[voiceactor_id] => 3

[anime_id] => 1

)

[1] => Array

(

[Anime] => Array

(

[id] => 2

[created] => 2015-03-12 17:21:25

[modified] => 2015-03-12 17:21:25

[delete_flg] => 0

[publish_flg] => 1

[title] => シティハンター

)

[Voiceactor] => Array

(

[0] => Array

(

[id] => 2

[created] => 2015-03-12 17:16:36

[modified] => 2015-03-12 17:16:36

[delete_flg] => 0

[publish_flg] => 1

[name] => 神谷　明

[AnimesVoiceactor] => Array

(

[id] => 4

[created] => 2015-03-12 17:21:55

[modified] => 2015-03-12 17:21:55

[delete_flg] => 0

[publish_flg] => 1

[voiceactor_id] => 2

[anime_id] => 2

)

[2] => Array

(

[Anime] => Array

(

[id] => 3

[created] => 2015-03-12 17:21:25

[modified] => 2015-03-12 17:21:25

[delete_flg] => 0

[publish_flg] => 1

[title] => ハイスクール！奇面組

)

[Voiceactor] => Array

(

[0] => Array

(

[id] => 3

[created] => 2015-03-12 17:16:36

[modified] => 2015-03-12 17:16:36

[delete_flg] => 0

[publish_flg] => 1

[name] => 千葉　繁

[AnimesVoiceactor] => Array

(

[id] => 6

[created] => 2015-03-12 17:21:55

[modified] => 2015-03-12 17:21:55

[delete_flg] => 0

[publish_flg] => 1

[voiceactor_id] => 3

[anime_id] => 3

)

[3] => Array

(

[Anime] => Array

(

[id] => 4

[created] => 2015-03-12 17:21:25

[modified] => 2015-03-12 17:21:25

[delete_flg] => 0

[publish_flg] => 1

[title] => ルパン三世風魔一族の陰謀

)

[Voiceactor] => Array

(

[0] => Array

(

[id] => 1

[created] => 2015-03-12 17:16:36

[modified] => 2015-03-12 17:16:36

[delete_flg] => 0

[publish_flg] => 1

[name] => 古川　登志夫

[AnimesVoiceactor] => Array

(

[id] => 2

[created] => 2015-03-12 17:21:55

[modified] => 2015-03-12 17:21:55

[delete_flg] => 0

[publish_flg] => 1

[voiceactor_id] => 1

[anime_id] => 4

)

Anime詳細

Anime詳細のデバッグ

Array

(

[Anime] => Array

(

[id] => 1

[created] => 2015-03-12 17:21:25

[modified] => 2015-03-12 17:21:25

[delete_flg] => 0

[publish_flg] => 1

[title] => うる星やつら

)

[Voiceactor] => Array

(

[0] => Array

(

[id] => 1

[created] => 2015-03-12 17:16:36

[modified] => 2015-03-12 17:16:36

[delete_flg] => 0

[publish_flg] => 1

[name] => 古川　登志夫

[AnimesVoiceactor] => Array

(

[id] => 1

[created] => 2015-03-12 17:21:55

[modified] => 2015-03-12 17:21:55

[delete_flg] => 0

[publish_flg] => 1

[voiceactor_id] => 1

[anime_id] => 1

)

[1] => Array

(

[id] => 2

[created] => 2015-03-12 17:16:36

[modified] => 2015-03-12 17:16:36

[delete_flg] => 0

[publish_flg] => 1

[name] => 神谷　明

[AnimesVoiceactor] => Array

(

[id] => 3

[created] => 2015-03-12 17:21:55

[modified] => 2015-03-12 17:21:55

[delete_flg] => 0

[publish_flg] => 1

[voiceactor_id] => 2

[anime_id] => 1

)

[2] => Array

(

[id] => 3

[created] => 2015-03-12 17:16:36

[modified] => 2015-03-12 17:16:36

[delete_flg] => 0

[publish_flg] => 1

[name] => 千葉　繁

[AnimesVoiceactor] => Array

(

[id] => 5

[created] => 2015-03-12 17:21:55

[modified] => 2015-03-12 17:21:55

[delete_flg] => 0

[publish_flg] => 1

[voiceactor_id] => 3

[anime_id] => 1

)

Voiceactor一覧

Voiceactor一覧のデバッグ

// Voiceactor一覧取得
$voiceactor_data = $this->Voiceactor->find( 'all',
    array(
        'conditions' => array('Voiceactor.publish_flg' => 1),
        'fields'     => null,
        'order'      => array('Voiceactor.id' => 'ASC'),
        'recursive'  => 1
    )
);

// Voiceactor一覧取得

$voiceactor_data = $this->Voiceactor->find( 'all',

array(

'conditions' => array('Voiceactor.publish_flg' => 1),

'fields' => null,

'order' => array('Voiceactor.id' => 'ASC'),

'recursive' => 1

)

);

HABTM設定前

Array
(
    [0] => Array
        (
            [Voiceactor] => Array
                (
                    [id] => 1
                    [created] => 2015-03-12 17:16:36
                    [modified] => 2015-03-12 17:16:36
                    [delete_flg] => 0
                    [publish_flg] => 1
                    [name] => 古川　登志夫
                )

        )

    [1] => Array
        (
            [Voiceactor] => Array
                (
                    [id] => 2
                    [created] => 2015-03-12 17:16:36
                    [modified] => 2015-03-12 17:16:36
                    [delete_flg] => 0
                    [publish_flg] => 1
                    [name] => 神谷　明
                )

        )

    [2] => Array
        (
            [Voiceactor] => Array
                (
                    [id] => 3
                    [created] => 2015-03-12 17:16:36
                    [modified] => 2015-03-12 17:16:36
                    [delete_flg] => 0
                    [publish_flg] => 1
                    [name] => 千葉　繁
                )

        )
)

Array

(

[0] => Array

(

[Voiceactor] => Array

(

[id] => 1

[created] => 2015-03-12 17:16:36

[modified] => 2015-03-12 17:16:36

[delete_flg] => 0

[publish_flg] => 1

[name] => 古川　登志夫

)

[1] => Array

(

[Voiceactor] => Array

(

[id] => 2

[created] => 2015-03-12 17:16:36

[modified] => 2015-03-12 17:16:36

[delete_flg] => 0

[publish_flg] => 1

[name] => 神谷　明

)

[2] => Array

(

[Voiceactor] => Array

(

[id] => 3

[created] => 2015-03-12 17:16:36

[modified] => 2015-03-12 17:16:36

[delete_flg] => 0

[publish_flg] => 1

[name] => 千葉　繁

)

VoiceactorモデルのHABTM設定後

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

Array

(

[0] => Array

(

[Voiceactor] => Array

(

[id] => 1

[created] => 2015-03-12 17:16:36

[modified] => 2015-03-12 17:16:36

[delete_flg] => 0

[publish_flg] => 1

[name] => 古川　登志夫

)

[Anime] => Array

(

[0] => Array

(

[id] => 1

[created] => 2015-03-12 17:21:25

[modified] => 2015-03-12 17:21:25

[delete_flg] => 0

[publish_flg] => 1

[title] => うる星やつら

[AnimesVoiceactor] => Array

(

[id] => 1

[created] => 2015-03-12 17:21:55

[modified] => 2015-03-12 17:21:55

[delete_flg] => 0

[publish_flg] => 1

[voiceactor_id] => 1

[anime_id] => 1

)

[1] => Array

(

[id] => 4

[created] => 2015-03-12 17:21:25

[modified] => 2015-03-12 17:21:25

[delete_flg] => 0

[publish_flg] => 1

[title] => ルパン三世風魔一族の陰謀

[AnimesVoiceactor] => Array

(

[id] => 2

[created] => 2015-03-12 17:21:55

[modified] => 2015-03-12 17:21:55

[delete_flg] => 0

[publish_flg] => 1

[voiceactor_id] => 1

[anime_id] => 4

)

[1] => Array

(

[Voiceactor] => Array

(

[id] => 2

[created] => 2015-03-12 17:16:36

[modified] => 2015-03-12 17:16:36

[delete_flg] => 0

[publish_flg] => 1

[name] => 神谷　明

)

[Anime] => Array

(

[0] => Array

(

[id] => 1

[created] => 2015-03-12 17:21:25

[modified] => 2015-03-12 17:21:25

[delete_flg] => 0

[publish_flg] => 1

[title] => うる星やつら

[AnimesVoiceactor] => Array

(

[id] => 3

[created] => 2015-03-12 17:21:55

[modified] => 2015-03-12 17:21:55

[delete_flg] => 0

[publish_flg] => 1

[voiceactor_id] => 2

[anime_id] => 1

)

[1] => Array

(

[id] => 2

[created] => 2015-03-12 17:21:25

[modified] => 2015-03-12 17:21:25

[delete_flg] => 0

[publish_flg] => 1

[title] => シティハンター

[AnimesVoiceactor] => Array

(

[id] => 4

[created] => 2015-03-12 17:21:55

[modified] => 2015-03-12 17:21:55

[delete_flg] => 0

[publish_flg] => 1

[voiceactor_id] => 2

[anime_id] => 2

)

[2] => Array

(

[Voiceactor] => Array

(

[id] => 3

[created] => 2015-03-12 17:16:36

[modified] => 2015-03-12 17:16:36

[delete_flg] => 0

[publish_flg] => 1

[name] => 千葉　繁

)

[Anime] => Array

(

[0] => Array

(

[id] => 1

[created] => 2015-03-12 17:21:25

[modified] => 2015-03-12 17:21:25

[delete_flg] => 0

[publish_flg] => 1

[title] => うる星やつら

[AnimesVoiceactor] => Array

(

[id] => 5

[created] => 2015-03-12 17:21:55

[modified] => 2015-03-12 17:21:55

[delete_flg] => 0

[publish_flg] => 1

[voiceactor_id] => 3

[anime_id] => 1

)

[1] => Array

(

[id] => 3

[created] => 2015-03-12 17:21:25

[modified] => 2015-03-12 17:21:25

[delete_flg] => 0

[publish_flg] => 1

[title] => ハイスクール！奇面組

[AnimesVoiceactor] => Array

(

[id] => 6

[created] => 2015-03-12 17:21:55

[modified] => 2015-03-12 17:21:55

[delete_flg] => 0

[publish_flg] => 1

[voiceactor_id] => 3

[anime_id] => 3

)

Voiceactor詳細

Voiceactor詳細のデバッグ

Array
(
    [Voiceactor] => Array
        (
            [id] => 1
            [created] => 2015-03-12 17:16:36
            [modified] => 2015-03-12 17:16:36
            [delete_flg] => 0
            [publish_flg] => 1
            [name] => 古川　登志夫
        )

    [Anime] => Array
        (
            [0] => Array
                (
                    [id] => 1
                    [created] => 2015-03-12 17:21:25
                    [modified] => 2015-03-12 17:21:25
                    [delete_flg] => 0
                    [publish_flg] => 1
                    [title] => うる星やつら
                    [AnimesVoiceactor] => Array
                        (
                            [id] => 1
                            [created] => 2015-03-12 17:21:55
                            [modified] => 2015-03-12 17:21:55
                            [delete_flg] => 0
                            [publish_flg] => 1
                            [voiceactor_id] => 1
                            [anime_id] => 1
                        )

                )

            [1] => Array
                (
                    [id] => 4
                    [created] => 2015-03-12 17:21:25
                    [modified] => 2015-03-12 17:21:25
                    [delete_flg] => 0
                    [publish_flg] => 1
                    [title] => ルパン三世 風魔一族の陰謀
                    [AnimesVoiceactor] => Array
                        (
                            [id] => 2
                            [created] => 2015-03-12 17:21:55
                            [modified] => 2015-03-12 17:21:55
                            [delete_flg] => 0
                            [publish_flg] => 1
                            [voiceactor_id] => 1
                            [anime_id] => 4
                        )

                )

        )
)

Array

(

[Voiceactor] => Array

(

[id] => 1

[created] => 2015-03-12 17:16:36

[modified] => 2015-03-12 17:16:36

[delete_flg] => 0

[publish_flg] => 1

[name] => 古川　登志夫

)

[Anime] => Array

(

[0] => Array

(

[id] => 1

[created] => 2015-03-12 17:21:25

[modified] => 2015-03-12 17:21:25

[delete_flg] => 0

[publish_flg] => 1

[title] => うる星やつら

[AnimesVoiceactor] => Array

(

[id] => 1

[created] => 2015-03-12 17:21:55

[modified] => 2015-03-12 17:21:55

[delete_flg] => 0

[publish_flg] => 1

[voiceactor_id] => 1

[anime_id] => 1

)

[1] => Array

(

[id] => 4

[created] => 2015-03-12 17:21:25

[modified] => 2015-03-12 17:21:25

[delete_flg] => 0

[publish_flg] => 1

[title] => ルパン三世風魔一族の陰謀

[AnimesVoiceactor] => Array

(

[id] => 2

[created] => 2015-03-12 17:21:55

[modified] => 2015-03-12 17:21:55

[delete_flg] => 0

[publish_flg] => 1

[voiceactor_id] => 1

[anime_id] => 4

)

各レコードの取得に際しての recursive 値は 1 ですが、HABTM設定後はいい具合にリレーションして取得していますね。
モデルさえきちんと設定できればあまり何も考えずに必要レコードを引っ張ってきてくれるので、なかなか便利な設定ではないでしょうか。

参考にしたサイト様

CakePHP2でHABTMなモデルを作った話 - blogですかい

-CakePHP
-HABTM, Model, モデル

: CakePHPでWEB APIを自作してみる。

サーバＡで運営しているDBのデータを、サーバＢで必要になりました。

サーバＡのデータをエクスポートしてサーバＢへインポートし、作成したプログラムで必要に応じて取得する、という流れでもいいのですが、エクスポート、インポートする手間が惜しい。

ならば、サーバＢからのリクエストに対し必要なデータを送信するという、いわゆる API をサーバＡに設置してはどうかという流れになり、調べてみましたら、意外と簡単にできることが判明。

忘備録代わりにコチラに作り方をポストしてみます。

: CakePHPのバリデーションで、日本語の文字数チェックする関数を作ってみた。

前日の改行を削除するルーチンを踏まえて、CakePHPのバリデーション時に日本語の文字数をチェックする関数を作ってみたので公開。
ちなみに、CakePHP1.3で使っていましたが、2.x でも使えると思います。

: 【CakePHP2】任意のアクションでBASIC認証する方法

CakePHP2系統で運用しているサイト（メールフォームの管理者画面）へ、BASIC認証させたいという要望が入ったので実装してみました。次回から調査する時間を省くための備忘録としてポストしておきます。

: Excelファイルを出力する「PHPExcel」をCakePHP2.3.xで使う方法

既存のExcelフォーマットへ、CakePHPで作成（蓄積）したデータを流しこむという処理があったので、PHPExcelを使ってみました。
今回もまた、忘備録を兼ねたポストです。

: CakePHPで携帯（ガラケー）とPC用のサイトを振り分ける方法

CakePHP（1.3）で作成しているサイトで、PC用とガラケー用ページを振り分ける必要があったので、以前、スマホ用ページとの振り分けでも利用した「Ktai Library」を利用して簡単にリダイレクトする方法を忘備録としてポストしときます。

PREV: 【CSS】backgroundプロパティのまとめ
NEXT: 【CakePHP2】HABTMモデルの練習その２

【CakePHP2】HABTMモデルの練習

CakePHPの「HABTM」作成

テーブル作成

animes テーブル

voiceactors テーブル

animes_voiceactors テーブル

CakePHPのモデル作成

Anime.php

Voiceactor.php

AnimesVoiceactor.php

CakePHPの「HABTM」結果

Anime一覧

Anime一覧のデバッグ

HABTM設定前

AnimeモデルのHABTM設定後

Anime詳細

Anime詳細のデバッグ

Voiceactor一覧

Voiceactor一覧のデバッグ

HABTM設定前

VoiceactorモデルのHABTM設定後

Voiceactor詳細

Voiceactor詳細のデバッグ

参考にしたサイト様

【DIY】2x4や1x4など、SPF材サイズ早見表 (564,962)

【知識】電話番号の+81の意味と固定電話・携帯電話番号の書き方 (279,679)

TPPやLCCなど、時事や普段使っている「アルファベット略語」を集めてみた (257,922)

【歴史】江戸幕府歴代将軍一覧 (143,590)

【知識】牛肉の部位「おっぱい」は本当に乳房なのかが気になったので調べてみた (133,250)

【Excel】ダブルクォーテーションでデータを囲んだCSVファイルの作成方法 (131,309)