Firefox JSON data output
Is it possible to output specific JSON data (exported from Firefox bookmarks) using PHP.
This is the code I have so far, it will re-encode the data since Firefox does not export it to correct UTF-8. I also remove the trailing from the end of the file.
<?php
// Read the file blah blah
$hFile = "../uploads/james.json";
$hFile = file_get_contents($hFile);
$hFile = utf8_encode($hFile);
// Remove the trailing comma because Firefox is lazy!!!!
$hFile = substr($hFile, 0, strlen($hFile)-3) . "]}";
$hDec = json_decode(fixEncoding($hFile));
foreach($hDec['uri'] as $hURI) {
// Output here
}
// Fixes the encoding to UTF-8
function fixEncoding($in_str) {
$cur_encoding = mb_detect_encoding($in_str);
if($cur_encoding == "UTF-8" && mb_check_encoding($in_str,"UTF-8")){
return $in_str;
}else{
return utf8_encode($in_str);
}
}
?>
I was unable to get any output separately from all data using var_dump.
a source to share
As VolkerK says, you have to split the commas before ]
and }
:
// ... row 7
// Remove the trailing comma because Firefox is lazy
$hFile = preg_replace('/,\s*([\]}])/m', '$1', $hFile);
// ... or using str_replace
$hFile = str_replace(',]', ']', str_replace(',}', '}', $hFile));
But the way you are trying to access the URI of the bookmarks (which I assume is what you are trying to do) will not work.
Recheck the file format / scheme.
a source to share
Whereas json_decode () is able to decode
<?php
$c = '{"title":""}';
$bookmarks = json_decode($c);
var_dump($bookmarks);
, it fails at $c = '{"title":"",}';
The "empty" element at the end throws out the parser. And this is exactly what my bookmarks.json looks like{"title":"", ... "children":[]},]}
edit: json.org links to php json library comparison . And according to their comparison diagram, for example zend json should be able to parse firefox 'bookmark.json. However, I have not tested it.
edit2: why not just check it out ....? Yes, zend json is capable of parsing unmodified bookmarks. Json
require 'Zend/Json.php';
$encodedValue = file_get_contents('Bookmarks 2009-05-24.json');
$phpNative = Zend_Json::decode($encodedValue);
var_dump($phpNative);
prints
array (7) {
["title"] =>
string (0) ""
["id"] =>
...
["children"] =>
array (0) {
}
}
}
} a source to share