Robert Granlund
asked on
PHP PDO
Would somebody give me a good example of an insert statement using PDO?
ASKER
Isn't there a "try" statement?
Doesn't make any sense to me but here is the page on PDO Exceptions: http://php.net/manual/en/class.pdoexception.php
Well, try/catch only is necessary, if you run PDO in the PDO::ERRMODE_EXCEPTION mode. Default should be PDO::ERRMODE_SILENT: Just set error codes, so you only check, whether the PDOStatement::execute() returns FALSE and in that case check out PDO::errorCode and PDO::errorInfo.
If you have an error in your query, that'll happen in MySQL or whatever backend. It's your concern, certainly, but the stability of PHP is not in any danger, you just don't have a query result and should handle that. So since the error is happening in another process most likely even on a remote database server, it's not necessary to let that cause an exception in PHP.
It's a bit of taste, if your general error handling is based on exceptions, it's a simple setting and if you don't catch the exception at this level, it'll bubble up to the next higher level.
Bye, Olaf.
If you have an error in your query, that'll happen in MySQL or whatever backend. It's your concern, certainly, but the stability of PHP is not in any danger, you just don't have a query result and should handle that. So since the error is happening in another process most likely even on a remote database server, it's not necessary to let that cause an exception in PHP.
It's a bit of taste, if your general error handling is based on exceptions, it's a simple setting and if you don't catch the exception at this level, it'll bubble up to the next higher level.
Bye, Olaf.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Ray. I read that page a while back and at the time most of it went over my head. This time around it really cleared a few this up. Thanks.
http://www.mustbebuilt.co.uk/php/insert-update-and-delete-with-pdo/
Or what other aspect of PDO is uncelar to you?
You don't have to use prepared statements, but it's a big advantage to do that.
Bye, Olaf.