[resolved] How to massive change field values via SQL query

and I tried your solution, micker :

<?php if (isset($item->positions)) : ?>
<?php foreach ($item->positions as $field) : ?>
<?php echo str_replace("link","toto",$field->display ? $field->display : ''); ?>
<?php endforeach; ?>
<?php endif; ?>

but result is that link is getting broken as new text "toto" is not original one in system --+ does not work neither

cool think to edit you post to add solved icone thanks

Your SQL query replacing the value needs to be more specific so that it replaces only the desirable text parts but leaves other part intact,

Also note that data are PHP serialized if you replace text of 5 characters with text of 6 characters then the serialized data may get broken

I don't know in which way mysql request has to be more specific ? maybe could you light me here ?

and you mean that I cannot replace text displayed by image for exemple, as number of characters will be differents ?! this si why link get broken ?!

so you mean there is no solution for my question here ?

tonnick wrote: and I tried your solution, micker :

<?php if (isset($item->positions)) : ?>
<?php foreach ($item->positions as $field) : ?>
<?php echo str_replace("link","toto",$field->display ? $field->display : ''); ?>
<?php endforeach; ?>
<?php endif; ?>

but result is that link is getting broken as new text "toto" is not original one in system --+ does not work neither

hello,
please note that your question is a kind of General PHP and general SQL question,

nevertheless the above should work,
why you say that the above is not working?
e.g. what is the above producing ? an result example of it



Why do you say that thus does not work? what is the result
also maybe try this:

ok here are results :

/*** PHP ***/

<?php echo str_replace("link","@",$field->display ? $field->display : ''); ?>

>>> it display right text, but link get as following :

http://mydomain/index.php/fr/ig-i-r%C3%A9pertoire-mondial-des-ig-d%E2%80%99origin/web@/15/1300/1

So, I guess because of web@ it does not work anymore.


your solution :

<?php echo str_replace("link::","@::",$field->display ? $field->display : ''); ?>

nothing at all. >> no change



/*** Mysql ***/

1st request :

UPDATE `mybase`.`jos_flexicontent_fields_item_relations` SET `value` = replace(`value`, 'link', '@') WHERE field_id=15

instead of @ displayed, I have :

a:3:{s:4:"@";s:82:"ec.europa.eu/agriculture/quality/door/registeredName.html?denominationId=50";s:5:"title";s:4:"@";s:4:"hits";i:12;}

>> not good at all.


2nd request :

UPDATE `mybase`.`jos_flexicontent_fields_item_relations` SET `value` = replace(`value`, 'link', 'test') WHERE field_id=15

text is well displayed (test instead of link) links seems to be ok :

index.php/fr/ig-i-r%C3%A9pertoire-mondial-des-ig-d%E2%80%99origin/weblink/15/1300/1

but it stay stuck on it... as if it wouldn't be anymore link behind it....

not good either