mysql如何处理数据结构_php – 如何处理mySQL数据库中的复杂数据结构(OOP)？

成员：

id (autoinc)

name

password

theme_id

帖子：

id (autoinc)

member_id

title

date

标签：

id (autoinc)

name

Tag_Relations：

tag_id

post_id

帖子是帖子的“数组”,其中member_id列将每个帖子链接到其用户.

标签是您的标签“阵列”,标签关系将每个标签链接到一个或多个帖子.

这是一个如何获得所有帖子的例子.具有一个查询的用户的标记：

SELECT Members.name, Posts.title, Tag_Relations.item_id, Tags.name

FROM Members LEFT

JOIN Posts ON Members.id = Posts.member_id

LEFT JOIN Tag_Relations ON Tag_Relations.post_id = Posts.id

LEFT JOIN Tags ON Tags.id = Tag_Relations.tag_id

WHERE Members.id = 2779;

+----------+-----------------------------------+------------+---------+

| name | title | item_recid | name |

+----------+-----------------------------------+------------+---------+

| Mike | One Post's Title | 973 | Houses! |

| Mike | One Post's Title | 973 | Cars |

| Mike | One Post's Title | 973 | Hats |

| Mike | Another Post's Title | 973 | Cars |

| Mike | Yet another post | 975 | Homes |

| Mike | Guess what?! | 976 | Houses! |

| Mike | Another one :) | 977 | Noses |

| Mike | Another one :) | 977 | Mouth |

| Mike | Another one :) | 977 | Head |

| Mike | Another one :) | 977 | Knees |

+----------+-----------------------------------+------------+---------+