How to replace substrings with strings from array using preg_replace? (PHP)

Question

I have a data array containing these values:

Array
(
    [id] => 1
    [myid] => 9
    [date] => 2014-01-30
    [user] => 17
    [reason] => some text here...
)

And this string which contains numbers referring to the data array indexes:

$columns = '(0) as "id",(1) as "myid",(2) as "date",(3) as "user",(4) as "reason"';

Is it possible to change the numbers enclosed in brackets, including brackets to appropriate value from the array?

I know how to work with (string) preg_replace( (array) $patterns, (array) $replacements, (string) $subject) but quite don't know how to solve this problem.

Ideally the result string could look like this:

'1' as "id",'9'  as "myid",'2014-01-30'  as "date",'17'  as "user",'some text here...'  as "reason"

Have a look at array_walk() or array_reduce() to build a single string. — Pinke Helga
– Pinke Helga, Commented May 16, 2016 at 8:35
Why you need to change the string, why not new string from array? — Murad Hasan
– Murad Hasan, Commented May 16, 2016 at 8:46
Quasimodo's clone: For Sqlite query @Frayne Konok: I could do it so, this would be the simplest way. — John Boe
– John Boe, Commented May 16, 2016 at 9:02

RomanPerekhrest · Accepted Answer · 2016-05-16 09:06:27Z

2

The solution using preg_replace_callback and str_replace functions:

$columns = '(0) as "id",(1) as "myid",(2) as "date",(3) as "user",(4) as "reason"';

// $arr is your initial array
$result = preg_replace_callback(
                "/(\(\d\)) as \"(\w+?)\",?/i",
                function ($maches) use($arr){
                     return str_replace([$maches[1]], "'". $arr[$maches[2]]. "'", $maches[0]);
                },
                $columns);

print_r($result);

The output:

'1' as "id",'9' as "myid",'2014-01-30' as "date",'17' as "user",'some text here...' as "reason"

edited May 16, 2016 at 9:06

answered May 16, 2016 at 9:02

RomanPerekhrest

93.1k4 gold badges75 silver badges112 bronze badges

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

3 Comments

John Boe Over a year ago

Thank you. I accept your question because I think this is best answer. Nevertheless the Frayne's suggestion in comments is my current solution.

RomanPerekhrest Over a year ago

yes, the Frayne's suggestion would be quite reasonable if you are dealing with a real code(production). But I've presented the solution as a solution for your current "abstract" test case. Anyway, thanks

Murad Hasan Over a year ago

That's great, I also make an answer using some PHP library functions.

Mihai Matei · Accepted Answer · 2016-05-16 08:46:45Z

2

You can do it with a simple foreach loop:

$info = array(
    'id' => 1,
    'myid' => 9,
    'date' => '2014-01-30',
    'user' => 17,
    'reason' => 'some text here...'
);

$columns = '(0) as "id",(1) as "myid",(2) as "date",(3) as "user",(4) as "reason"';

foreach (array_values($info) as $key => $value) {
    $columns = str_replace(
        '(' . $key . ')',
        str_pad($value, strlen($value) + 2, "'", STR_PAD_BOTH),
        $columns
    );
}

echo $columns;

answered May 16, 2016 at 8:46

Mihai Matei

24.3k5 gold badges34 silver badges50 bronze badges

2 Comments

splash58 Over a year ago

What if the string starts with $columns = '(0) as "myid",(1) as "id", ?

Murad Hasan Over a year ago

ha ha ha, There is a lot of questions, But the OP's requirement is resolved .

Murad Hasan · Accepted Answer · 2016-05-16 09:21:34Z

1

You can do it using just some PHP library functions.

$info = array(
    'id' => 1,
    'myid' => 9,
    'date' => '2014-01-30',
    'user' => 17,
    'reason' => 'some text here...'
);

$columns = '(0) as "id",(1) as "myid",(2) as "date",(3) as "user",(4) as "reason"';

$new_Arr = array();
$column_arr = explode(",", $columns);
foreach($column_arr as $values){
    $arr = explode(" as ", $values);
    $new_Arr[] = "'".$info[trim($arr[1], '"')]."' as ".$arr[1];
}

echo implode(",", $new_Arr) //'1' as "id",'9' as "myid",'2014-01-30' as "date",'17' as "user",'some text here...' as "reason"

answered May 16, 2016 at 9:21

Murad Hasan

9,5932 gold badges23 silver badges43 bronze badges

2 Comments

Ravi Hirani Over a year ago

complex way but you get it. +1

Murad Hasan Over a year ago

@RaviHirani, Actually one person did it using str_pad and str_replace, Another person preg_replace_callback, So the left is foreach.

Jehy · Accepted Answer · 2016-05-16 08:40:20Z

0

Just use a loop with str_replace. Iterate through array, use loop index in brackets as a search string and replace it with corrsponding value.

answered May 16, 2016 at 8:40

Jehy

4,8991 gold badge42 silver badges56 bronze badges

Comments

ARIF MAHMUD RANA · Accepted Answer · 2016-05-16 08:41:13Z

0

array_flip is your saviour

Straight from docs

<?php
$input = array("oranges", "apples", "pears");
$flipped = array_flip($input);

print_r($flipped);
?>

The above example will output:

Array
(
    [oranges] => 0
    [apples] => 1
    [pears] => 2
)

answered May 16, 2016 at 8:41

ARIF MAHMUD RANA

5,2063 gold badges39 silver badges58 bronze badges

Collectives™ on Stack Overflow

How to replace substrings with strings from array using preg_replace? (PHP)

5 Answers 5

3 Comments

2 Comments

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

3 Comments

2 Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related