Mapping MySQL column names to variable names

Question

If I use PDO and use FETCH_INTO like

...
$query->setFetchMode(PDO::FETCH_INTO, $this);
$query->execute();

I have a little problem. PHP variables are camelCase, but MySQL column names are with underscores. So I have creationDate vs creation_date.

Should I rename one side of equation to match the other one or do some 1:1 "mapping" via __set magic method (with switch command)?

erdeszt · Accepted Answer · 2012-03-30 11:45:49Z

2

Take a look at symfony's sfInflector class it does the same job (in camelize method):

http://trac.symfony-project.org/browser/branches/1.4/lib/util/sfInflector.class.php

Here's the extracted code:

$tmp = $lower_case_and_underscored_word;
$tmp = sfToolkit::pregtr($tmp, array('#/(.?)#e'    => "'::'.strtoupper('\\1')",
                                     '/(^|_|-)+(.)/e' => "strtoupper('\\2')"));

And the code from sfToolkit:

public static function pregtr($search, $replacePairs)
{
  return preg_replace(array_keys($replacePairs), array_values($replacePairs), $search);
}

answered Mar 30, 2012 at 11:45

erdeszt

7815 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

Mapping MySQL column names to variable names

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related