Re: PDO Exception Handling Question

On 4/2/06, Rodney Topor <r.topor@griffith.edu.au> wrote: > I've just started using PDO with PHP 5.1 and MySQL 5.0. Everything > seems to work fine, except for one issue with the following example > from the PHP manual. > > <?php > try { > $dbh = new PDO('mysql:host=localhost;dbname=test', $user, $pass); > foreach ($dbh->query('SELECT * from FOO') as $row) { > print_r($row); > } > $dbh = null; > } catch (PDOException $e) { > print "Error!: " . $e->getMessage() . "<br/>"; > die(); > } > ?> > > If an error occurs in creating the new PDO instance, or in issuing the > PDO query, then a PDOException should be raised. But nothing is ever > printed. I've tried running this script, forcing an exception, both > from the command line and from the server. But nothing is ever > printed. What do I have to do to see the printed string in the > catch-block? Do you mean it doesn't print anything or it doesn't get into the catch block? ie it prints "Error!:<br/>" or it doesn't get into that section at all? -- Postgresql & php tutorials http://www.designmagick.com/