php - how to import .txt database to mysql?

Question

how to import .txt to mysql file?

I have a .txt file with hundreds of records and I want to import it into the mysql database table.

my txt file database is like that:

{"PAGE ID":{"title":"PAGE TITLE","description":"PAGE DESCRIPTION","username":"admin","tags":[TAGS],"type":"PAGE-TYPE","date":"PAGE DATE","dateModified":"PAGE DATE MODIFIED","position":0,"coverImage":"COVER IMAGE SRC","category":"PAGE CATEGORY","md5file":"PAGE MD5 FILE","uuid":"PAGE UUID","allowComments":true,"template":"PAGE TEMPLATE","noindex":false,"nofollow":false,"noarchive":false,"custom":[false]},

and all the other codes repeat like that.

I wonder how i can implement a formula to implement this txt file to mysql.

Answer 1

等待大神答复