on error

[Robertu]

Hi alt all
$connection = mysql_connect("12.34.5.67.89", "Sql111111","hELLOWORLD");
mysql_select_db("11111111_1")
$query = "SELECT from where...............
in any of these 3 steeps it can make error or any visitor can try to call a
different database or make irs own query
what can I do To be sure that on error in any of these 3 seep the PHP code
self call a certain page?
Thank you in advance and regards

[Erwin Moller]

Robertu wrote:

Hi alt all

Hi Robertu,

$connection = mysql_connect("12.34.5.67.89", "Sql111111","hELLOWORLD");

mysql_connect returns a value.
Check at www.php.net for details.

In this case FALSE is returned if the mysql_connect fails.
So you'll end up with something like this:
$connection = @mysql_connect("12.34.5.67.89", "Sql111111","hELLOWORLD");
if ($connection === FALSE){
echo "problem connecting...";
exit;
}

2 notes:
- The @ supresses a possible errormessage.
- the === is NOT a typo.

mysql_select_db("11111111_1")

Also, check www.php.net for returnvalues.

$query = "SELECT from where...............

This will probably not produce an error since you only construct the string.
But when you execute it you can get an error.
Also, check the returnvalue here too.

Good luck!

Regards,
Erwin Moller

in any of these 3 steeps it can make error or any visitor can try to call
a different database or make irs own query
what can I do To be sure that on error in any of these 3 seep the PHP code
self call a certain page?
Thank you in advance and regards

[Darko]

On May 18, 5:14 pm, Erwin Moller
<since_humans_read_this_I_am_spammed_too_m...@spam yourself.comwrote:

Robertu wrote:

Hi alt all

Hi Robertu,

$connection = mysql_connect("12.34.5.67.89", "Sql111111","hELLOWORLD");

mysql_connect returns a value.
Check atwww.php.netfor details.

In this case FALSE is returned if the mysql_connect fails.
So you'll end up with something like this:
$connection = @mysql_connect("12.34.5.67.89", "Sql111111","hELLOWORLD");
if ($connection === FALSE){
echo "problem connecting...";
exit;

}

2 notes:
- The @ supresses a possible errormessage.
- the === is NOT a typo.

mysql_select_db("11111111_1")

Also, checkwww.php.netfor returnvalues.

$query = "SELECT from where...............

This will probably not produce an error since you only construct the string.
But when you execute it you can get an error.
Also, check the returnvalue here too.

Good luck!

Regards,
Erwin Moller

in any of these 3 steeps it can make error or any visitor can try to call
a different database or make irs own query
what can I do To be sure that on error in any of these 3 seep the PHP code
self call a certain page?
Thank you in advance and regards

Nothing to add :)

[Robertu]

"Erwin Moller"
WROTE:

Hi Robertu,

>$connection = mysql_connect("12.34.5.67.89", "Sql111111","hELLOWORLD");

mysql_connect returns a value.
Check at www.php.net for details.

In this case FALSE is returned if the mysql_connect fails.
So you'll end up with something like this:
$connection = @mysql_connect("12.34.5.67.89", "Sql111111","hELLOWORLD");
if ($connection === FALSE){
echo "problem connecting...";
exit;
}

Hi Erwin and tank you very much
NOW I wrote
$connection = @mysql_connect("12.34.5.67.89", "Sql111111","hELLOWORLD");
if ($connection === FALSE)
{
header("www.pippo.es/");
exit();
}

can it work?

I tryed also:
$connection = @mysql_connect("12.34.5.67.89", "Sql111111","hELLOWORLD");
if ($connection === FALSE)
{
out();
}

function out()
{
header("www.pippo.it/");
exit();}

Thank you in advance and best regards

[Schraalhans Keukenmeester]

At Sat, 19 May 2007 07:19:18 +0000, Robertu let his monkeys type:

"Erwin Moller"
WROTE:

>Hi Robertu,

>>$connection = mysql_connect("12.34.5.67.89", "Sql111111","hELLOWORLD");

mysql_connect returns a value.
Check at www.php.net for details.

In this case FALSE is returned if the mysql_connect fails.
So you'll end up with something like this:
$connection = @mysql_connect("12.34.5.67.89", "Sql111111","hELLOWORLD");
if ($connection === FALSE){
echo "problem connecting...";
exit;
}

Hi Erwin and tank you very much
NOW I wrote
$connection = @mysql_connect("12.34.5.67.89", "Sql111111","hELLOWORLD");
if ($connection === FALSE)
{
header("www.pippo.es/");
exit();
}

can it work?

Use header('Location:http://www.pippo.es');

And make sure there is NO output by your script before sending the
custom header, as that will cause a header to be already sent.

HTH
Sh.