Datafeed-to-MySQL is designed to parse properly formatted tab, comma, pipe, semi-colon, colon, tilde, and star delimited datafeeds into MySQL format. It will detect errors in the feed and attempt to fix them or ignore them. This is a great tool to parse affiliate datafeeds into a MySQL table. License allows for use on any number of websites as long as they are owned and operated by the purchaser.
When I learned programming, I was intensively taught how to deal with data structures in programming languages like C, C++, Ada, Modula, ... When I tried to represent hierachical structures (tree structures) with databases, I realized that different representations and algorithms are more appropriate.
A web search reveiled an interesting approach to represent tree structures with databases which is based on nested sets. The basic idea is that each subtree is recursively represented as a subset of it's ancestor node. Each set is represented by a pair of integer values: the left (lower) value and the right (upper) value. The correct numbering is achieved by incrementally tagging the nodes while traversion the tree in modified preorder. See the image at the right for an example, and Gijs Van Tulder's article for a more detailed description
This is a PHP script I wrote that takes a field headed CSV file and creates a basic MySQL database from it. You have to have PHP and MySQL running on your web server of course. It will also INSERT or UPDATE into an existing database. The code is heavily commented and I hope it's useful to others.
Here you can find some classes to simply the Php software development.
There are also some application you can use on your web site or for your personal use.
They are distribuited under GNU GPL License: you can get them for free, but remember to read the disclaimer of warranty before.
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.