how to serialize() mysql update data

Hi I want to make the serialized reading value 1 or 0 in mysql, how can I do

example code

 $query =  $wpdb->get_results('select * from wp_options where option_id = 96');


    $dizi =   unserialize($query[0]->option_value);
     
      // echo $dizi['subscriber']['capabilities']['read'];

       //print_r($dizi);

   if(array_key_exists('read', $dizi['subscriber']['capabilities'])){


       echo $dizi['subscriber']['capabilities']['read'] = 0;
       

   }

   exit;

Contents hide

Answers:

Method 1

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

You should not use raw SQL to modify roles and capabilities, it is very bad practice, and unnecessary.

Instead, use the roles API, e.g.

$role = get_role( 'subscriber' );
$role->add_cap( 'read' );

Or to add it to a specific user:

$user = new WP_User( $user_id );
$user->add_cap( 'read' );

Likewise you can remove a capability from a role:

$role = get_role( 'subscriber' );
$role->remove_cap( 'read' );

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

0 0 votes

Article Rating