Regular expression to replace query

Question

can someone make a regular expression FOR NOTEPAD++ for me to replace this query:

mysql_query($query, $db);

replace by:

$mysqli->query($query)

But $query could also have another variable name, for example $query_2, so the output should be

$mysqli->query($query2)

Thank you!

you need an regular expression to change your source code? Don't you need a search & replace on your project? — Chris Laarman
– Chris Laarman, Commented Jul 18, 2013 at 22:19
Yes, I need it to change my source code. And that's indeed what I need! — Jordy
– Jordy, Commented Jul 18, 2013 at 22:20
Yes, I want to do that, but my website is very complex with hundreds/thousands of query's in all my scripts, so I would like to create a Regular Expression to replace them. — Jordy
– Jordy, Commented Jul 18, 2013 at 22:22

AbsoluteƵERØ · Accepted Answer · 2013-07-19 15:04:15Z

3

Works in Notepad++ 6.3.2. This accommodates any issues with inconsistent space and tab characters potentially being used.

Search Pattern

mysql_query\(\s*\$([^,\s]+)\s*,\s*\$db\s*\);

Replacement

\$mysqli->query\(\$\1\);

(Make sure Regular Expression radio button is selected in the replace dialogue box).

test Text

mysql_query($query, $db);
mysql_query($SQL , $db);
mysql_query($query2,    $db);
mysql_query( $SQL_v4, $db );
mysql_query($AnotherSQL,$db);

Output Text

$mysqli->query($query);
$mysqli->query($SQL);
$mysqli->query($query2);
$mysqli->query($SQL_v4);
$mysqli->query($AnotherSQL);

edited Jul 19, 2013 at 15:04

answered Jul 19, 2013 at 14:48

AbsoluteƵERØ

7,8792 gold badges27 silver badges35 bronze badges

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

Comments

Racso · Accepted Answer · 2013-07-19 14:24:02Z

1

$input = 'mysql_query($asdf, $db);';
$input = preg_replace('/mysql_query\(\$(\w+), \$db\);/','\$mysqli->query(\$$1);',$input);
echo $input;

Outputs $mysqli->query($asdf);

EDIT:

On Notepad++, try this:

Find what: mysql_query$\$(\w+), *\$db$;
Replace with: \$mysqli->query$\$$1$;

edited Jul 19, 2013 at 14:24

answered Jul 18, 2013 at 22:25

Racso

2,4691 gold badge20 silver badges24 bronze badges

8 Comments

Jordy Over a year ago

I try to place the regular expression in the Notepad++ search window, but it replaces everything to $mysqli->query($1);

Racso Over a year ago

Don't forget to check the "Regular expression" checkbox.

Jordy Over a year ago

I did, but everything is exactly replaced with \$mysqli->query(\$$1);

Racso Over a year ago

It works well for me. What do you mean by "replaces everything"? Is it erasing all your file and replacing it with that?

Jordy Over a year ago

No, he searches for the mysql_query, but for example mysql_query($query, $db); is replaced by \$mysqli->query\(\$$1);

|

Collectives™ on Stack Overflow

Regular expression to replace query

2 Answers 2

Comments

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related