Is there to validate json objects with another array of json in php

Question

Please I have a form parameter as follows. I am try to build a dynamic form based on the schema below. In my database, I have a table column which is json. I am trying to guide against entering anyhow data except those ones defined in the form array of objects

formDefinition = [
          {
            "key": "name",
            "value": "",
            "datatype": "string"
           },
           {
            "key": "sex",
            "value": " ",
            "datatype": "choice"
           },
           {
            "key": "occupation",
            "value": "",
            "datatype": "string"
           },
           {
            "key": "isRetired",
            "value": ,
            "datatype": "boolean"
           }
        ]

Table: employee and field name is details which is a json type.

details = [{}]

When the user fills the form and on submission, it would look as follows.

details = [{"name": "something something"}, {"sex": "male"}, {"occupation": "something" }]

I need some of validation check to see if the details has the same keys as it is defined in the form otherwise it should throw error.

I haven't tried this code as I am not sure if it is possible. Just to illustrate what I am trying to achieve.

public function dataValidator($data)
{
  foreach($data as $key => $value){
    foreach(formDefinition as form){
       if($key !== form['key']){
          return "invalid"
        }
     }
  }
}

shaedrich · Accepted Answer · 2022-06-25 05:31:38Z

1

Doesn't look that bad. However, only one loop is required:

public function dataValidator($data)
{
    foreach($data as $key => $value) {
        $valid = current(array_filter($formDefinition, function($form) use($key) { return $form->key === $key; }));
        if(!$valid) {
            return 'invalid';
        }
    }
}

Short tip for next time: Just try it out. That might avoid unnecessary questions since you might already get the answers from the result. And if not, you at least have sufficient debugging information to share with us ;-)

answered Jun 25, 2022 at 5:31

shaedrich

5,7633 gold badges31 silver badges47 bronze badges

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

1 Comment

Curtis Lanz Over a year ago

Thank you so much for your feedback. I would try it in the morning and get back if I have any question.

Collectives™ on Stack Overflow

Is there to validate json objects with another array of json in php

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related