ErcFrtz Posted April 21, 2010 Share Posted April 21, 2010 I have searched and searched for an answer to the following question but have been unable to find an answer. I even searched these forums. Perhaps I am searching using the wrongs terms. Well here is the question. I have a PHP script that executes a large mysql query (60,000 separate entries for 1 individual with up to 200 individuals selected at a time) and the PHP script immediately returns a blank page. I'm sure it's not an error in my script because it works for smaller queries. Is doing a query of this size possible? Link to comment https://forums.phpfreaks.com/topic/199263-php-timing-out/ Share on other sites More sharing options...
JonnoTheDev Posted April 21, 2010 Share Posted April 21, 2010 If you get a blank page you may have an error and have error reporting switched off. Make sure it is switched on. ini_set('display_errors', 1); ini_set('error_reporting', E_ALL); Also, performing such an operation may be more suitable via the command line rather than trying to execute through a web browser. Your script may exhaust the allocated memory limit or exceed the max execution time limit. Link to comment https://forums.phpfreaks.com/topic/199263-php-timing-out/#findComment-1045872 Share on other sites More sharing options...
ErcFrtz Posted April 21, 2010 Author Share Posted April 21, 2010 I used the code to turn on error reporting in case it was off, but I still get a blank page. It's almost like the php script isn't even attempting to run. And I would do this through the command line if I could, but I'm creating a website for users that have no programming experience at all, so that they can pull the information from the database using a webpage. Link to comment https://forums.phpfreaks.com/topic/199263-php-timing-out/#findComment-1045875 Share on other sites More sharing options...
JonnoTheDev Posted April 21, 2010 Share Posted April 21, 2010 What level is your error reporting set at? Link to comment https://forums.phpfreaks.com/topic/199263-php-timing-out/#findComment-1045879 Share on other sites More sharing options...
ErcFrtz Posted April 21, 2010 Author Share Posted April 21, 2010 It's set at E_ALL & ~E_NOTICE Link to comment https://forums.phpfreaks.com/topic/199263-php-timing-out/#findComment-1045994 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.