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":"[login to view URL]","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"}
✨✨✨PHP | MySQL✨✨✨
Hi sir, you're looking for a PHP expert who can store JSON to mysql database? OK, and you need me to finish soon? that's ok, No problem. Get a solution and complete your work fast with a real expert by messaging me, Thanks.
$10 USD ndani ya siku 1
5.0 (6 hakiki)
3.4
3.4
19 wafanyakazi huru wana zabuni kwa wastani $31 USD kwa kazi hii
Hi
I will build table structure and save the required JSON data into MySQL
1. Request remote URL for data
2. Parse response
3. Prepare data for MySQL insertion
4. Insert data and make sure it is stored or show error
Excited to finish this for you in couple of hours
Best Regards
PHP JSON MYSQL EXPERT here.
Hello, How are you?
I can parse this raw JSON by PHP and properly store to MySQL database.
Please send me a message so that we can discuss more.
Thanks.
Hi, there.
My name is Alik and as you can see my profile, I am a tailent developer.
I read your description carefully and I analyzed your requirements.
As a excellent developer, I’ve been working for 10 years perfectly and smartly and I am absolutely sure that I can develop the project very well because I have lots of hands-on experience with in Node.js, Laravel, Codeigniter, PHP, Wordpress, JavaScript, HTML, Vuejs, Reactjs, React Native, Vue, Angular and MySQL and I have ever been done similar it.
One more important thing, I am a time-conscious and detail-oriented developer. In addition, I am a person who values credit more than budget.
Thanks and Regards.
Hello there. This is Ryan from United States. I have checked your project description carefully and I think that I can help you to complete this project 100% perfectly sure to satisfy your requirement. I'd like to have a brief chat, call to discuss further details about your project soon.
Looking forward to working with you together on this project.
Thanks and Regards
Hi, I am Tuan.
I've read your description carefully.
I have full experience with PHP, MYSQL, JSON
I've also worked on several similar projects.
So I can complete your project with high quality on time.
Looking forward to hear more about the project from you via chatting.
Thanks & Best regards!
Hi, Client!
Your job posting has really caught my eyes as your requirements are in perfect match with my skills and expertise.
I joined here recently but I am a professional web developer have experience in this field for 5 years.
I am ready to start work immediately and I can work full day.
Let's chat more about your project.
I'm looking forward upcoming contact with you.
Thanks & regards!
Hello, I can create a code which will going to Store this JSON data Into Mysql Database as you want. I have done this kind of things many times. Just let me know when you are here so we can discuss. Thanks