i have a json result , i need to insert data into mysql database using "foreach"
i need to insert data of "plate" in table "plates" of mysql database
{"data":{"version":2,"data_type":"alpr_results","epoch_time":1506122578118,"img_width":1280,"img_height":720,"processing_time_ms":353.116241,"regions_of_interest":[],"results":[{"plate":"GUD512","confidence":94.449471,"matches_template":0,"plate_index":0,"region":"","region_confidence":0,"processing_time_ms":17.07235,"requested_topn":10,"coordinates":[{"x":573,"y":305},{"x":735,"y":305},{"x":735,"y":387},{"x":573,"y":387}],"candidates":[{"plate":"GUD512","confidence":94.449471,"matches_template":0},{"plate":"GUO512","confidence":85.888939,"matches_template":0},{"plate":"GU0512","confidence":85.845444,"matches_template":0},{"plate":"GUQ512","confidence":85.770973,"matches_template":0},{"plate":"GUD51Z","confidence":85.425423,"matches_template":0},{"plate":"GUDS12","confidence":84.589729,"matches_template":0},{"plate":"GUB512","confidence":84.377586,"matches_template":0},{"plate":"GUD5I2","confidence":84.24588,"matches_template":0},{"plate":"6UD512","confidence":83.99675,"matches_template":0},{"plate":"GUU512","confidence":83.365166,"matches_template":0}]}]}}
es necesario hacerlo en un sh script?
yo puedo hacerlo con php
puedes enviarme la estructura de la tabla mysql?
Relevant Skills and Experience
PHP
Proposed Milestones
$50 USD - full project
hi i can do this work in 15 min. please send me message.
Relevant Skills and Experience
json, javascript.
Proposed Milestones
$25 USD - First milestone to start
hi, i can solve your issue. i have knowledge of json, mysql and experience working on Linux.
Relevant Skills and Experience
json, mysql
Proposed Milestones
$40 USD - everything
Hello Sir, Greetings for the day. I have seen your requirement carefully you want to insert data from one table to another table using json.
you want to insert plate table data in plates table.
Relevant Skills and Experience
My Skills :- JSON, MySQL, Linux, PHP, Codeignitor, HTML.
I have experience in insert, update data using json. I have done this type of project previous.
Proposed Milestones
$20 USD - After Data Insert In Table
I have some question so can we discuss more about your project on chat if you want.
Thanks.
Hi.
I can help you with your Json insert to MySQL.
Let's talk.
Habilidades y experiencia relevante
XML, MySQL, PHP
Htos propuestos
$100 USD - Default milestone
I read project description and understand about work that needs to be save Json data to myself table.
Contact me to done this work quickly.
I have 5 years of experience in Php,Json, Mysqli.
I am a full stack developer and I have experience of web development for 5+ years.
Relevant Skills and Experience
JSON, Linux, MySQL
Stay tuned, I'm still working on this proposal.
Hello,
I just came across your requirement and interested to work. I believe that I might be a dedicated resource for the job.
Relevant Skills and Experience
I've proven skills in PHP & MYSQL, HTML5, and CSS3. I've over 5 years of work experience.
Proposed Milestones
$20 USD - Insert Json data to mysql table
Have achieved more complex JSON to data conversion with SQL statements
Relevant Skills and Experience
JSON,SQL
Proposed Milestones
$25 USD - Completion
Could we please have a chat discussion and allow me to work on it?
i have rich experience in required skill, please over chat,
Relevant Skills and Experience
mysql,php,perl,js,jquery,linux
Proposed Milestones
$25 USD - will complete
i have rich experience in required skill, please over chat
Hello,
I can help you to insert your Plates Dato on your MySQL Database Table using PHP
Regards
Relevant Skills and Experience
PHP
MySQL
Jquery
Html5
Proposed Milestones
$20 USD - Insert JSon Data into MySQL Table.