RE: [PHP] Parsing database variables

Ok, this is working good, except for one problem... I have variable
$pay_rate and $pay_rate_bap ... It finds $pay_rate first and then it never
finds $pay_rate_bap because it changes it to say.. 21_bap... Anyone know of
anything else that may work? I have been messing around with eval, and I
havn't gotten it to work even once yet... Always comes back with error at
line 5 of eval'd.... And line 5 of the paragraph is a blank line... Line 4
is plain text... Not even a variable until line 12...

I guess next I will play around with preg_replace, but I'm thinking I will
have the same problem as I did with str_replace... As long as the variable
names have any kind of similar names.... Correct? I can resolve this I
suppose, but the data is already in place and trying to work around it...

Thanks,
Jake



-----Original Message-----
From: Jim Lucas [mailto:lists@xxxxxxxxx]
Sent: Friday, March 30, 2007 7:32 PM
To: Jake McHenry
Cc: php-general@xxxxxxxxxxxxx
Subject: Re: [PHP] Parsing database variables

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

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.23/740 - Release
Date: 3/30/2007 1:15 PM



--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.23/740 - Release Date: 3/30/2007
1:15 PM

.

Relevant Pages

  • [F8] Local fedora bug reporting system woes?
    ... Subject: Cron /usr/sbin/moodle-cron ... No virus found in this incoming message. ... Checked by AVG Free Edition. ...
    (Fedora)
  • Re: Multiple Subchannel Set Usage
    ... make sure the bases defined as 3390B and the aliases defined as ... No virus found in this outgoing message. ... Checked by AVG Free Edition. ... No virus found in this incoming message. ...
    (bit.listserv.ibm-main)
  • RE: Problem with DBI::Multiplex
    ... No virus found in this incoming message. ... Checked by AVG Free Edition. ... No virus found in this outgoing message. ...
    (perl.dbi.users)
  • Re: [PHP] Alternative/Addition to using a CAPTCHA
    ... Hmm, just wanted to say that Jake, is it because i have my resolution ... >> No virus found in this incoming message. ... >> Checked by AVG Free Edition. ...
    (php.general)
  • RE: [PHP] Cannot send a hyperlink
    ... No virus found in this incoming message. ... Checked by AVG Free Edition. ... Cannot send a hyperlink ...
    (php.general)