Posted by Leon Vismer on 08/11/05 11:20

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

• Next in forum: Re: [PHP] How efficient is OOP in PHP5?
• Prev in forum: Re: [PHP] Re: dynamic object instances
• Thread view: Regular expression question

[Reply to this message]