Multiply table prefixes

Question

Is there a php function to replace #_ by multiple example table prefixes Test,test2,test3,test4

->from ( '#__dolar_corrent AS a' )->leftJoin ( '#__users' )

Answer 1

Has this:

str_replace ( mixed $search , mixed $replace , mixed $subject [, int &$count ] )

Applying to your case:

->from ( str_replace( '#_', 'Test', '#__dolar_corrent AS a' ) ) etc

If you want to number in one loop for example:

$from = '#__dolar_corrent AS a';
$join = '#__users';
for($i = 1; $i < 5; ++$i) {
    ...
    $pref = 'Test'.$i;
    ->from(str_replace('#_', $pref, $from))->leftJoin(str_replace('#_', $pref, $join));
    ...
}

Remember that this only makes sense if you cannot change the prefixes. With concatenation it is much simpler:

for($i = 1; $i < 5; ++$i) {
    ...
    $from = 'Test'.$i.'_dolar_corrent AS a';
    $join = 'Test'.$i.'_users';
    ->from($from)->leftJoin($join);
    ...
}

If you want to omit the 1 leaving Test, Test2, Test3 as in the question, instead of:

'Test'.$i

use:

'Test'.($i>1?$i:'')

in either case.