+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: How to prevent CI from dumping SQL on screen when err occurs? (/showthread.php?tid=4170)
Pages:
1
2
How to prevent CI from dumping SQL on screen when err occurs? - El Forum - 11-11-2007
[eluser]Derek Allard[/eluser]
I wrote something about CI error handling once... I hope its helpful.
Error Handling in CodeIgniter
How to prevent CI from dumping SQL on screen when err occurs? - El Forum - 11-11-2007
[eluser]gtech[/eluser]
Thanks for that Derek, I did read it and it is very useful!
But the problem I had to solve was a different one, as I am not writing a publicly visible web site.. more an application that runs on a webserver which a GUI can connect to either via XMLRPC or with the GUI code running on the same server (its multipurpose).
I wanted to separate my code (the model code and datamodel) from the GUI code (say controllers/views or any other technology). So that another developer (in-house or third party) can develop the front end GUI Intended for internal use.
To cut a long story short all my APIs (model functions) return in a consistent format [<error type>,<error number>,<error message>,<return value>]
Quote:error type = 0 (no error), 1 (DB error), 2 (application error)In this instance I catch the database error messages (as shown in reply 3, and turn db_debug to FALSE).
error number = the database error number or the application error number used for language translation,0 if ok
error message = the actual error message, blank if ok
return value = whatever the function returns.
this is why I find db->_error_message and db->_error_number very useful functions to have, and they work brilliantly, but I had to dig out all CIs database code to find out that I could actually do this instead of it being in the documentation.
do you think there is a case for making db->_error_message and db->_error_number external functions?
How to prevent CI from dumping SQL on screen when err occurs? - El Forum - 11-11-2007
[eluser]Derek Allard[/eluser]
I've truthfully not thought about it, but I'd be interested in any libraries you produce.
How to prevent CI from dumping SQL on screen when err occurs? - El Forum - 11-11-2007
[eluser]gtech[/eluser]
Ok, I will have a go later on today or tomorrow and post up what i've done.