Jake McHenry wrote:
Hi everyone,
I have been searching and trying to do this for the past hour without
success yet....
I have a database table with this in it:
<p>$name<p>
Period Ending Date: $ppe<p>
Etc.......
And in my script, these variables exist and have values. Is there a way for
me to get the output from mysql_query to use the current script variables in
place of the same variable name within the database output?
Thanks,
Jake
If I read the manual correct about how to setup the input values for str_replace()
you should be able to do the following.
This is completely untested, since I have now system like yours. But here is goes...
#setup the entries that you want to find.
$find[] = '$name';
$find[] = '$ppe';
#setup the values to be replaced.
#Mind you to keep the indexes the in sync with $find...
$replace[] = $name;
$replace[] = $ppe;
echo '<pre>';
while ( $row = mysql_fetch_assoc($resultHandle) ) {
$row = str_replace($find, $replace, $row);
// do something with $row. Display it maybe...
var_dump($row);
}
echo '</pre>';
Basically replace $find[0] with $replace[0] in any of the values of the return $row then replace the
previous $row values with the newly modified values... Then go to the next index of $find[1] and
$replace[1] and do the same thing until you are out of indexes.
But this is a much better way of doing this than using eval(). eval is an evil little function!
--
Enjoy,
Jim Lucas
Different eyes see different things. Different hearts beat on different strings. But there are times
for you and me when all such things agree.
- Rush
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
