Regular expression question
| From: | Leon Vismer | Date: | Thu, 11 Aug 2005 08:20:39 +0000 |
| Subject: | Regular expression question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-220412@lists.php.net to get a copy of this message | ||
Hi
I would like to convert from one naming convention within a sql statement to
another.
I have the following,
<code>
$str = "insert into userComment (userID, userName, userSurname) values (0,
'Leon', 'Vismer')";
$match = array(
"/([a-z]+)(ID)/",
"/([a-z]+)([A-Z])/"
);
$replace = array(
"\$1_id",
"\$1_\$2"
);
$nstr = preg_replace($match, $replace, $str);
echo $nstr ."\n";
</code>
the above gets me to
insert into user_Comment (user_id, user_Name, user_Surname) values (0, 'Leon',
'Vismer')
however I want to get to
insert into user_comment (user_id, user_name, user_surname) values (0, 'Leon',
'Vismer')
Some help from the regex experts ;-)
Many thanks
--
Leon