Script Doesn't End Loading

subhuman

I have a code posted here for clarity:

http://www.pastebin.com/279157

If you read the code, there's no error and the script works well. The file is created and the contents of the database is written to the file. The only problem with that is that the code doesn't seem to end loading. Moreover, the associated HTML with the script doesn't display anymore. Any suggestions?

Patrick

justsomeone

if it doesn't seem to end loading, how far does it get? Use "View source" in your browser to find out. This should at least indicate which of the php sections is causing the problem.

The final "exit" is likely to be a problem, as that may kill the interpreter before displaying the last two lines of the html. I ahven't used it like this, so I can't say for certain. In any case, I'm guessing that that was just added in desperation, in an attempt to fix the not loading problem.

It's hard to say for certain, with the indentation of your code, but you seem to be missing a lot of closing brackets there. Are you sure the script runs without errors, or do you just have error display disabled?

Installer

There are also a lot of backslashes that aren't escaped. If you just use forward slashes they'll still get interpreted ok, and you won't have to worry about escaping them (and not).

Turning on error reporting and display can save a lot of time and consternation.

subhuman

actually there's no error being released. i checked the apache logs and no specific to the file was displayed. moreover, the backslahes were changed yet same results appear.

i have updated the file and still the script doesn't end. is there a way to check where the error might be occuring aside from the Apache logs?

here's the updated file: http://www.pastebin.com/279180

Installer

If you have error reporting and display turned on you would be seeing the errors. If you don't, add these lines to the top of your script to see what you get:

error_reporting(E_ALL);  

ini_set('display_errors', '1');

edit: The missing backslashes must be an artifact of the pastebin software.

subhuman

ok, i'll test that. perhaps pastebin's fault. anyway, i've rechecked my code and i think the one that makes it long is the lines 176-207, the inner loop that creates another database connection. i am just wondering, the file is created perfectly, the way I wanted it but still the window doesn't stop loading.

i have this script generated and the purpose of ending the script is to show the summary of the file created.

Installer

As justsomeone implied, it's pretty difficult to follow your code given your indentation style (or lack of it 🙂 ); I'd suggest also placing some strategic echoing of variables and some exits (so the variables will actually get displayed) to help you trace what the code is doing. Maybe some timing checks, too.

subhuman

🙁

darn, i need to have this working asap. anyway, i'll try the others. this happened to me before because i tried to do a subselect in mysql. however, this isn't a subselect and i am wondering why the script continue to load even it has performed the function.