Jump to content

Archived

This topic is now archived and is closed to further replies.

megashell

PHP page keeps loading

Recommended Posts

I installed apache, php, and mysql on my computer...whenever I have a php page that connects to a mysql database, everything works fine except the page continues to "load" even after it's done. Even if it's just simply connecting, then disconnecting, the page will load forever, plus php-cgi.exe is opened ( I see it in my taskmanager) for every page that does this. So if I go to 5 different pages that use mysql, they never stop loading, and I'll have 5 php-cgi.exe's open in my task manager until I manually close them. What's wrong??

thanks!

Share this post


Link to post
Share on other sites
It sounds like you have a never-ending loop somewhere in your code. I did this once by mistake, and the results were very interesting. Sorry I can't remember what caused it -- maybe someone else can, or if you post the problematic code someone can help you out.

Wendy

Share this post


Link to post
Share on other sites
No, no loop. This is all it is:

<?
$dbusername="user";
$dbpassword="pass";
$dbdatabase="db";
$db="localhost";
mysql_connect($db,$dbusername,$dbpassword);
@mysql_select_db($dbdatabase) or die( "Unable to select database");
print("Done.");
mysql_close();
?>

Share this post


Link to post
Share on other sites
Things...

1. Instead of the shorthand <? ?> use <?php ?>. This ensures better compatibility with all OS' and configurations

2. Are you sure the database is on? It may be trying to reach a database that is not running or not reachable - although the script should abort after reaching max_execution_time

3. Will it display the message "Done"?

Share this post


Link to post
Share on other sites
It may be your installation that is set up slightly wrong but it could be either mysql, apache or php so to eliminate php have you tried a simple echo "Hello World"; script.

Do your html files display ok.

Or is it just when you attempt to use mysql.

Share this post


Link to post
Share on other sites
I'm pretty sure it's not my code that's wrong. I've put PHP My Admin on there, and a PHPBB Forum, and it all works fine (connects to the database, gets stuff, etc.) but all of it is never-ending loading. A regular *.html or *.php file (with simply <? print("test"); ?>) works fine...it displays test and then stops loading. The only time I have problems is when it connects to mysql database. Even with the phpmyadmin, I can view the tables and data, but it never stops loading. I'm thinking it's something wrong with my mysql installation, but I have no idea what. Hopefully you guys do :) hehe. Any ideas?

By the way...I'm using Apache 2.0.58, PHP 5.1.4, and MySQL 4.1.

I used a help site to help me set it all up and walk me through the installation...it's tanguay.at or something like that.

Couple of things that might be of some help in troubleshooting this...
That site mentioned I should have a libmysqli.dll in my C:\PHP folder. I don't, I only have libmysl.dll.

In my php.ini, I have the following extensions:
extension=php_mysql.dll and extension=php_xsl.dll

Under the MYSQL section of the php.ini I have...
mysql.allow_persistent = On
mysql.max_persistent = -1
mysql.max_links = -1
mysql.default_port =
mysql.default_socket =
mysql.default_host =
mysql.default_user =
mysql.default_password =
mysql.connect_timeout = 60
mysql.trace_mode = Off

I'm guessing not having libmysqli.dll isn't a problem, since I think it's only MySQL Lite anyway, but I thought I'd mention it just in case.

Okay, I found the site that I used to help me walk through the install...
[a href=\"http://www.tanguay.at/installPhp5.php5?step=1\" target=\"_blank\"]http://www.tanguay.at/installPhp5.php5?step=1[/a] maybe that might help troubleshoot

Thanks :)

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.