CODEWITHSUNDEEP
phpjsonfilearrays
copilot0910
copilot0910

Reputation: 431

How to add to JSON array in .json file

How do I add to a .json file with PHP? Currently, I'm appending a .json file with PHP, but it won't add the data to an existing JSON object. It makes a new object. I need the data all stored in one object, in an external JSON file. Basically, I have a JSON object and want to add more values to it.

$jsonFile = "test.json";
$fh = fopen($jsonFile, 'w');

$json = json_encode(array("message" => $name, "latitude" => $lat, "longitude" => $lon, "it" => $it));

fwrite($fh, $json);

Upvotes: 1

Views: 18120

Answers (3)

2winners
2winners

Reputation: 1

this might help future poeple even tho its a old tread i had issues getting a array put into a json array at a specific location using push so after some horsing around i came up with: using array_pad(array1,size,array2)

"{MetaData":[ { } ], "pgstyle":{ }, "fonts":{ }, "models":{ }, "Page":[ { "Type":"Text", }, { "Type":"3Dmodel", "id":"3", "name":"3D gallery", "gallerylist":[ { "model":"Basic Vert frame", "Type":"imageGallery", "name":"vertical", "gId":3, "id":303, "LightIntense":7500, "LightColor":"#ffffcb", "offset":{ "x":-70, "y":0, "z":0 }, "rotation":{ "x":90, "y":180, "z":0 }, "font":"Wittgenstein-Bold.ttf" }, { "model":"Basic Horz frame", "Type":"imageGallery", "name":"Dark Images", "gId":1, "id":301, "LightIntense":5000, "LightColor":"#ffffcb", "font":"Wittgenstein-Bold.ttf", "offset":{ "x":0, "y":0, "z":0 }, "rotation":{ "x":90, "y":180, "z":0 } }, { "model":"Basic Horz frame", "Type":"imageGallery", "name":"Dark Light", "LightIntense":5000, "LightColor":"#ffffcb", "gId":2, "id":302, "offset":{ "x":70, "y":0, "z":0 }, "rotation":{ "x":90, "y":180, "z":0 }, "font":"Wittgenstein-Bold.ttf" } ]} ] }

//the data i want to insert into my json file 
$newData = 
array("model"=>"$model","Type"=>"imgGallery","name"=>"$Title","gId" =>
(int)$gId,"id"=> (int)$id ,"LightIntense"=>(int)$LightIntensity,
"LightColor"=>"$LightColor","font"=>"$font","offset"=>array("x"=>(int) 
($ox),"y"=>(int)$oy,"z"=>(int)$oz),
"rotation"=>array("x"=>90,"y"=>180,"z"=>0 ));
// getting size
$size = sizeof($JData['Page'][$key]['gallerylist'])+1;
//appending data
$JData['Page'][$key]['gallerylist']=array_pad($JData['Page'][$key] 
['gallerylist'],
$size,$newData);
           
alertGreenRefr(var_dump(json_encode($JData,true)));
$Jfile = json_encode($JData,true);
file_put_contents("PageDatatest.json", $Jfile);

RESULT : "{MetaData":[ { } ], "pgstyle":{ }, "fonts":{ }, "models":{ }, "Page":[ { "Type":"Text", }, { "Type":"3Dmodel", "id":"3", "name":"3D gallery", "gallerylist":[ { "model":"Basic Vert frame", "Type":"imageGallery", "name":"vertical", "gId":3, "id":303, "LightIntense":7500, "LightColor":"#ffffcb", "offset":{ "x":-70, "y":0, "z":0 }, "rotation":{ "x":90, "y":180, "z":0 }, "font":"Wittgenstein-Bold.ttf" }, { "model":"Basic Horz frame", "Type":"imageGallery", "name":"Dark Images", "gId":1, "id":301, "LightIntense":5000, "LightColor":"#ffffcb", "font":"Wittgenstein-Bold.ttf", "offset":{ "x":0, "y":0, "z":0 }, "rotation":{ "x":90, "y":180, "z":0 } }, { "model":"Basic Horz frame", "Type":"imageGallery", "name":"Dark Light", "LightIntense":5000, "LightColor":"#ffffcb", "gId":2, "id":302, "offset":{ "x":70, "y":0, "z":0 }, "rotation":{ "x":90, "y":180, "z":0 }, "font":"Wittgenstein-Bold.ttf" }, { "model":"Basic Horz frame", "Type":"imgGallery", "name":"asdf ", "gId":4, "id":304, "LightIntense":5000, "LightColor":"#ffffcb", "font":"Wittgenstein-Bold.ttf", "offset":{ "x":140, "y":0, "z":0 }, "rotation":{ "x":90, "y":180, "z":0 } } ] } ] }

Upvotes: 0

Thirsty Learner
Thirsty Learner

Reputation: 39

what's suggested above is the hard way. i am considering there should be an easier way, to literally append an array into the json file.

here is the algo:

$handle=fopen($jsonFile);
fseek($handle,-1,SEEK_END);
fwrite($handle,$arrayToAdd);
fclose($handle);

but i am not sure it's more cpu/memory efficient to do so than reading the whole json file into memory, adding the array and then getting it stored.

Upvotes: 2

Licson
Licson

Reputation: 2271

You can decode the json file to a php array, then insert new data and save it again.

<?php
$file = file_get_contents('data.json');
$data = json_decode($file);
unset($file);//prevent memory leaks for large json.
//insert data here
$data[] = array('data'=>'some data');
//save the file
file_put_contents('data.json',json_encode($data));
unset($data);//release memory

Upvotes: 14

Related Questions