vendredi 20 juillet 2018

How can I import json file to table?

I have a json file. The filename : Data 2017-09.json

The file like this :

{
  "@odata.context":"http://beautiful-svr01.www.beautiful.com:7708/ODATA/ODataV4/$metadata#Collection(NAV.JULY17TODEC17)","value":[
    {
      "@odata.etag":"W/\"CsM2O0lBQUFBQUNIbXdrCANBQUE5OzE4ODQ1MDQ4NjA7Ik==\"","Entry_No":193531,"Item_No":"9705010101","Variant_Code":"139","Posting_Date":"2018-01-02T00:00:00Z"
    },{
      "@odata.etag":"W/\"CsM2O0lBQUFBQUNIbkFrCANBQUE5OzE4ODQ1MDQ5MTA7Ik==\"","Entry_No":193532,"Item_No":"9705010102","Variant_Code":"150","Posting_Date":"2018-01-02T00:00:00Z"
    },{
      "@odata.etag":"W/\"CsM2O0lBQUFBQUNIblFrCANBQUE5OzIxMzA5OTIyNzA7Ik==\"","Entry_No":193533,"Item_No":"0710020003","Variant_Code":"200","Posting_Date":"2018-01-02T00:00:00Z"
    }
 ]
}

I want to import json file to table mysql

I have a table like this :

My table : item_details

id, entry_no, item_no, variant_code, posting_date

How can I do it?

I use php programming and laravel framework



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire