By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,109 Members | 969 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,109 IT Pros & Developers. It's quick & easy.

mysql apache - page never finish loading

P: n/a

Hi all,

I am new to PHP, Apache and Mysql. But I least I have managed to
install everything on my home computer on my own and everything is up
and running. I can fetch data from the database and display it. So far,
so good.

However, I'm stuck on an irritating problem. Whenever I connect to
mysql, my PHP pages don't want to finish loading. In the following
example, the page will not finish loading nor display "abc" until I
interupt by pressing "Stop" in the web browser".

<?php
echo 'a';
$link = mysql_connect('localhost', 'user', 'pwd');
echo 'b';
mysql_close($link);
echo 'c';
?>

I am running Apache 2.2.2 and Mysql 5.0.

Any help appreciated.

-Anders Bondensson

Jul 8 '06 #1
Share this Question
Share on Google+
6 Replies


P: n/a
*** th*********@my-deja.com escribió/wrote (8 Jul 2006 03:22:00 -0700):
However, I'm stuck on an irritating problem. Whenever I connect to
mysql, my PHP pages don't want to finish loading. In the following
example, the page will not finish loading nor display "abc" until I
interupt by pressing "Stop" in the web browser".

<?php
echo 'a';
$link = mysql_connect('localhost', 'user', 'pwd');
echo 'b';
mysql_close($link);
echo 'c';
?>
Your code looks flawless to me. I'd say the problem could be in third-party
software, such as:

- Antivirus
- Firewall
- Proxy
....

If you are using Windows, there's an Apache directive you can try (add it
to httpd.conf file):

EnableSendfile Off
EnableMMAP Off
Win32DisableAcceptEx

This seems to fix some Windows specific problems. If it works for you
please let me know.
--
-+ http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
++ Mi sitio sobre programación web: http://bits.demogracia.com
+- Mi web de humor con rayos UVA: http://www.demogracia.com
--
Jul 8 '06 #2

P: n/a

Alvaro G. Vicario skrev:
*** th*********@my-deja.com escribió/wrote (8 Jul 2006 03:22:00 -0700):
However, I'm stuck on an irritating problem. Whenever I connect to
mysql, my PHP pages don't want to finish loading. In the following
example, the page will not finish loading nor display "abc" until I
interupt by pressing "Stop" in the web browser".

<?php
echo 'a';
$link = mysql_connect('localhost', 'user', 'pwd');
echo 'b';
mysql_close($link);
echo 'c';
?>

Your code looks flawless to me. I'd say the problem could be in third-party
software, such as:

- Antivirus
- Firewall
- Proxy
...

If you are using Windows, there's an Apache directive you can try (add it
to httpd.conf file):

EnableSendfile Off
EnableMMAP Off
Win32DisableAcceptEx

This seems to fix some Windows specific problems. If it works for you
please let me know.
Thank for your help. Unfortunately this did not fix the problem. I have
added the above lines to the httpd.conf file, i have inactivated both
firewall and anti virus, all in various combinations. Not sure what to
do with the proxy server. Don't think I am using one, but I could be
mistaken.

Opera and IE behaves somewhat differently. With Opera, the "abc" will
be displayed when I press "stop" in the browser. For IE, "abc" will
never be displayed. The page will just not load.

All this happens whenver I connect to mysql. Regular html or php pages
will load happily.

-Anders Bondensson

Jul 9 '06 #3

P: n/a
i would stick in an ' or die (mysql_error ()); ' at the end of the
statement, probably is coming across an error but for some reason keeps
trying.. you really should have that on all your sql queries.

Flamer.

th*********@my-deja.com wrote:
Alvaro G. Vicario skrev:
*** th*********@my-deja.com escribió/wrote (8 Jul 2006 03:22:00 -0700):
However, I'm stuck on an irritating problem. Whenever I connect to
mysql, my PHP pages don't want to finish loading. In the following
example, the page will not finish loading nor display "abc" until I
interupt by pressing "Stop" in the web browser".
>
<?php
echo 'a';
$link = mysql_connect('localhost', 'user', 'pwd');
echo 'b';
mysql_close($link);
echo 'c';
?>
Your code looks flawless to me. I'd say the problem could be in third-party
software, such as:

- Antivirus
- Firewall
- Proxy
...

If you are using Windows, there's an Apache directive you can try (add it
to httpd.conf file):

EnableSendfile Off
EnableMMAP Off
Win32DisableAcceptEx

This seems to fix some Windows specific problems. If it works for you
please let me know.

Thank for your help. Unfortunately this did not fix the problem. I have
added the above lines to the httpd.conf file, i have inactivated both
firewall and anti virus, all in various combinations. Not sure what to
do with the proxy server. Don't think I am using one, but I could be
mistaken.

Opera and IE behaves somewhat differently. With Opera, the "abc" will
be displayed when I press "stop" in the browser. For IE, "abc" will
never be displayed. The page will just not load.

All this happens whenver I connect to mysql. Regular html or php pages
will load happily.

-Anders Bondensson
Jul 9 '06 #4

P: n/a
Mel
On 2006-07-10 10:00:41 +1000, "flamer di******@hotmail.com"
<di******@hotmail.comsaid:
i would stick in an ' or die (mysql_error ()); ' at the end of the
statement, probably is coming across an error but for some reason keeps
trying.. you really should have that on all your sql queries.

Flamer.

I'm curious: why should you always have one on SQL function calls? I
never use them and opt for things like:

$link = @mssql_connect(CONNECTION_STUFF_HERE);
if ($link === false) {
// handle error
}
if (@mssql_select_db(DBNAME,$link) === false) {
// handle error
}
$sql = "select * from myTable";
$res = @mssql_query($res);
if ($res === false) {
// handle error
}

Normally this'd be in a class and '// handle error' would throw an
Exception. This method is used heavily in my production environment and
has yet to fail me. I'm not poo-pooing the idea of the die() or exit()
functions inline with the SQL functions, just wondering why they should
be used.

Jul 11 '06 #5

P: n/a
Mel wrote:
On 2006-07-10 10:00:41 +1000, "flamer di******@hotmail.com"
<di******@hotmail.comsaid:
>i would stick in an ' or die (mysql_error ()); ' at the end of the
statement, probably is coming across an error but for some reason keeps
trying.. you really should have that on all your sql queries.

Flamer.

I'm curious: why should you always have one on SQL function calls? I
never use them and opt for things like:

$link = @mssql_connect(CONNECTION_STUFF_HERE);
if ($link === false) {
// handle error
}
if (@mssql_select_db(DBNAME,$link) === false) {
// handle error
}
$sql = "select * from myTable";
$res = @mssql_query($res);
if ($res === false) {
// handle error
}

Normally this'd be in a class and '// handle error' would throw an
Exception. This method is used heavily in my production environment and
has yet to fail me. I'm not poo-pooing the idea of the die() or exit()
functions inline with the SQL functions, just wondering why they should
be used.
Mel,

I'm with you. I don't use "or die..." either. I'd rather check the
results, and if they aren't good, handle the problem.

It's very unsettling to a user to have your pages break because of some
minor database problem. It's even worse to have the error message
displayed in their browser. Better to log the error and put up
something like "I'm sorry but we're having problems right now" type of
message.

And for production machines I can even have it email me the error so I
know something bad happened. Saves having to look through error logs.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
Jul 11 '06 #6

P: n/a
Hi Flamer,

The problem is not lack of error handling, and the snippet I submitted
was just to illustrate the point. I am pretty sure that my problem
isn't the PHP code itself. Rather it has something to do with the
settings on the computer I am using at home. Firewalls, anitvirus, and
such, as suggested earlier, seemed like a possible source of my
problems, but unfortunately it didn't help to turn it all off.

I was hoping that this was some kind of "known problem" when using PHP
and mysql, but I guess I had no such luck.

Anyway, thanks for your efforts!

-Anders Bondensson

flamer di******@hotmail.com skrev:
i would stick in an ' or die (mysql_error ()); ' at the end of the
statement, probably is coming across an error but for some reason keeps
trying.. you really should have that on all your sql queries.

Flamer.

th*********@my-deja.com wrote:
Alvaro G. Vicario skrev:
*** th*********@my-deja.com escribió/wrote (8 Jul 2006 03:22:00 -0700):
However, I'm stuck on an irritating problem. Whenever I connect to
mysql, my PHP pages don't want to finish loading. In the following
example, the page will not finish loading nor display "abc" until I
interupt by pressing "Stop" in the web browser".

<?php
echo 'a';
$link = mysql_connect('localhost', 'user', 'pwd');
echo 'b';
mysql_close($link);
echo 'c';
?>
>
Your code looks flawless to me. I'd say the problem could be in third-party
software, such as:
>
- Antivirus
- Firewall
- Proxy
...
>
If you are using Windows, there's an Apache directive you can try (add it
to httpd.conf file):
>
EnableSendfile Off
EnableMMAP Off
Win32DisableAcceptEx
>
This seems to fix some Windows specific problems. If it works for you
please let me know.
Thank for your help. Unfortunately this did not fix the problem. I have
added the above lines to the httpd.conf file, i have inactivated both
firewall and anti virus, all in various combinations. Not sure what to
do with the proxy server. Don't think I am using one, but I could be
mistaken.

Opera and IE behaves somewhat differently. With Opera, the "abc" will
be displayed when I press "stop" in the browser. For IE, "abc" will
never be displayed. The page will just not load.

All this happens whenver I connect to mysql. Regular html or php pages
will load happily.

-Anders Bondensson
Jul 17 '06 #7

This discussion thread is closed

Replies have been disabled for this discussion.