PHP JSON MYSQL EXPERT

Job ID: 34330108

Budget: $10 – $30 USD

I have raw JSON php data I need to properly store to mysql database.

Here is the data being posted:
{"app_eui":"6081F94AF0B2","dc":{"balance":999774,"nonce":2},"decoded":{"payload":{"accuracy":0,"altitude":0,"battery":"4.14","latitude":33.76,"longitude":-118.195,"speed":"0.62"},"status":"success"},"dev_eui":"6081F8C4A9","devaddr":"10010048","downlink_url":"https://console.helium.com/api/v1/down/2229f2f0-b7c4-4b92-b3d7-c92792f85976/uThw_f9sd2X9RkdKOVFb7Tqe4NAQXKP9/1b69a587-003c-43ec-8e78-5f8acb4a8438","fcnt":0,"hotspots":[{"channel":1,"frequency":904.0999755859375,"hold_time":0,"id":"112HNaDxu7jmV2H1dTT8s5zqk7emhsGYECfzzL9qyfKy8TNYvtrq","lat":33.76013896,"long":-118.187101,"name":"mean-lilac-barracuda","reported_at":1660081554109,"rssi":-121.0,"snr":-7.800000190734863,"spreading":"SF8BW125","status":"success"}],"id":"1b69a587-003c-43ec-8e78-5f8acb4a8438","metadata":{"adr_allowed":false,"cf_list_enabled":false,"labels":[{"id":"57a69993-b47f-44eb-ac93-06bd0557a027","name":"mappers","organization_id":"2c1bc5a7-0d03-4978-a10f-73f25b7bfd94"},{"id":"cb5aa424-bb12-4b68-a0b9-0d76bc27414f","name":"cargo","organization_id":"2c1bc5a7-0d03-4978-a10f-73f25b7bfd94"}],"multi_buy":1,"organization_id":"2c1bc5a7-0d03-4978-a10f-73f25b7bfd94","preferred_hotspots":[],"rx_delay":1,"rx_delay_actual":1,"rx_delay_state":"rx_delay_established"},"name":"CUBECELLTEST01","payload":"FB+PobmMu9sBAM8=","payload_size":11,"port":2,"raw_packet":"gBABAEgAAAACl9ztj/4BmlXl3UozoDja","replay":true,"reported_at":1660081554109,"type":"uplink","uuid":"5f8f02ce-b498-4010-8a81-10d8994d818a"}
Related categories: PHP MySQL JSON