格式化 MySQL 查询的结果,就好像它是从控制台运行的一样
我正在编写一个快速而肮脏的报告脚本,用于查询报告并通过电子邮件发送结果.使用 MySQL 控制台时,结果显示在格式良好的表格中:
I'm writing a quick and dirty reporting script that queries a report and emails the results. When using the MySQL console the results are in a nicely formatted table:
mysql> select * from users;
+-----------+------------+-------+
| firstname | city | zip |
+-----------+------------+-------+
| Maria | Holland | 12345 |
| Rene | Doylestown | 65432 |
| Helen | Conway | 98745 |
+-----------+------------+-------+
3 rows in set (0.01 sec)
在使用 PHP 获取结果时,是否有一种简单的方法可以复制这种格式?显然,我可以通过编写自己的报告格式化程序来实现这一点,但我希望有一些更优雅的东西.
Is there an easy way to replicate this formatting when fetching the results with PHP? Obviously I could achieve this by writing my own report formatter but I was hoping for something a little more elegant.
推荐答案
你可以很容易地使用 Console_Table PEAR 包.只需遍历您的 MySQL 结果,然后将行添加到您的表中.您可以使用 Console_Table::setHeaders()
方法为列添加标题,然后使用 Console_Table::addRow()
方法添加每一行,最后 Console_Table::getTable()
来显示它.
You could do this quite easily using the Console_Table PEAR package. Just loop through your MySQL results, and add rows to your table. You can use the Console_Table::setHeaders()
method to add the headers for your columns, then the Console_Table::addRow()
method to add each row, and finally Console_Table::getTable()
to display it.
PHP 没有内置任何东西来执行此操作.如果您不想使用/编写代码来绘制控制台表,只需使用 passthru()
通过 PHP 将 -e query
传递给 mysql.这将使用 ;
和 G
:
There is nothing built into PHP to do this. If you don't want to use/write code to draw console tables, just pass -e query
to mysql via PHP using passthru()
. This will work queries terminated with both ;
and G
:
passthru("mysql -e '$query;' database_name");
相关文章