STR_REPLACE TROUBLE

Hello, I have a problem using str_replace and I'm wandering if it's not a bug of PHP.

I'm using PHP 5.3.5 compiled with MSVC6 (Visual C++ 6.0) , running with Apache 2.2.17 and windows 2008 server

I want to replace only the first occurence of a string:
$num_of_replace = 1;
str_replace("REF_PRODUIT"," COUNT(*) ","SELECT REF_PRODUIT FROM PRODUITS WHERE REF_PRODUIT = 'BIN24101' ",$num_of_replace)
the expected result is
SELECT COUNT(*) FROM PRODUITS WHERE REF_PRODUIT = 'BIN24101'  // GOOD
but it seem to not use the parameter $num_of_replace and it replace ALL occurences:
SELECT COUNT(*) FROM PRODUITS WHERE COUNT(*) = 'BIN24101'  // NOT GOOD

is there anything wrong in my code ??

Thanks for yur help !


bruno_boccaraAsked:
Who is Participating?
 
R-ByterConnect With a Mentor Commented:
Use preg_replace for that:

preg_replace("/REF_PRODUIT/"," COUNT(*) ","SELECT REF_PRODUIT FROM PRODUITS WHERE REF_PRODUIT = 'BIN24101' ",$num_of_replace)

Open in new window


Regards
0
 
bruno_boccaraAuthor Commented:
I found, this is a bug ....

http://bugs.php.net/bug.php?id=11457


0
 
Beverley PortlockConnect With a Mentor Commented:
The parameter you are using for $num_of_replace is how many replacements str_replace MADE not how many you would like it to MAKE.
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
bruno_boccaraAuthor Commented:
YOU'r right

I just see this right now...

I should use preg_replace instead.....
0
 
bruno_boccaraAuthor Commented:
SORRY SORRY
I DIDN'T SEE R-Byter ANSWER !!!

How can I fix my mistake ???
0
 
R-ByterCommented:
You can report it to mods.
But its not so important. Im glad that you have working solution. Those are my points.

Regards
0
 
Beverley PortlockCommented:
I've no objection if you want to re-open the question and assign the points differently. I'm not exactly short of points.......

0
 
bruno_boccaraAuthor Commented:
at least I will give 250 points to each of you for your help !

I ask for the moderator ....
0
 
R-ByterCommented:
@bportlock:

Just to be clear that I wasn't complaining. :)
0
 
Beverley PortlockCommented:
@R-Byter - It's OK. This is the correct thing to do. I was surprised to have my contribution accepted, I expected perhaps an assist, no more.
0
 
bruno_boccaraAuthor Commented:
Thanks to R-Byter and to bportlock for your help !!!
0
 
R-ByterCommented:
You're welcome.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.