PHP Script for parsing json data

The Client will provide you a link , you have to extract the key and values and insert into mysql
you only need to provide a working script for this job.

Link :https://taguard.in/text/


The Code has to be written in php
and Mysql Insert query

Also provide comment in the code .

the json data is in this format :
Input Data: {"msg":"advData","gmac":"94A408B03998","obj":[{"type":32,"dmac":"105BAD2F5466","data1":"1DFF2D01020001105CD91F6001F84973898CD11F13E30CFE255B772A7B67","rssi":-83,"time":"2022-08-17 19:59:02"},{"type":1,"dmac":"BC572900CDBE","time":"2022-08-17 19:59:02","rssi":-51,"ver":1,"vbatt":2987,"temp":27.57,"humidty":86.840000000000003}

Output Data

msg= advData
gmac=94A408B03998
dmac=105BAD2F5466

just provide the script in php