欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  php教程

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

程序员文章站 2022-05-06 14:32:49
...
将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';