How to suppress db and file info on connection error?

[Claus Mygind]

When I force a failure on the connection to my MySQL server in php, I get this error message.

"<br />
<b>Warning</b>: mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (28000/1045): Access denied for user '<myUser>'@'<myServer>' (using password: YES) in <b><myApp>.php</b> on line <b>100</b><br />
An error occured : Connection failed:
"

I only want the last line to appear in my returned message "An error occured : Connection failed:
".

No matter what I have tried I cannot stop the first portion of the message from being suppressed.

Here is my code

<?php
/*-- my calling app --*/
 
try 
{
    //open connection to database
    include("db.php");
 
    $fieldList = $db->getFieldList("<myTable>");
} //end try
 
catch (exception $e) 
{
    echo 'An error occured : ' .$e->getMessage();
}
 
?>
 
 
 
<?php
/*-- this is my db.php app included above --*/
 
class dbcnx extends mysqli
{
 
    function getFieldList($t1)
    {
        ....some code here....
        return $aFieldList;
    }    
 
}
 
/* Connect to database */
$db = new dbcnx("localhost", "User", "Wrong Password", "dataBase");
 
/* check connection */
if (mysqli_connect_errno()) {
   throw new Exception("Connection failed: ");
   exit();
}
?>
 

The calling app listed above is called from the browser via an ajax call. I have a procedure for handling other errors in the ajax callback. I would like to be able to channel this error into my other routine.

help!!! please

[stepterr]

You could use the "@" for error suppression and then use die() to display the message that you'd like to be shown instead. There are some negatives to this though so you may want to read up on that. You should probably also look into changing display_errors to off in your php.ini.

[Claus Mygind]

I tried something like that and it worked fine but I did not know how to write the code when creating an object.

Could you tell me where I would put the @ in this line of code?

$db = new dbcnx("localhost", "User", "Wrong Password", "dataBase");
 

Also note whether I have a valid response or an error all is returned to my ajax call back, so I am not sure where and what I would do with the "die()" text?

Currently I feed all my response into a variable $response in the form of an array which is what I return to the calling page. Then I simply look for my indicator in cell one of the array to see it was a valid response so the page can be updated or if an error occurred in which case I display an alert on the users web page

[Samishii23]

If this is in your ajax script, then I believe there are two options. I believe. I've seen the 2nd example used in MySQLi querys, so this may also work here.

$db = new dbcnx("localhost", "User", "Wrong Password", "dataBase") or die('Fatal Error: Could not connect to database.');
 
// or maybe this...
if ( $db = new dbcnx("localhost", "User", "Wrong Password", "dataBase") )
{ /*continuation code*/ }
else
echo 'fatal error';

[mfaisalwarraich]

u can turn on/off error reporting using:

error_reporting(0); //error reporting off
error_reporting(-1); //error reporting on
 

[Claus Mygind]

Thank you very much for that tip. I am using php 5.3 and there are two .ini files

php.ini-development
php.ini-production

with your tip I started looking in the file and found this line.

display_errors = On
 

I switched over to the production (I renamed it php.ini)
it is set to "Off" and it solved my problem.