分享php代码将360浏览器导出的favdb的sqlite数据库文件转换为html

<?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 = "<!doctype netscape-bookmark-file-1>".
   "<!-- this is an automatically generated file.it will be read and overwritten.do not edit! -->".
   "<meta http-equiv="content-type" content="text/html; charset=utf-8">".
   "<title>bookmarks</title>".
   "<h1>bookmarks</h1>".
   "<dl><p>";
  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 = "<dt><a href="$href" add_date="$add_date" last_visit="$last_visit" last_modified="$last_modified" lovefav="0" fav_pos="1" >$title</a>"."<br/>";
    file_put_contents($book_mark_name,$content,file_append);
  }
  $content_tail = "</dl><p>";
  file_put_contents($book_mark_name,$content_tail,file_append);
  echo 'success';