php - 如何获得捆绑结果

Question

已结束。此问题正在寻求书籍、工具、软件库等的推荐。它不满足 Stack Overflow guidelines 。目前不接受答案。

---

我们不允许提出寻求书籍、工具、软件库等推荐的问题。您可以编辑问题，以便用事实和引文来回答。

已关闭 8 年前。

Improve this question

我遇到了有关显示 mysql 表结果的问题。我的 MySql 数据库中有一个这样的表。

表名称 - 书籍

+----+--------------------------+--------+-------+-------+----------------+
| id |           name           | author | price | pages |     topic      |
+----+--------------------------+--------+-------+-------+----------------+
|  1 | HTML for beginners       | Sanju  |   200 |   400 | HTML           |
|  2 | Master in JavaScript     | Sanju  |   300 |   500 | JavaScript     |
|  3 | Object Oriented PHP      | Henry  |   200 |   500 | php            |
|  4 | Advance AngularJS        | Henry  |   100 |   400 | AngularJs      |
|  5 | Basic Computer Operation | Fred   |   200 |   300 | Basic Computer |
|  6 | Rock the world with CSS  | Henry  |   400 |   500 | Css            |
|  7 | Be perfect in browsers   | Mark   |   250 |   300 | browser        |
+----+--------------------------+--------+-------+-------+----------------+

我想显示如下。

+---------------------+---------------+-------+-----------+
|     Author Name     |     Henry     |       |           | 
+---------------------+---------------+-------+-----------+
+-------------------------+---------------+-------+-----------+
|        Book name        |         Price | pages |   topic   |
+-------------------------+---------------+-------+-----------+
| Object Oriented PHP     |           200 |   500 | php       |
| Advance AngularJS       |           100 |   400 | AngularJs |
| Rock the world with CSS |           400 |   500 | Css       |
+-------------------------+---------------+-------+-----------+
+---------------------+---------------+-------+-----------+
|     Author Name     |     Sanju     |       |           | 
+---------------------+---------------+-------+-----------+
+----------------------+-------+-------+------------+
|      Book name       | Price | pages |   topic    |
+----------------------+-------+-------+------------+
| HTML for beginners   |   200 |   400 | HTML       |
| Master in JavaScript |   300 |   500 | JavaScript |
+----------------------+-------+-------+------------+
+---------------------+---------------+-------+-----------+
|     Author Name     |     Fred      |       |           | 
+---------------------+---------------+-------+-----------+
+--------------------------+-------+-------+----------------+
|        Book name         | Price | pages |     topic      |
+--------------------------+-------+-------+----------------+
| Basic Computer Operation |   200 |   300 | Basic Computer |
+--------------------------+-------+-------+----------------+
+---------------------+---------------+-------+-----------+
|     Author Name     |     Mark      |       |           | 
+---------------------+---------------+-------+-----------+
+------------------------+-------+-------+---------+
|       Book name        | Price | pages |  topic  |
+------------------------+-------+-------+---------+
| Be perfect in browsers |   250 |   300 | browser |
+------------------------+-------+-------+---------+

我需要 php 和 mysql 代码。谢谢

Answer 1

似乎您只需要按作者对数据进行排序，但是没有排序可以将它们按此顺序排列:

• 亨利
• 三州
• 弗雷德
• 标记

因为这既不是按字母顺序升序也不是按降序排列？

以下查询将使您能够按作者 ASC/DESC 排序:

SELECT * FROM books ORDER BY author ASC;
SELECT * FROM books ORDER BY author DESC;

但是，如果您需要以这种奇怪的顺序输出，您可能需要单独检索每个作者的书籍并将它们一一输出:

SELECT * FROM books WHERE author = 'Henry';
SELECT * FROM books WHERE author = 'Sanju';
SELECT * FROM books WHERE author = 'Fred';
SELECT * FROM books WHERE author = 'Mark';

不过，我不会发布如何从数据库检索数据，因为您可以阅读 PHP/MySQL 代码帮助的在线教程。请参阅以下链接以获得友好的 PDO 引用:

http://wiki.hashphp.org/PDO_Tutorial_for_MySQL_Developers

希望这会有所帮助 - 抱歉，我无法提供更多帮助。

祝你好运!