How can I update value of array in database

Question

I am retriving following data from the database.When I do print_r, it gives me follwing result.

Array ( [0] => stdClass Object ( [params] => {"size":"980|*|485|*|1","responsive":"1|*|0","align":"normal","autoplay":"1|*|6000" } ) )

Now I want to change the value of autoplay(which is last in this array) in it.How can I do that with the update query ?

NOTE: Field name is param in database and table name is xyz.

Because json_decode($array[0]->params) would get you the object that would allow you to modify it. — Darren
– Darren, Commented Nov 3, 2014 at 5:38
Actually I am totally newbie so I don't have any Idea how can I even start.If any help from you would be highly appreciated. — Twix
– Twix, Commented Nov 3, 2014 at 5:39

Darren · Accepted Answer · 2014-11-03 05:43:40Z

2

As stated, your params is a json object. You need to decode that object so that you can use it.

$data = json_decode($item[0]->params);

$data->autoplay = 'New VALUE';

Example

answered Nov 3, 2014 at 5:43

Darren

13.1k4 gold badges44 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Twix Over a year ago

It worked like charm :) But can you tell me how can I update it in Database also ?? Will it be done by simple query like Update $tablename SET autoplay = $data->autoplay ??

Twix Over a year ago

I have tried thi query $myupdate = "update wp_nextend_smartslider_sliders set params = $data where id='3'"; but it gives me this error Object of class stdClass could not be converted to string in How can I pass string to this ?

Darren Over a year ago

$myupdate = "update wp_nextend_smartslider_sliders set params = '".json_encode($data)."' where id='3'"; would probably work.

Collectives™ on Stack Overflow

How can I update value of array in database

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related