php + replace text inside an array resulting from query

Question

this is my approach, with no success anyways, but maybe it gives you an idea of what both my code and coding skills are like, as well as what I am trying to achieve.

 $data1 = mysql_query("SELECT * from `todolist` WHERE date > '$today' ") 
 or die(mysql_error());

 $data1b = str_replace("text-to-be-replaced", "replaced-text", $data1);

while($info1 = mysql_fetch_array( $data1b )) 
 {
Print "".$info1['thingtobedone'] . " with ".$info1['persontomeet'] . "<br />";
 }

Also, my approach is incorrect since what I would like to do is set a bunch of search and replace cases. Something like a list of "search for X and replace for Y" instead of only one replacement. Originally i thought of doing something like "replace A for B and rename array as STEP2", then get array called STEP2 and "search for C and replace it for D, and rename array as STEP3" but...i think this might not be the best way to do so =/

Any recommendations, pointers, corrections will be appreciated! Thanks in advance!

What column from your SELECT statement do you wish to perform the replacement on? — Zane Bien
– Zane Bien, Commented Jul 23, 2012 at 4:13
the return value of "mysql_query" is a resource, not the data you want to search and replace — user557846
– user557846, Commented Jul 23, 2012 at 4:19

Zane Bien · Accepted Answer · 2012-07-23 04:29:25Z

1

You can use the strtr() function in PHP to pass in a key => value pair of replacement rules:

$data = mysql_query('SELECT * FROM todolist WHERE date > CURDATE()') or die(mysql_error());

// Array of replacement rules. Keys of the array are strings to be replaced.
// Corresponding values of the keys are the replacement strings
$trans = array(
    'stringtoreplace1' => 'replacedstring1',
    'stringtoreplace2' => 'replacedstring2',
    'stringtoreplace3' => 'replacedstring3'
);

while($info = mysql_fetch_array($data)) 
{
    print strtr($info['thingtobedone'], $trans) . ' with ' . $info['persontomeet'] . '<br />';
}

Assuming thingtobedone is the column you want to make the replacements on.

Then when you call strtr($info['thingtobedone'], $trans), the function will take the string and replace all occurances of every key value in the $trans array with their corresponding values. It's a nice way to make many string-replacements all at once.

edited Jul 23, 2012 at 4:29

answered Jul 23, 2012 at 4:22

Zane Bien

23.2k6 gold badges47 silver badges58 bronze badges

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

1 Comment

Khul Over a year ago

This is great! Exactly what i needed. Also, the explanation provided is very much appreciated too. Ill give it a try and let ya know how it goes! Thanks again!!

Collectives™ on Stack Overflow

php + replace text inside an array resulting from query

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related