how to get two vipb and vipe values ​​from an array

{"vipb":"2018-03-29 01:30:00","vipe":"2018-03-30 01:30:00","sdaysb":"2018-03-29 01:30:00","sdayse":"2018-05-05 01:30:00","tdaysb":"2018-03-29 01:30:00","tdayse":"2018-04-29 01:30:00","ob":"0"}

    2 answers 2

     $decoded = json_decode($your_str); // $decoded->vipb; // $decoded->vipe;

      Actually, this is not an array, but an object.

      For mysql (available in question tags)

       select field->>"$.vipb", field->>"$.vipe" from your_table