Regular expression to replace mysql_fetch_array

Question

Can someone make a regular expression for Notepad++ to replace this:

mysql_fetch_array($result)

by this:

$result->fetch_array()

The variable name could also have an other name, for example:

mysql_fetch_array($result_2)

should also be replaced by

$result_2->fetch_array()

Thanks!

Answer 1

Regarding to my comment, I am still suggesting to replace them manually, however, this code might help you also:

<?php
$string = 'mysql_fetch_array($result_2)';

echo preg_replace('#mysql_fetch_array\(([^\)]+)\)#', '\\1->fetch_array()', $string);
echo preg_replace('#mysql_fetch_array\((.*?)\)#', '\\1->fetch_array()', $string);
?>

output:

$result_2->fetch_array()
$result_2->fetch_array()