problem with str_replace() when using with mysql 1

kaancho12 · Mar 2, 2005

hi,
this is a follow up from my earlier post about str_replace.
When i do a regular str_replace using the following it works fine:
$search = "<A HREF=\"/ABC/specs/10to99/pdf/abc16.pdf\">16</A>";
$replace = "<A HREF=\"/ABC/specs/10to99/pdf/abc16.pdf\">16TTTT</A>";
str_replace($search, $replace, $contents);
But when the $search, $replace are obtained through a mysql query then they dont seem to work.
while ($fetch = mysql_fetch_array($sql)){
$search = '"' . $fetch["preg"] . '"';
$replace = '"' . $fetch["preg"] . $fetch["pregReplace"] . '"';
$new_str = str_replace($search, $replace, $contents);
}
here, $fetch["preg"] and $fetch["pregReplace"] are results of a mysql query. This doesnt seem to work ??????
any idea why?????
thanks in advance
ko12

jpadie · Mar 2, 2005

can you post the text strings of $search and $replace? also i'm not sure about your use of quotes. this oculd be causing the problems. it might be easier to use this while segment:

Code:

while ($fetch = mysql_fetch_array($sql)){
$search = $fetch["preg"];
$replace = $fetch["preg"] . $fetch["pregReplace"];
$new_str = str_replace($search, $replace, $contents);
}

kaancho12 · Mar 2, 2005

here are the text strings.
$fetch["preg"] gets this:
<A HREF="/ABC/specs/10to99/pdf/abc16.pdf">16</A>
$fetch["pregReplace"] gets this:
<input type="button" name="button_16" onClick="Locat('/ABC/html/10to99/ABC16.html/');return false">

jpadie, thank you for your help in the other post.(

http://www.tek-tips.com/viewthread.cfm?qid=1015559&page=4)

actually i tried using the str_replace which you wrote but it did not work so i resorted to entering the data i received from preg_match into mysql database and then doing the str_replace and thats when i ran into the trouble above.
////// From your code Yesterday ////
//first read all the file into a string
foreach ($button as $key=>$val)
{
str_replace ($key."<\a>", $key."<\a>".$val, $contents); //ie replace with itself plus the new button code
}
$newfilename = "parsed_".$filename;
$fh=fopen($newfilename,"wb");
fwrite($fh, $contents);
fclose ($fh);
/////////////////////////////////////

If i echo the str_replace -it shows up fine and if i copy individual str_replace from that to a separate file and run the program -- it works fine but it doesnt work when i run str_replace in a while ($fetch) loop.
So, i am confused as to why this is happening.

jpadie · Mar 2, 2005

Hi

in your code posted above, the quotes were incorrect and this will be having an effect on the search string.

could you retry with the code i posted just above (which fixes the quotes issue).

you might also want to escape the strings before using them in str_replace. use addslashes() to do this. this will be having a negative effect too.

in what way did the code of yesterday "not work"? it may be easier to fix it that way - it seems a bit clunky to read a file into a database!

Justin

kaancho12 · Mar 2, 2005

in what way did the code of yesterday "not work"? it may be easier to fix it that way - it seems a bit clunky to read a file into a database!"
this is what i had:
//first read all the file into a string
foreach ($button as $key=>$val)
{
$mat = ">" . $key . "</A>" ;
$rep = ">" . $key . "</A>" . $val ;
$contentnew = str_replace($mat, $rep, $contents);
echo "str_replace($mat, $rep, $contents)";
}
echo $contentnew;
//
When i viewed "$contentnew" it was same as "$contents". The "echo "str_replace($mat, $rep, $contents)" though did give an output for individual "$button" and when i copied an individual button and ran it in a separate file it worked fine.

"could you retry with the code i posted just above (which fixes the quotes issue)."
I did retry the code without the '"' with the same result.
Thank u for helping out,
ko12

jpadie · Mar 2, 2005

did you also escape the strings?

could you post the value of the echo "str_replace" command?

kaancho12 · Mar 2, 2005

here's the echo of str_replace:
str_replace(>20</A>, >20</A><input type=\"button\" name=\"button_20\" onClick=\"Locat(\'/ABC/html/10to99/ABC20.html/\');return false\">, <html><head></td><td width=\"78%\" height=\"379\" align=\"left\" valign=\"top\"> <DIV ALIGN=\"CEABCR\">Silicon Transistor Selector Guide (Listed in Order of Package and BVCBO Rating, *TC = +25°C)</DIV><TABLE WIDTH=\"100%\" BORDER=\"1\"><TR ALIGN=\"CEABCR\" VALIGN=\"BOTTOM\"><TD COLSPAN=\"2\">ABC Type Number</TD><TD>Application</TD><TD COLSPAN=\"2\">Maximum Breakdown Voltage (Volts)</TD><TD>Maximum Collector Current (Amps)</TD><TD>Maximum Collector Dissipation (Watts)</TD><TD>Typical Forward Current Gain</TD><TD>Typical Freq (MHz)</TD><TD>Package Style</TD></TR><TR ALIGN=\"CEABCR\" VALIGN=\"BOTTOM\"><TD>NPN</TD><TD>PNP</TD><TD></TD><TD>BVCBO</TD><TD>BVCEO</TD><TD>IC</TD><TD>PD</TD><TD>hFE</TD><TD>fT</TD><TD></TD></TR><TR ALIGN=\"CEABCR\" VALIGN=\"TOP\"><TD><A HREF=\"/ABC/specs/10to99/pdf/ABC20.pdf\">20</A></TD><TD><A HREF=\"/ABC/specs/10to99/pdf/ABC20.pdf\">21</A></TD><TD>AF PO, Dr, Series Pass</TD><TD>40</TD><TD>32</TD><TD>2</TD><TD>1</TD><TD>120 Min</TD><TD>100</TD><TD ALIGN=\"LEFT\" ROWSPAN=\"4\"><IMG SRC=\"/graphics/BiPo53.gif\"></TD></TR><TR ALIGN=\"CEABCR\" VALIGN=\"TOP\"><TD><A HREF=\"/ABC/specs/10to99/pdf/ABC16.pdf\">16</A></TD><TD><A HREF=\"/ABC/specs/10to99/pdf/ABC16.pdf\">17</A></TD><TD>Low Noise Gen Purp Amp</TD><TD>50</TD><TD>40</TD><TD>0.1</TD><TD>0.3</TD><TD>270 Min</TD><TD>180/140</TD></TR><TR ALIGN=\"CEABCR\" VALIGN=\"TOP\"><TD><A HREF=\"/ABC/specs/10to99/pdf/ABC18.pdf\">18</A></TD><TD><A HREF=\"/ABC/specs/10to99/pdf/ABC18.pdf\">19</A></TD><TD>High Breakdown Vltg Large Current Capacity Driver</TD><TD>80</TD><TD>80</TD><TD>0.7</TD><TD>1</TD><TD>120 Min</TD><TD>120/100</TD></TR><TR ALIGN=\"CEABCR\" VALIGN=\"TOP\"><TD><A HREF=\"/ABC/specs/10to99/pdf/ABC22.pdf\">22</A></TD><TD>-</TD><TD>AF PO, Dr, Gen Purp Amp</TD><TD>100</TD><TD>80</TD><TD>1</TD><TD>0.9</TD><TD>120 Min</TD><TD>100</TD></TR><TR ALIGN=\"CEABCR\" VALIGN=\"TOP\"><TD>302</TD><TD>
</table>
</body>
</html>
)

jpadie · Mar 2, 2005

thanks.

i've tested this myself - a direct cut and paste from the code above, add double quotes around each function parameter, echo the results and it works just fine.

not sure why it is not working on your system!

Justin

kaancho12 · Mar 2, 2005

thanks for your input. i guess i will keep on cranking this

ko12

jpadie · Mar 2, 2005

just a thought -

are magic_quotes_runtime and magic_quotes_gpc switched off?

kaancho12 · Mar 2, 2005

hi,
i havent checked those but --

)))i got the script to work finally...had some mistakes but overall,, what u have given me worked find --just needed to think through the process of how the data was coming in

))
here's the script in the end:
///////////////////////////////////////////////////////////
$contentnew = $contents ;
foreach ($button as $key=>$val)
{
if ($key > 1){
//echo "key: " . $key . " val: " . $val . "\n";
$mat = ">" . $key . "</A>" ;
$rep = ">" . $key . "</A>" . $val ;
$contentnew = str_replace("$mat", "$rep", $contentnew);
}
}
///////////////////////////////////////////////////////////
thanks a lot for your help,
ko12

jpadie · Mar 2, 2005

oh dear!

that was rather a basic error from me. How embarrassing!

comes of only doing one debug cycle i guess!

glad you're up and running!

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

problem with str_replace() when using with mysql 1

kaancho12

Technical User

jpadie

Technical User

kaancho12

Technical User

jpadie

Technical User

kaancho12

Technical User

jpadie

Technical User

kaancho12

Technical User

jpadie

Technical User

kaancho12

Technical User

jpadie

Technical User

kaancho12

Technical User

jpadie

Technical User

Similar threads

Part and Inventory Search

Sponsor