Suppressing Mysql Error In Php - How to suppress auto generated mysql err

kvkv

Feb 1 2006, 10:43 PM

I am testing my website on my local machine. It is still in development stage and I am using php/mysql. If there is a mysql connection error, I am checking for the connection variable and displaying a proper error message. But even before it displays my error message, it displays an error message on browser thrown by mysql (MySQL Connection Failed: Access denied for user).

Can I suppress this message and display only my message?

Reply

jlhaslip

Feb 1 2006, 11:41 PM

From the php.net site, we have this function:

CODE

<?php
// Turn off all error reporting
error_reporting(0); ?>

found
here. http://ca3.php.net/error_reporting
And I think that there is a way to use the '@' symbol in front of the function, but I couldn't source a link. Maybe someone else has a link for that.

But suppressing the errors won't make the logic or processes work any differently. It is best to find out what is causing the error in the first place. Since you are 'developing' the program, I would leave the full error reporting "ON" until the bugs are under control. Clearly, you want to know at this stage if anything is going wrong and fix it before implementing the code into the production environment. And using the '@' Error suppression on a function is not reccomended at the development stage, either, for the same reasons. If you are unable to connect, you want to know why that is the case and find the solution using the error reporting output.

Reply

adly3000

Feb 2 2006, 12:31 AM

i think this may help you:

CODE

<?
$hostname = "localhost";
$database = "yourdatase";
$username = "user";
$password = "pass";
@ $conn = mysql_pconnect($hostname, $username, $password);
if(!$conn)
{
echo "ERROR: Cannot connect to database. Please try again later!";
exit;
}
//select the database
$db = mysql_select_db($database);
if(!$db)
{
echo "ERROR: Cannot select database. Please try again later!";
exit;
}
?>

Reply

kvkv

Feb 2 2006, 04:51 AM

QUOTE(adly3000 @ Feb 1 2006, 07:31 PM)

i think this may help you:

CODE

<?
$hostname = "localhost";
$database = "yourdatase";
$username = "user";
$password = "pass";
@ $conn = mysql_pconnect($hostname, $username, $password);
if(!$conn)
{
echo "ERROR: Cannot connect to database. Please try again later!";
exit;
}
//select the database
$db = mysql_select_db($database);
if(!$db)
{
echo "ERROR: Cannot select database. Please try again later!";
exit;
}
?>

That is what I was doing exactly. But still it was printing standard error as well as my error. I had to set error_reporting level as jlhaslip suggested. Thanks!

Reply

Spectre

Feb 2 2006, 09:41 AM

Provided the function being called does not explicitly send any output (ie. not as an error), prefixing it with an '@' symbol causes any errors to be supressed for that single instance only.

For example:

CODE

echo file_get_contents('non_existant_file');

Will, provided error_reporting is turned on, output an error about how PHP could not find the file specified.

However:

CODE

echo @file_get_contents('non_existant_file');

Will prevent any error from being displayed (even though the error itself does actually occur).

Instead of:

CODE

@ $conn = mysql_pconnect($hostname, $username, $password);

Try:

CODE

$conn = @mysql_pconnect($hostname, $username, $password);

Hope that makes sense.

Reply

ADD REPLY / Got an Opinion!	Remove these ADs!	RAPID SEARCH!	Free Web Hosting	[X]
Express your Opinions, Thoughts or Contribute more info. to help others. Ask your Doubts & Queries to get answers, So that "Together We can help others!"	Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.		500MB Space No Ads, CPanel, FTP, PHP, MySQL, EMails - 100% FREE