Have Geek Brain

Saving file structure in PHP

What is the best way to store the file structure along with the files, for example from a Zip file? Currently, each file is a string in a MySQL database, but obviously no structure can be read from it. I want to avoid storing the binary. All files must be text. Each zip / file structure is private to the user who sent it.

0


a source to share


4 answers


If you want a structure, you can have a directory table and a file table. Then for each directory at the root will have a parent id of 0. And then every directory under it has a parent id of the parent.



Then you give the file directory ID to indicate where they are.

+3


a source


My recommendation would be similar to that of Olafur Waage, although I would use a single table with indicator columns to denote the "type" of the record.

id - Primary Key
parent_id - FK to self (id)
type - enum('D', 'F')
name - varchar
content - BLOB (if you wanted to ever store the file contents).


This follows a hierarchical tree structure, which for MySQL you can find more information here: http://mikehillyer.com/articles/managing-hierarchical-data-in-mysql/

+2


a source


The easiest way (maybe not the best) is to define a "root" folder in the directory tree, after which each file will traverse that folder and store it as another column (eg "path") in the db table. You can view these values ​​later to build the same directory structure.

0


a source


Better contextually. But, taking it as face value, I would say that the best way to preserve the file structure would be in the file system. Unless you need to link records together with other records or otherwise query them, a relational database is not the best choice for arbitrary, hierarchical data. You can also use a hybrid solution where you store the index in the database, with the file and possibly some metadata, but store it on the file system.

0


a source






More articles:


All Articles