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