Re: Re: Mysql DB connect failure

From: Date: Fri, 21 Feb 2003 16:22:31 +0000
Subject: Re: Re: Mysql DB connect failure
References: 1 2 3 4  Groups: php.general 
Request: Send a blank email to php-general+get-136528@lists.php.net to get a copy of this message
You were right Prins, I got the error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) So I guess I need to investigate what this means now... Thanks! -ML "Hans Prins" <HPrins@xgn.nu> wrote in message news:20030221160720.4236.qmail@pb1.pair.com... > > 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Ï > > õ G “ £c0 > > > > 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... > > > > > > > > >

« previous php.general (#136528) next »