Bananian

Parsing JSON data and inserting to MySQL

1 62
Hey, so basically i want to parse a JSON file in PHP and insert the data into specific tables/columns. At the moment i have a working script but requires me to modify the JSON largely until it works. Which might be a pain because the JSON data I'm collecting can vary in size having more data rows. The JSON file is structured differently to most i have seen , maybe because its output data from sensor units. I want to insert the data and the serial number into the data table, and have an error_log table where i can store the serial number and error messages as strings.
Please help
Thanks

More Details
infographic videos

wty123  
coach factory, nfl bills jerseys, coach factory outlet, mcm bags, dansko shoes outlet, coach factory outlet, new orleans pelicans jerseys, nike shoes, hollister co, vans shoes, true religion jeans outlet, nike air, nike mercurial, nfl saints jerseys, nike air max, adidas online shop, north face, marc jacobs handbags, flat iron, oakley pas cher, michael kors handbags, northface, christian louboutin, minnesota timberwolves jerseys, washington wizards jerseys, michael kors outlet online, hilfiger outlet, oakley sunglasses, puma online shop, coach bags friday, nike roshe run, burberry outlet online, hermes birkin, iphone 5s cases, tommy hilfiger canada, oakley holbrook, purses and handbags, nike roshe run, burberry handbags, ray-ban sunglasses, juicy couture handbags, christian louboutin, pandora bracelet, nfl falcons jerseys, burberry handbags, michael kors outlet, michael kors handbags, spurs jerseys, nfl titans jerseys, hermes tracksuits, chrome hearts clothings, mcm backpack, true religion jeans outlet, red bottom shoes, michael kors outlet online, shoes outlet, versace, ralph lauren outlet online, louboutin shoes, true religion, ray ban prezzi, nuggets jersey, nfl jets jerseys, skechers shoes outlet, supra shoes, tommy hilfiger outlet, coach shop factory, ralph lauren, uhren shop, ralph lauren, coach factory outlet, cheap ray ban, kate spade handbags, michael kors outlet online, air max, bcbg max azria, ray ban pas cher, ralph lauren factory store, oakley, air jordan retro, nike free, asics gel, ralph lauren outlet, iphone 4s cases, babyliss flat iron, rolex watch, nike store, ralph lauren, celine outlet, cheap jordans, polo ralph, nike outlet, air max, nba jersey, coach outlet, michael kors purses, nfl ravens jerseys, nfl steelers jerseys, jordans, polo ralph, huarache, nfl packers jerseys, nfl vikings jerseys, juicy couture clothings, true religion jeans women, polo ralph lauren outlet, asics, nike roshe run, thomas sabo, nike roche, birkenstock taschen deutschland, new balance, oakley sunglasses cheap, air max 95, longchamp, tommy hilfiger online, new balance shoes,

You have to log in before you can reply Login | Sign Up

Points Rules