I have a problem with str_replace():
when I try to use it in this way:
$phrase = "INSERT INTO addressbook(user_id, email, name) VALUES( 10 , 4 , 0 ) ON DUPLICATE KEY UPDATE(user_id= 10 )";
$healthy = array("10","4","0");
$yummy = array("FLA",".0797",".0700");
$newphrase = str_replace($healthy, $yummy, $phrase);
echo 'www: '.$newphrase;
Instead of getting what I would expected:
INSERT INTO addressbook(user_id, email, name) VALUES( FLA , .0797 , .0700 ) ON DUPLICATE KEY UPDATE(user_id= FLA )
I get this:
INSERT INTO addressbook(user_id, email, name) VALUES( FLA , ..0700797 , .0700 ) ON DUPLICATE KEY UPDATE(user_id= FLA )
could someone please tell me what is the mistake or error?
thanks in advance