MySQL PDO - Setting Default Fetch Mode?

Question

So today, I'm finally making the transition from standard PHP MySQL functions to PDO. I noticed when fetching data as an object, we must run a line similar to the following:

$STH = $DBH->query('SELECT name, addr, city from folks');
$STH->setFetchMode(PDO::FETCH_OBJ);

$result = $STH->fetch();

My question is regarding line 2. Is there a way to set this as the default behavior so that we don't need to set the fetch mode every single time we wish to run a query? This seems pretty annoying to me. Surely it's not necessary to do this?

possible duplicate of Is is possible to set a default PDO fetch mode? — Real Dreams
– Real Dreams, Commented Oct 5, 2013 at 4:45

Konrad Neuwirth · Accepted Answer · 2012-06-14 16:59:42Z

8

You can set the default fetch mode for the PDO object:

$DBH->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ);

This, of course, you do as soon as you've initialized your $DBH (PDO) object.

(For detailed documentation on this, see http://www.php.net/manual/de/pdo.setattribute.php)

answered Jun 14, 2012 at 16:59

Konrad Neuwirth

9085 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nathanael Over a year ago

Exactly what I was looking for, thanks! I'll accept this answer as soon as I can.

Collectives™ on Stack Overflow

MySQL PDO - Setting Default Fetch Mode?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related