数据库数据转换为html,将360 浏览器导出的favdb的sqlite数据库文件转换为html

将360 浏览器导出的favdb的sqlite数据库文件转换为html

1.[代码][PHP]代码

$book_mark_name = 'book_mark.html';

$content = file_get_contents('tb_fav.json');

var_dump($content);

$content_list = json_decode($content,'utf-8');

$content_list = $content_list['RECORDS'];

$content_header = "".

"".

"".

"

Bookmarks".

"

Bookmarks

".

"

";

file_put_contents($book_mark_name,$content_header);

foreach ($content_list as $item) {

$href = $item['url'];

$add_date = $item['create_time'];

$last_visit = $item['last_modify_time'];

$last_modified = $item['last_modify_time']+1;

$title = $item['title'];

$content = "

$title"."
";

file_put_contents($book_mark_name,$content,FILE_APPEND);

}

$content_tail = "

";

file_put_contents($book_mark_name,$content_tail,FILE_APPEND);

echo 'success';