当我们从php中的数据库中获取大量数据时显示空白数据？

I want to fetch all the data from database but there show blank page because there is huge amount of data i.e 1000000 rows in the database table. I was used simple sql query to fetch data i.e

  select * from 'table_name';

It works for little amount of data such as 1000 rows in the table but when data should be huge or large such as 100000+ there display blank page.

So please help me to solve out this problem I would be thankful if anyone can give the good answer.

If your are in production server the blank page can be an error in your php script. I bet to memory error

First you need config your php for view errors display_errors = On display_startup_errors = On error_reporting = 1 log_errors = On

If you can't modify php config you have other option. Apache log register every error: 404, php, ...