replace value in an array

[sweetpea]

Hello everyone,

 

I populate an array as follows (not 100% sure if this is the right way to do it - but it works  )

 

mysql_select_db($database_cn, $cn);
$query_rsMyQuery = "SELECT columna, columnb, columnc FROM mytable";
$rsMyQuery = mysql_query($query_rsMyQuery, $cn) or die(mysql_error());
$totalRows_rsMyQuery = mysql_num_rows($rsMyQuery);

$MyQueryArray = array();

while($row=mysql_fetch_assoc($rsMyQuery)) {array_push($MyQueryArray, $row);} 

mysql_free_result($rsMyQuery);

 

 

========================

 

Now I want to change a value that is in columnb. For example I have a value called 'placeholder' and I want to replace it with 'hello'.

I'm just not sure how to do this.

 

I have tried:

 

str_replace('placeholder','hello',$MyQueryArray);

 

But that didn't do anything

 

Could someone help me with this?

 

Thanks in advance!

[JasonLewis]

What you would need to do is find the key for that value.

 

$MyQueryArray[array_search("placeholder",$MyQueryArray)] = "hello";

[sweetpea]

Thanks for your reply,

 

I've tried it, but it replaces everything to 'h    ' - for all values in all columns, not the result I was looking for.

Or am I missing something?

 

Thanks!

[JasonLewis]

Wait...

 

Can you please post the results of this so that we can get a better understanding of your array structure.

 

echo "<pre>";
print_r($MyQueryArray);
echo "</pre>";

 

Just put that after the loop.

[sweetpea]

Here's an example of the output, hope this helps.

 

Thanks for your help.

 

 

<pre>Array
(
    [0] => Array
        (
            [columna] => placeholder
            [columnb] => somename1
            [columnc] => placeholder
        )

    [1] => Array
        (
            [columna] => valuegoeshere
            [columnb] => somename2
            [columnc] => anothervaluegoeshere
        )
)
</pre>

[Garethp]

$Find = "placeholder";

$Replace = "hello";

$Array = preg_replace($Find, $Replace, $Array);

[sweetpea]

Same result, it's a multidimensional array (?!)

[sweetpea]

The solution:

 

unction array_str_replace( $sSearch, $sReplace, &$aSubject ) {

foreach( $aSubject as $sKey => $uknValue ) {

if( is_array($uknValue) ) {

array_str_replace( $sSearch, $sReplace, $aSubject[$sKey] );

} else {

$aSubject[$sKey] = str_replace( $sSearch, $sReplace, $uknValue );

}

}

}

array_str_replace( 'test', 'hello', $MyArray );

 

Thanks to all who responded.

[kenrbnsn]

You can also use the function array_walk_recursive()

<?php
$test = Array(Array(
            'columna' => 'placeholder',
            'columnb' => 'somename1',
            'columnc' => 'placeholder'
        ),
	Array(
            'columna' => 'valuegoeshere',
            'columnb' => 'somename2',
            'columnc' => 'anothervaluegoeshere'
        )
);
function array_replace(&$item, $key, $rep) {
list ($orig,$repl) = explode(',',$rep);
$item = ($item == $orig)?$repl:$item;
}

echo '<pre>Before: ' . print_r($test,true) . '</pre>';
array_walk_recursive($test, 'array_replace', 'placeholder,hello');
echo '<pre>After: ' . print_r($test,true) . '</pre>';
?>

 

Ken

[sweetpea]

Ken,

 

Thank you very much!

 

I'm assuming that it would be faster than the one I had?

 

Just curious, let's say I had two or more values to replace - but don't want to go through the complete array each time like:

 

array_walk_recursive($test, 'array_replace', 'placeholder,hello');

array_walk_recursive($test, 'array_replace', 'placeholder2,hello2');

 

What would be the best way to tackle that?

 

Thanks!

 

 

[sasa]

try

<?php
function my_replace($search, $replace, $array){
if (is_array($search) and is_array($replace) and count($search) != count($replace)) return false;
if (is_array($search)) foreach ($search as $k => $v) $search[$k] = 's:'.strlen($v).':"'.$v.'";'; else $search = 's:'.strlen($search).':"'.$search.'";';
if (is_array($replace)) foreach ($replace as $k => $v) $replace[$k] = 's:'.strlen($v).':"'.$v.'";'; else $replace = 's:'.strlen($replace).':"'.$replace.'";';
$array = serialize($array);
$array = str_replace($search, $replace, $array);
return unserialize($array);
}

$test = Array
(
    Array(array('columna' => 'placeholder', 'columnb' => 'somename1', 'columnc' => 'placeholder'),'columnx' => 'placeholder'),
Array('columna' => 'valuegoeshere', 'columnb' => 'somename2', 'columnc' => 'anothervaluegoeshere')
);
$test = my_replace(array('somename1', 'somename2'), array('sasa', 'john'), $test);
print_r($test);
?>