MySQL error stops page rendering

**Jerry Stuckle** · Apr 2 '07, 04:25 PM

Re: MySQL error stops page rendering

Justin.Voelker wrote:

Can anyone clue me on on how to have my html page continue rendering
past a MySQL error? If you visit www.Base2WebDesign.com, click login,
type in anything for a username and password, then view the page
source. You will see that the page displays the error then just stops
rendering the html. (I know what the error is, I deleted that table
on purpose for a simple way to show you what I would like fixed.)
This doesn't cause any problems on this particular page (other than it
fails vailidation) but I some of my website I have other information
below those errors and even the remainder of the page. If it hits an
error I would like the remainder of the page to still be displayed,
just display the error and keep moving. Is there anyway to do this?
Thank you so much for anyone that can help me out!
>

That depends. Why is the page stopping? A mysql error won't stop the
PHP code from running. You must be doing something to make it stop.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===

**Justin.Voelker** · Apr 2 '07, 04:25 PM

Re: MySQL error stops page rendering

On Apr 2, 1:16 pm, Jerry Stuckle <jstuck...@attg lobal.netwrote:

Justin.Voelker wrote:

Can anyone clue me on on how to have my html page continue rendering
past a MySQL error? If you visitwww.Base2W ebDesign.com, click login,
type in anything for a username and password, then view the page
source. You will see that the page displays the error then just stops
rendering the html. (I know what the error is, I deleted that table
on purpose for a simple way to show you what I would like fixed.)
This doesn't cause any problems on this particular page (other than it
fails vailidation) but I some of my website I have other information
below those errors and even the remainder of the page. If it hits an
error I would like the remainder of the page to still be displayed,
just display the error and keep moving. Is there anyway to do this?
Thank you so much for anyone that can help me out!

>
That depends. Why is the page stopping? A mysql error won't stop the
PHP code from running. You must be doing something to make it stop.
>
--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attgl obal.net
=============== ===

Right now my statements are as follows:

$sql = "SELECT
ul_id,ul_userna me,ul_password, ul_admin_level, ul_login_id FROM
user_login WHERE ul_username='$v ul_username'";
$result = mysql_query($sq l) or die('Query failed: ' . mysql_error());

Could I change the "or die" part so it would display the message but
continue rendering the page?

**Jerry Stuckle** · Apr 2 '07, 05:55 PM

Re: MySQL error stops page rendering

Justin.Voelker wrote:

On Apr 2, 1:16 pm, Jerry Stuckle <jstuck...@attg lobal.netwrote:

>Justin.Voelk er wrote:

>>Can anyone clue me on on how to have my html page continue rendering
>>past a MySQL error? If you visitwww.Base2W ebDesign.com, click login,
>>type in anything for a username and password, then view the page
>>source. You will see that the page displays the error then just stops
>>rendering the html. (I know what the error is, I deleted that table
>>on purpose for a simple way to show you what I would like fixed.)
>>This doesn't cause any problems on this particular page (other than it
>>fails vailidation) but I some of my website I have other information
>>below those errors and even the remainder of the page. If it hits an
>>error I would like the remainder of the page to still be displayed,
>>just display the error and keep moving. Is there anyway to do this?
>>Thank you so much for anyone that can help me out!

>That depends. Why is the page stopping? A mysql error won't stop the
>PHP code from running. You must be doing something to make it stop.
>>
>--
>============== ====
>Remove the "x" from my email address
>Jerry Stuckle
>JDS Computer Training Corp.
>jstuck...@attg lobal.net
>============== ====

>
Right now my statements are as follows:
>
$sql = "SELECT
ul_id,ul_userna me,ul_password, ul_admin_level, ul_login_id FROM
user_login WHERE ul_username='$v ul_username'";
$result = mysql_query($sq l) or die('Query failed: ' . mysql_error());
>
Could I change the "or die" part so it would display the message but
continue rendering the page?
>

It's doing exactly what you tell it to. You're telling the PHP code to
exit immediately, and it is.

You need to learn how to more gracefully handle errors. mysql_xxx calls
generally return false when they fail. You can test on this and echo an
error message.

How I wish there weren't so many bad tutorials out there!

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===

**Justin Voelker** · Apr 2 '07, 07:55 PM

Re: MySQL error stops page rendering

On Apr 2, 2:48 pm, Jerry Stuckle <jstuck...@attg lobal.netwrote:

Justin.Voelker wrote:

On Apr 2, 1:16 pm, Jerry Stuckle <jstuck...@attg lobal.netwrote:

Justin.Voelker wrote:
>Can anyone clue me on on how to have my html page continue rendering
>past a MySQL error? If you visitwww.Base2W ebDesign.com, click login,
>type in anything for a username and password, then view the page
>source. You will see that the page displays the error then just stops
>rendering the html. (I know what the error is, I deleted that table
>on purpose for a simple way to show you what I would like fixed.)
>This doesn't cause any problems on this particular page (other than it
>fails vailidation) but I some of my website I have other information
>below those errors and even the remainder of the page. If it hits an
>error I would like the remainder of the page to still be displayed,
>just display the error and keep moving. Is there anyway to do this?
>Thank you so much for anyone that can help me out!
That depends. Why is the page stopping? A mysql error won't stop the
PHP code from running. You must be doing something to make it stop.

>

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attgl obal.net
=============== ===

>

Right now my statements are as follows:

>

$sql = "SELECT
ul_id,ul_userna me,ul_password, ul_admin_level, ul_login_id FROM
user_login WHERE ul_username='$v ul_username'";
$result = mysql_query($sq l) or die('Query failed: ' . mysql_error());

>

Could I change the "or die" part so it would display the message but
continue rendering the page?

>
It's doing exactly what you tell it to. You're telling the PHP code to
exit immediately, and it is.
>
You need to learn how to more gracefully handle errors. mysql_xxx calls
generally return false when they fail. You can test on this and echo an
error message.
>
How I wish there weren't so many bad tutorials out there!
>
--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attgl obal.net
=============== ===

I found a few other things to do. Now when there is no result, I call
a function which displays this sort of message...
'mysql_errno($l ink) . ": " . mysql_error($li nk);' It's user friendly
and eventually I will build in some logging that will send that info
to a database for future reference (what page they were on, date,
time, etc etc. My question to you is do you know of any other
mysql_xxx($link ) functions out there or is it just the error number
and error message?

**Jerry Stuckle** · Apr 3 '07, 12:55 AM

Re: MySQL error stops page rendering

Justin Voelker wrote:

On Apr 2, 2:48 pm, Jerry Stuckle <jstuck...@attg lobal.netwrote:

>Justin.Voelk er wrote:

>>On Apr 2, 1:16 pm, Jerry Stuckle <jstuck...@attg lobal.netwrote:
>>>Justin.Voelk er wrote:
>>>>Can anyone clue me on on how to have my html page continue rendering
>>>>past a MySQL error? If you visitwww.Base2W ebDesign.com, click login,
>>>>type in anything for a username and password, then view the page
>>>>source. You will see that the page displays the error then just stops
>>>>rendering the html. (I know what the error is, I deleted that table
>>>>on purpose for a simple way to show you what I would like fixed.)
>>>>This doesn't cause any problems on this particular page (other than it
>>>>fails vailidation) but I some of my website I have other information
>>>>below those errors and even the remainder of the page. If it hits an
>>>>error I would like the remainder of the page to still be displayed,
>>>>just display the error and keep moving. Is there anyway to do this?
>>>>Thank you so much for anyone that can help me out!
>>>That depends. Why is the page stopping? A mysql error won't stop the
>>>PHP code from running. You must be doing something to make it stop.
>>>--
>>>============ ======
>>>Remove the "x" from my email address
>>>Jerry Stuckle
>>>JDS Computer Training Corp.
>>>jstuck...@at tglobal.net
>>>============ ======
>>Right now my statements are as follows:
>>$sql = "SELECT
>>ul_id,ul_user name,ul_passwor d,ul_admin_leve l,ul_login_id FROM
>>user_login WHERE ul_username='$v ul_username'";
>>$result = mysql_query($sq l) or die('Query failed: ' . mysql_error());
>>Could I change the "or die" part so it would display the message but
>>continue rendering the page?

>It's doing exactly what you tell it to. You're telling the PHP code to
>exit immediately, and it is.
>>
>You need to learn how to more gracefully handle errors. mysql_xxx calls
>generally return false when they fail. You can test on this and echo an
>error message.
>>
>How I wish there weren't so many bad tutorials out there!
>>
>--
>============== ====
>Remove the "x" from my email address
>Jerry Stuckle
>JDS Computer Training Corp.
>jstuck...@attg lobal.net
>============== ====

>
I found a few other things to do. Now when there is no result, I call
a function which displays this sort of message...
'mysql_errno($l ink) . ": " . mysql_error($li nk);' It's user friendly
and eventually I will build in some logging that will send that info
to a database for future reference (what page they were on, date,
time, etc etc. My question to you is do you know of any other
mysql_xxx($link ) functions out there or is it just the error number
and error message?
>

Nope, just error message and error number. But I've never needed
anything else, either.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===

**Justin Voelker** · Apr 3 '07, 12:55 PM

Re: MySQL error stops page rendering

On Apr 2, 9:52 pm, Jerry Stuckle <jstuck...@attg lobal.netwrote:

Justin Voelker wrote:

On Apr 2, 2:48 pm, Jerry Stuckle <jstuck...@attg lobal.netwrote:

Justin.Voelker wrote:
>On Apr 2, 1:16 pm, Jerry Stuckle <jstuck...@attg lobal.netwrote:
>>Justin.Voelke r wrote:
>>>Can anyone clue me on on how to have my html page continue rendering
>>>past a MySQL error? If you visitwww.Base2W ebDesign.com, click login,
>>>type in anything for a username and password, then view the page
>>>source. You will see that the page displays the error then just stops
>>>rendering the html. (I know what the error is, I deleted that table
>>>on purpose for a simple way to show you what I would like fixed.)
>>>This doesn't cause any problems on this particular page (other than it
>>>fails vailidation) but I some of my website I have other information
>>>below those errors and even the remainder of the page. If it hits an
>>>error I would like the remainder of the page to still be displayed,
>>>just display the error and keep moving. Is there anyway to do this?
>>>Thank you so much for anyone that can help me out!
>>That depends. Why is the page stopping? A mysql error won't stop the
>>PHP code from running. You must be doing something to make it stop.
>>--
>>============= =====
>>Remove the "x" from my email address
>>Jerry Stuckle
>>JDS Computer Training Corp.
>>jstuck...@att global.net
>>============= =====
>Right now my statements are as follows:
>$sql = "SELECT
>ul_id,ul_usern ame,ul_password ,ul_admin_level ,ul_login_id FROM
>user_login WHERE ul_username='$v ul_username'";
>$result = mysql_query($sq l) or die('Query failed: ' . mysql_error());
>Could I change the "or die" part so it would display the message but
>continue rendering the page?
It's doing exactly what you tell it to. You're telling the PHP code to
exit immediately, and it is.

>

You need to learn how to more gracefully handle errors. mysql_xxx calls
generally return false when they fail. You can test on this and echo an
error message.

>

How I wish there weren't so many bad tutorials out there!

>

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attgl obal.net
=============== ===

>

I found a few other things to do. Now when there is no result, I call
a function which displays this sort of message...
'mysql_errno($l ink) . ": " . mysql_error($li nk);' It's user friendly
and eventually I will build in some logging that will send that info
to a database for future reference (what page they were on, date,
time, etc etc. My question to you is do you know of any other
mysql_xxx($link ) functions out there or is it just the error number
and error message?

>
Nope, just error message and error number. But I've never needed
anything else, either.
>
--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attgl obal.net
=============== ===

Thanks for all of your help Jerry. I noticed your name on quite a few
of my posts recently and I want to thank you for all of the wonderful
help and great answers.

MySQL error stops page rendering

MySQL error stops page rendering

Comment

Comment

Comment

Comment

Comment

Comment