auto transfer json to sqlite3

blackhorse

Hello I am looking for a php script that would automatically read json data and save the data as sqlite3 data.

I have a deadline until tomorrow to get it done. I have quickly googled and searched this forum. Not found a suitable one. But I think that should be a script that could have popular demands, so there got be a good one already there.

Simple script will be good. But fancy stuff like read the json, create the sqlite3 tables and insert data to the sqlite3 tables, all in one action will be great!

If someone can give some advice / url / script samples, that will be very helpful. Could save me hours works.

Thanks again!

johanafm

file_get_contents will do the trick for reading data most of the time. Unless you get it in a http post or get request of course. Then it's $GET or $POST.

json_decode will parse the input string into php arrays/objects.

But, the data needs to be parsed and interpreted. And unless there exist a standardized spefiication of how to express sqlite queries in JSON, you are the one who will need to parse your data and decide what to do with each item. If there is a standardized specification, then there are likely tools/libraries to do this part of the job for you.

Without such a standard, for, foreach and possibly recursion will let you go through the unserialized data. And there are a heap of array functions that may be helpful as well.

You are the one who (hopefully) knows the structure of the data, and what any specific thing would mean. Perhaps there's an array element or object member called table, which in turn is an array with table data for tables to be created. Or it might exist in just that way but should be considered data for insertion into that table...

blackhorse

Thanks! You are right. json has different structure, it will not have a universal approach to read it automatically into sqlite3.

I json_encode associative array to json. I was think about decode it back to associative array, get the index as table fields to create the table (use varchar 255), read the values and insert them. But it is not worth to do so.

Just manually create the sqlite database structure, write a script specially for reading this data into that database will do.