【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, モデル

: 【CakePHP2】リンククリック、サブミットボタン押下時に確認アラートを表示する方法

CakePHP2で、リンクをクリック時、及びフォームボタンをクリック（サブミット）時に、javascriptのアラートウィンドウを表示する方法を備忘録としてポストします。

: CakePHPのエラー404画面を振り分ける方法

PCページ、ガラケーページがあるサイトをCakePHPを利用しリニューアルする案件で、404ページなど、エラー画面を振り分ける方法にちと悩んだので、忘備録としてポストしておきます。例によってCakePHPのバージョンは1.3です。

: CakePHP 1.3.xで CSVファイルのエクスポート機能を作ってみた

過去に CakePHP1.3 で作成したシステムにCSVファイルのエクスポート機能を追加してほしいときたので、機能追加してみました。
忘備録も兼ねたポストで次回に備えたいと思います。

: CakePHP2.x系のバリデーション、alphaNumericがダメダメなので、独自バリデーションで回避。

CakePHP2.3.6のバリデーションの「alphaNumeric」、本などには「半角英数字のみ許可」となっていますが、なぜか日本語が通ってしまいました。

: CakePHPのバリデーションで、アルファベットのみかどうかチェックする関数を作ってみた。

数回前の「日本語文字数をチェック」と同様、バリデーション時にアルファベットのみかどうかをチェックする関数です。
CakePHP1.3で使っていましたが、2.x でも使えると思います。

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,960)

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

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

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

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

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