Fetch JSON Data & Insert into Mysql table in PHP

[heisenbergw.w]

uploaded 8 years ago, yet still a helpful video. I love you man, you just helped me so so much with this video

[homenetwork]

You made my day!!!. I had been watching so many video tutorials online and I had already spent more than 4 - 5 hours to insert the values in the php mysql. Finally somehow I came across your video.. And Voila... I was able to get it working in less than 5 minutes. You are great. Thanks a lot for this video.

[jaimitoc]

Actually, one of the great things of json format is that you are not limited to a structure for storing values. With MySQL you can use JSON datatype to store json values.

[anibrahaj]

I got multiple errors like [Illegal string offset 'result' in] for each of my values .The JSON Data, im getting it from another server,
this are my data after i decoded tham :array(5) { ["result"]=> bool(true) ["message"]=> string(20) "login is successfull" ["dictCount"]=> string(1) "2" ["token"]=> string(32) ["tokenValidDate"]=> string(19) "2018-08-09 19:37:57" }
Can u please help me finding the issue ?

[parmetra]

Hello! Could you tell me, please, how I can do the same not with a local file, but with a POST request?

[PeterID]

How about insert many data like 1000 row?? Was try and i fail, only < 100 row can be inserted

[henrytaruvinga]

Hello hi sir thank you for the video, I have followed everything and run the code on the browser and it says data inserted but unfortunately it's not inserting can you help me please if I check in database there is nothing

[udaykyastu]

Can you prepare a video using nested JSON object

[hahaudieddumb]

Should the json file be saved in the same place as the php file?

[netindonesia]

Not working, no data insert to Db and no data print on the table also, how to solve this?
Thx

[darkman]

What if you are using the JSON data type on your mysql database? Does that change the syntax?

[cryto-alex]

Ah nice, go to the link to the get the code. Nicely done.

[jeremy_s]

Thank-you! Legend! Your videos are so good!

[sagarchavan]

sucess msg has been appered but the data is not load in to datbase pls help me out sir

[usmangani]

Hey the data is not getting loaded into database .Can u please help me finding the issue ?

[salimhusain]

sir i want multiple json files data into mysql database....but how, reply

[MrFartade]

Well example and intuitive, actuality use pdo

[srinivassagit]

How do I know that recorded has been inserted?

[narongritmangsungnurn]

How to do ...
if i need some value not all
thx for ans bro .

[schoolbook]

Hi, Nice tutorial however I have little problem on my side. Data get inserted but with duplicates. Data added twice for each, Where could be wrong?