开发者社区

文档建议反馈控制台

文章/答案/技术大牛

发布

社区首页 >问答首页 >与cakephp2.1中的数据获取有关的问题

问与cakephp2.1中的数据获取有关的问题
EN

Stack Overflow用户

提问于 2012-06-15 19:07:06

回答 1查看 118关注 0票数 0

我有这种格式的播放列表database...Its的简单结构

sr.no |    album_id |    song_id |    artist_id |    user_id

1.    |    160      |    85      |    40        |    5
2.    |    160      |    85      |    45        |    5
3.    |    160      |    85      |    41        |    6
4.    |    160      |    85      |    44        |    5

意味着album_id、song_id和artist_id的结合使完整记录成为唯一。我希望使用CAKEPHP条件在组中获取记录。例如：我想要这个format.Suppose中的数据，我想在特定的部分显示它，比如。

album_id | song_id | artist_id
160      |      85 | 40, 45, 41, 44

我的试用码是..。

        $playlist_condition = array('Tracklist.album_id' => $album_id, 'OR'=> array('Tracklist.status'=> 1, 'Tracklist.user_id'=>$user_id));
        $trackdetails = $this->Tracklist->find('all', array('conditions' => $playlist_condition ));
        $this->set("trackdetails", $trackdetails);

注意到递归的，我也想找到相关的模型。

我目前的输出是..。

Array
(
[0] => Array
    (
        [Tracklist] => Array
            (
                [id] => 140
                [album_id] => 1
                [song_id] => 185
                [artist_id] => 33
                [video_link] => 
                [status] => 1
                [user_id] => 
                [created] => 2012-05-25 10:08:50
                [modified_by] => 
                [modified] => 2012-05-25 10:08:50
            )

        [Album] => Array
            (
                [id] => 1
                [name] => Om, Namah Shivay
                [photo] => 
                [genre] => Devotional
                [copyrights] => 
                [year] => 0000
                [source] => 
                [description] => Its' an devotional Album.
                [download_link] => 
                [status] => 2
                [user_id] => 1
                [created] => 2012-04-06 00:00:00
                [modified_by] => 0
                [modified] => 2012-04-22 09:11:35
            )

        [Song] => Array
            (
                [id] => 185
                [name] => Shad.aab
                [hindi] => अ
                [roman] => a
                [category] => Qawwalli
                [poet_id] => 148
                [status] => 7
                [user_id] => 1
                [created] => 
                [modified_by] => 
                [modified] => 2012-04-22 09:07:48
            )

        [Artist] => Array
            (
                [id] => 33
                [name] => Suresh Vadekar
                [photo] => 
                [description] =>  Suresh Vadekar.
                [status] => 1
                [user_id] => 1
                [created] => 2012-05-20 18:12:38
                [modified_by] => 
                [modified] => 2012-05-20 18:12:39
            )

    )

[1] => Array
    (
        [Tracklist] => Array
            (
                [id] => 138
                [album_id] => 1
                [song_id] => 185
                [artist_id] => 31
                [video_link] => 
                [status] => 1
                [user_id] => 
                [created] => 2012-05-25 10:04:55
                [modified_by] => 
                [modified] => 2012-05-25 10:04:55
            )

        [Album] => Array
            (
                [id] => 1
                [name] => Om, Namah Shivay
                [photo] => 
                [genre] => Devotional
                [copyrights] => 
                [year] => 0000
                [source] => 
                [description] => Its' an devotional Album.
                [download_link] => 
                [status] => 2
                [user_id] => 1
                [created] => 2012-04-06 00:00:00
                [modified_by] => 0
                [modified] => 2012-04-22 09:11:35
            )

        [Song] => Array
            (
                [id] => 185
                [name] => Shad.aab
                [hindi] => अ
                [roman] => a
                [category] => Qawwalli
                [poet_id] => 148
                [status] => 7
                [user_id] => 1
                [created] => 
                [modified_by] => 
                [modified] => 2012-04-22 09:07:48
            )

        [Artist] => Array
            (
                [id] => 31
                [name] => Mehdi Hassan
                [photo] => 
                [description] => Mehdi Hassan Sahaab one of the prominiet singer of Asia...
                [status] => 1
                [user_id] => 1
                [created] => 2012-05-20 18:07:20
                [modified_by] => 
                [modified] => 2012-05-20 18:07:20
            )

    )

[2] => Array
    (
        [Tracklist] => Array
            (
                [id] => 139
                [album_id] => 1
                [song_id] => 185
                [artist_id] => 32
                [video_link] => 
                [status] => 1
                [user_id] => 
                [created] => 2012-05-25 10:04:55
                [modified_by] => 
                [modified] => 2012-05-25 10:04:55
            )

        [Album] => Array
            (
                [id] => 1
                [name] => Om, Namah Shivay
                [photo] => 
                [genre] => Devotional
                [copyrights] => 
                [year] => 0000
                [source] => 
                [description] => Its' an devotional Album.
                [download_link] => 
                [status] => 2
                [user_id] => 1
                [created] => 2012-04-06 00:00:00
                [modified_by] => 0
                [modified] => 2012-04-22 09:11:35
            )

        [Song] => Array
            (
                [id] => 185
                [name] => Shad.aab
                [hindi] => अ
                [roman] => a
                [category] => Qawwalli
                [poet_id] => 148
                [status] => 7
                [user_id] => 1
                [created] => 
                [modified_by] => 
                [modified] => 2012-04-22 09:07:48
            )

        [Artist] => Array
            (
                [id] => 32
                [name] => Jagjit Singh
                [photo] => 
                [description] => Jagjit Singh Sahab my favorite Sahab.
                [status] => 1
                [user_id] => 1
                [created] => 2012-05-20 18:11:07
                [modified_by] => 
                [modified] => 2012-05-20 18:11:07
            )

    )

)

EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2012-06-15 21:12:11

在GROUP_CONCAT中使用MySQL怎么样？

SELECT album_id, artist_id, GROUP_CONCAT(song_id) FROM my_table GROUP BY album_id, artist_id

票数 1

EN

页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持

原文链接：

https://stackoverflow.com/questions/11056753

复制

相似问题