Home > Backend Development > PHP Tutorial > How to convert the sqlite database file of favdb exported by 360 browser into html in php

How to convert the sqlite database file of favdb exported by 360 browser into html in php

怪我咯
Release: 2023-03-12 15:58:02
Original
2130 people have browsed it

This article mainly introduces the sharing of php code Converting the sqlite database file of favdb exported by 360 browser to html. Friends who need it can refer to it

The following is a piece of php code that explains how to convert the favdb sqlite database file exported by 360 browser into html. The code below is simple and easy to understand. Friends who are interested can take a look.

The php code is as follows:

<?php
  $book_mark_name = &#39;book_mark.html&#39;;
  $content = file_get_contents(&#39;tb_fav.json&#39;);
  var_dump($content);
  $content_list = json_decode($content,&#39;utf-8&#39;);
  $content_list = $content_list[&#39;RECORDS&#39;];
  $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[&#39;url&#39;];
    $add_date    = $item[&#39;create_time&#39;];
    $last_visit   = $item[&#39;last_modify_time&#39;];
    $last_modified = $item[&#39;last_modify_time&#39;]+1;
    $title     = $item[&#39;title&#39;];
    $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 &#39;success&#39;;
Copy after login

The above is the detailed content of How to convert the sqlite database file of favdb exported by 360 browser into html in php. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template