Re: Re: Mysql DB connect failure
| From: | Hans Prins | Date: | Fri, 21 Feb 2003 16:07:12 +0000 |
| Subject: | Re: Re: Mysql DB connect failure | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-136526@lists.php.net to get a copy of this message | ||
> Would you care to explain to the rest of the list how you intend to use
> mysql_error () to return connection failure information?
>
> It returns the text of the error message from previous MySQL operation
> Description: string mysql_error ( [resource link_identifier])
>
> Seems to me that without a connection, we wouldn't have a valid
> link_identifier.
maybe so, but it works nonetheless.............
if for example the username stated in the connection initialization was
wrong it will print an error like:
"Access denied for user: 'username@localhost' (Using password: YES)"
MI,
my code would look somethign like this:
$link = @mysql_pconnect("localhost", "test1", "test1");
// If connection failed...
if (!$link) {
// Inform user of error and quit
print "Couldn't connect to database server<br>\n";
print mysql_error();
exit;
}
"Jason K Larson" <jlarson@candlefire.org> schreef in bericht
news:3E564B92.4070703@candlefire.org...
> Would you care to explain to the rest of the list how you intend to use
> mysql_error () to return connection failure information?
>
> It returns the text of the error message from previous MySQL operation
> Description: string mysql_error ( [resource link_identifier])
>
> Seems to me that without a connection, we wouldn't have a valid
> link_identifier.
>
> What you probably should attempt going for is getting something back
> from PHP itself regarding the error returned when the mysql_connect
failed.
>
> Here's a snippet from:
>
> http://www.php.net/manual/en/language.operators.errorcontrol.php
>
> If the track_errors feature is enabled, any error message generated by
> the expression will be saved in the global variable $php_errormsg. This
> variable will be overwritten on each error, so check early if you want
> to use it.
>
> Hope that clears things up a bit.
>
> Regards,
> Jason k Larson
>
>
>
> Hans Prins wrote:
> > did you try:
> > print mysql_error();
> >
> > "Ml" <slickmik@eden.rutgers.edu> schreef in bericht
> > news:20030221152240.57775.qmail@pb1.pair.com...
> >
>
>