在使用PDO時，catch Exception有兩種用法
1 | //資料庫連線失敗 |
2 | try { |
3 | $dsn = "mysql:host=localhost;dbname=eaaaaa"; |
4 | $db = new PDO($dsn,"aaaaaa","aaaa"); |
5 | } |
6 | catch (PDOException $e) { |
7 | echo $e->getMessage(); |
8 | } |
1 | //query失敗時可以利用errorCode()和errorInfo()來做例外處理，如果query沒有出錯，errorCode()會是00000 |
2 | try{ |
3 | $sql = "SELECT * FROM aaa"; |
4 | $sth = $db -> query($sql); |
5 | if( $db -> errorCode() != '00000') |
6 | { |
7 | $error = $db -> errorInfo(); |
8 | throw new PDOException($error[0]. " " .$error[1]. " " .$error[2]); |
9 | } |
10 | }catch(PDOException $e){ |
11 | print_r($e -> getMessage()); |
12 | } |
