Home > Archive > PHP SQL > February 2006 > Re: Help! im having trouble error handling mysqli_connect() with
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: Help! im having trouble error handling mysqli_connect() with
|
|
| J.O. Aho 2006-02-13, 6:57 pm |
| Ninja_Monkey wrote:
> hi im trying to write myself a simple database management system. and I have
> noticed that whenever i use a connect command like this:
> $connection = mysqli_connect($_POST['host'], $_POST['user'],
> $_POST['pass']);
I think you should test the variables first to see that you have at least host
and user.
/* we prevent error message to be typed out with the @ */
if($connection = @mysqli_connect($_POST['host'], $_POST['user'],$_POST['pass'])) {
/* connection went okey */
} else {
/* connection failed */
}
> if all three parts are supplied it goes ok and returns an Object which i can
> check after with is_object($connection).
> However if there is the $_POST['pass'] empty and it is required. the error
> it generates automaticly prints the error where the mysqli_connect() was
> called even if i add 'or die()' at the end.
die() don't stop error message output, it just kills the script.
//Aho
| |
| J.O. Aho 2006-02-14, 7:57 am |
| Ninja_Monkey wrote:
> thanks a lot. il give that a try. whats the @ sign for? ive never seen that
> method used before?
It's for suppressing error message outputs from functions, just place it
infront of a function which you don't want to output error messages directly
to the webpage, but do that with care as it makes it more difficult to hunt bugs.
//Aho
|
|
|
|
|