How to change text in phpmyadmin?

Question

PHP

Hello! There is a table, I need to change one cell in it:

a:3:{s:18:"custom_css_post_id";i:-1;s:10:"fw_options";a:18:{s:10:"logo_image";a:2:{s:13:"attachment_id";s:3:"976";s:3:"url";s:73:"//beget.tech/wp-content/uploads/2019/04/logo7-e1554989788844.png";}s:9:"logo_text";s:2:" ";s:11:"page_header";s:1:"2";s:13:"media_support";a:2:{i:0;a:3:{s:5:"image";a:2:{s:13:"attachment_id";s:3:"604";s:3:"url";s:59:"//beget.tech/wp-content/uploads/2019/02/team_2.jpg";}s:5:"phone";s:13:"0800 123 4567";s:4:"name";s:4:"MARK";}i:1;a:3:{s:5:"image";a:2:{s:13:"attachment_id";s:3:"608";s:3:"url";s:59:"//beget.tech/wp-content/uploads/2019/02/team_6.jpg";}s:5:"phone";s:13:"0800 123 4568";s:4:"name";s:7:"JESSICA";}}s:15:"header_is_fluid";b:0;s:5:"title";s:12:"CALL AGENT &";s:9:"text_link";s:17:"BOOK APPOINTMENT:";s:10:"meta_phone";s:13:"0800 123 4567";s:10:"meta_email";s:19:"[email protected]";s:12:"meta_address";s:13:"Baker Street ";s:12:"social_icons";a:3:{i:0;a:3:{s:4:"icon";s:23:"fa fa-facebook-official";s:10:"icon_class";s:0:"";s:8:"icon_url";s:1:"#";}i:1;a:3:{s:4:"icon";s:15:"fa fa-instagram";s:10:"icon_class";s:0:"";s:8:"icon_url";s:1:"#";}i:2;a:3:{s:4:"icon";s:16:"ico-houzz-brands";s:10:"icon_class";s:0:"";s:8:"icon_url";s:1:"#";}}s:18:"button_appointment";a:1:{i:0;a:3:{s:4:"text";s:11:"we buy lots";s:4:"link";s:1:"#";s:5:"color";s:25:"btn btn-outline-maincolor";}}s:11:"page_footer";s:1:"2";s:13:"before_footer";b:1;s:12:"after_footer";b:1;s:14:"copyright_text";s:73:"© Copyright <span class="copyright_year">2019</span> All Rights Reserved";s:23:"body_font_picker_switch";a:2:{s:17:"main_font_enabled";s:0:"";s:17:"main_font_options";a:1:{s:9:"main_font";a:10:{s:11:"google_font";b:0;s:6:"subset";b:0;s:9:"variation";b:0;s:6:"family";s:0:"";s:5:"style";s:6:"normal";s:6:"weight";s:3:"100";s:4:"size";s:2:"17";s:11:"line-height";s:2:"24";s:14:"letter-spacing";s:1:"0";s:5:"color";b:0;}}}s:20:"h_font_picker_switch";a:2:{s:14:"h_font_enabled";s:14:"h_font_options";s:14:"h_font_options";a:1:{s:6:"h_font";a:10:{s:11:"google_font";b:1;s:6:"subset";s:9:"latin-ext";s:9:"variation";s:3:"100";s:6:"family";s:7:"Poppins";s:5:"style";b:0;s:6:"weight";b:0;s:4:"size";b:0;s:11:"line-height";b:0;s:14:"letter-spacing";s:1:"0";s:5:"color";b:0;}}}}s:18:"nav_menu_locations";a:1:{s:7:"primary";i:16;}}

Here:

s:12:"CALL AGENT &";s:9:"text_link";s:17:"BOOK APPOINTMENT:";

you need to replace "CALL AGENT &" with "ours", and "BOOK APPOINTMENT:" with "contacts"

If you simply replace the text, the site is displayed incorrectly. How to do it right?

Answer 1

because it's a serialized array, it needs to be converted first and then saved again.
It breaks because in s:17:"BOOK APPOINTMENT:" 17 is not just numbers, but the number of bytes in string
example https://ideone.com/sUlbO2