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

PHP实战
<?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';