Yii2, Corrupted JSON object saved in MySQL JSON field

Question

In yii2 I have an associative array, I try to save it in JSON type MySQL table's field. However, the saved value is corrupted JSON object with \ back slashes.

The above screenshot from phpmyadmin. I saving the data by the code below:


// In the update action:
//...
if ($flag) {
                        $transaction->commit();
                        Yii::$app->getSession()->setFlash('success', 'Record has been updated!');
                        $this->savedi($model);
                        return $this->redirect(['view', 'id' => $model->id]);
                    }
//...

private function savedi($model)
{
    $output = [];
    foreach ($model->invoiceItems as $i => $item){
        $output['items'][$i]['id'] = $item->item_id;
        $output['items'][$i]['title'] = $item->item->title;
        $output['items'][$i]['qty']   = $item->qty;
    }
    $model->saved = json_encode($output);
    $model->save();
}

I don't know why the JSON is corrupted like that?

I have back slashes. and I tested it and the object's string in phpmysdmin still the same. — SaidbakR
– SaidbakR, Commented Jun 20, 2022 at 11:43
Now I see, that is complete normal, because special characters are escaped inside a MYSQL string. If you load back your model and var_dump/echo/xdebug it, you will see the backslashes are gone. Ref: github.com/yiisoft/yii2/blob/… github.com/yiisoft/yii2/blob/… — Sebastian Thadewald
– Sebastian Thadewald, Commented Jun 20, 2022 at 12:22
It looks like double encode to me. Yii2 has some support for JSON fields and it's doing json_encode by itself. Try $model->saved = $output instead of encoding it yourself. — Michal Hynčica
– Michal Hynčica, Commented Jun 20, 2022 at 12:24
@MichalHynčica Oh Yes! that works fine. Thank you. Please add this hint as answer. — SaidbakR
– SaidbakR, Commented Jun 20, 2022 at 12:27

Michal Hynčica · Accepted Answer · 2022-06-20 12:33:01Z

1

The string in question looks like double encoded JSON.

The yii2 has some basic support for JSON fields which take care of encoding/decoding. So instead of calling json_encode() yourself you just need to assign array/object that should be encoded as it is.

private function savedi($model)
{
    $output = [];
    foreach ($model->invoiceItems as $i => $item){
        $output['items'][$i]['id'] = $item->item_id;
        $output['items'][$i]['title'] = $item->item->title;
        $output['items'][$i]['qty']   = $item->qty;
    }
    $model->saved = $output;
    $model->save();
}

answered Jun 20, 2022 at 12:33

Michal Hynčica

6,2711 gold badge16 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

Yii2, Corrupted JSON object saved in MySQL JSON field

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related