php - Value dissapears on live site after editing DB value -


i have issue wordpress premium theme , mysql database. value in database box looks this:

a:1{i:0;a:4{s:4:"name";s:9:"trailer";s:6:"select";s:6:"iframe";s:6:"idioma";s:2:"en";s:3:"url";s:82:"https://youtube.com/sample.mp4 ";}} 

when edit youtube link value else, entire data in box disappears on live wordpress page, although visible in database after refresh. have no idea why happens , how can keep happening.

edit: after tried editing other values post_title etc wont update values @ on live wp page.why im doing because need add , edit mass amounts of data scripts.

the string displaying coming php serialize. way php stringify value later usage.

if want mass modify values, best bet create php script fetch data, unserializes it, make change directly php variable created, , serialize again put database.

if want play string directly, need make sure careful.

the main reason why changing url of youtube video doesn't work because might not changing string declaration too.

s:82:"https://youtube.com/sample.mp4"; 

this invalid. split 3 parts, using :. type:length:value. string of length 82, yet provide 30 character string.

if turn on notice in php see errors it.

edit:

after tinkering bit on phpfiddle.org came clean string 1 gave, has numerous flaws...

a:1:{i:0;a:4:{s:4:"name";s:7:"trailer";s:6:"select";s:6:"iframe";s:6:"idioma";s:2:"en";s:3:"url";s:30:"https://youtube.com/sample.mp4";}} 

note changed length values in 2 parts, , added 2 semi-colon :


Comments

Popular posts from this blog

angular - Ionic slides - dynamically add slides before and after -

minify - Minimizing css files -

Add a dynamic header in angular 2 http provider -