Jump to content


Photo

PHP page keeps loading


  • Please log in to reply
5 replies to this topic

#1 megashell

megashell
  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 12 June 2006 - 11:11 PM

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!

#2 WendyLady

WendyLady
  • Members
  • PipPipPip
  • Advanced Member
  • 38 posts

Posted 12 June 2006 - 11:28 PM

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


#3 megashell

megashell
  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 13 June 2006 - 12:01 AM

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();
?>

#4 poirot

poirot
  • Members
  • PipPipPip
  • Advanced Member
  • 646 posts
  • LocationAustin, TX

Posted 13 June 2006 - 12:46 AM

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"?
~ D Kuang

#5 d_barszczak

d_barszczak
  • Members
  • PipPipPip
  • Advanced Member
  • 188 posts
  • LocationBradford - UK

Posted 13 June 2006 - 08:04 AM

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.

When all else fails - Try reading the manual.

Integrated IT Systems Ltd


#6 megashell

megashell
  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 13 June 2006 - 01:42 PM

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 :)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users