|
|
Posted by Jerry Stuckle on 04/24/07 20:10
Paul Furman wrote:
> Paul Furman wrote:
>> Jerry Stuckle wrote:
>>> Paul Furman wrote:
>>>> Jerry Stuckle wrote:
>>>>> Paul Furman wrote:
>>>>>
>>>>>> How do I turn off MySQL error reporting? I set error_reporting(0);
>>>>>> but that doesn't seem to be working.
>>>>>
>>>>> That turns off PHP error reporting.
>>>>>
>>>>> What problem are you having?
>>>>
>>>> Sorry for the slow reply. Any SQL error appears on the screen, and
>>>> sometimes that includes info I don't want included. Hmm, now that I
>>>> think of it that may be a built in error reporting system (I didn't
>>>> write all of this system). In any case is this a risk and is there a
>>>> way of turning it off? The worst case I recall was something like:
>>>>
>>>> ERROR: unable to connect to the sever using user 'admin' and
>>>> password 'mysectretpassword'
>>>>
>>>> Ha ha, I made that up as I don't recall that one but I don't want
>>>> anything like that to happen again!
>>>
>>> Preface the mysql_connect() call with an '@' character, i.e.
>>>
>>> @mysql_connect(....);
>>>
>>> This suppresses any error message for this function. Just be sure to
>>> check the response.
>>
>> Excellent, thank you!!!
>
> Hmm, well I thought that was working but maybe just on the live server
> not my home test version. Anyways I have a related question. Now I do
> want to show at least part of the error, to prevent duplicate login
> names, I set the 'unique' key on that field and tested, the test came
> back like this *first section in red I'd like to show* the next part I'd
> rather not:
>
> --
> *ERROR: Duplicate entry 'paul' for key 2* - INSERT INTO customer VALUES
> (0, 'paul','paul', '', 'paul', 'p', '', '', '', 'CA', '', '',
> '2007-04-24', 'no', '0', 'n', 'n', 'n' )
>
> Thank you! Your registration has been completed!
> --
>
> And of course I'd want at a minimum to be able to note the error &
> suppress my "thank you" message afterwards. That bit of code is simply:
>
> query($query);
> print "<p>Thank you! Your registration has been completed!</p>\n";
>
> more like this:
>
> query($query);
> if (!$error){
> print "<p>Thank you! Your registration has been completed!</p>\n";
> }
>
> Thanks for any ideas!
>
> Paul
>
>
>
Paul,
Not as easy - and a little bit user unfriendly, also.
Rather - check the result of the @mysql_query() insert. If it is false,
call mysql_errno() to get the error number.
Error code 1062 is a duplicate entry error. If you get that, the userid
already exists. If you get something else, you have a different problem.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|