I have a large set of data spread across three text files. Each line in the files contains information about a word in Mandarin. I’d like to have built a web interface for this using PHP and MySQL.
The three text files should be ported into MySQL tables. The schemas for the three tables are simple and should be derivable just from the column names and the values seen under each column. There are however a lot of columns (> 150 for each).
The website has two features:
“Get lexical characteristics”, i.e., search through the database and produce the information inside based on a word list provided by a user
“Create word list”, i.e., given a list of constraints, retrieve words (and values) that match the query
A detailed description is attached