NEW LISTINGS 
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
PHP / mysql implementation
17826
PHP / mysql implementation
http://www.edutech.ch/contribution/nstrees/
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 PHP > Scripts and Programs > Database Tools Oct 13, 2006
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 PHP > Scripts and Programs > Database Tools Oct 13, 2006
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
| |
|
||
| Bookmark PHP / mysql implementation: |
|||
Other links at PHP > Scripts and Programs > Database Tools
Mlam is a tool written in PHP (version 4). It simplifies a lot of tasks for developpers writing administration sites in this language to manage databases in Mysql.
Even if the main purpose of mlam is the html edition of database records, it comes also with other functions to help developpers to create an efficient administration tool for efficient websites.
With only a little time in an specific administration tool, and the creation of a php file containing no more than 3 lines in php, you can manage the insertion and edition of various elements in your table (text, numbers, dates, external keys, files, pictures...).
Even if the main purpose of mlam is the html edition of database records, it comes also with other functions to help developpers to create an efficient administration tool for efficient websites.
With only a little time in an specific administration tool, and the creation of a php file containing no more than 3 lines in php, you can manage the insertion and edition of various elements in your table (text, numbers, dates, external keys, files, pictures...).
Category:
pjjTextBase is a powerful yet easy to use set of Unicode compatible PHP4+ functions, that provides a simple relational database when you don't need SQL. With pjjTextBase you can quickly develop a robust database-driven web application: anything from a guest?book, forum, poll etc. to fully-fledged CMS or e-commerce project. pjjTextBase requires no other software than PHP on your server, making your application very compatible with a variety of hosting plans and instantly deployable by a simple upload of the scripts.
Category:
The PHP CSV Importer is a script that allows you to import CSV files directly to a MySQL database via a point-and-click interface.
This all-new version allows users to upload their csv files directly using the script. Using the easy-to-use interface of drop-downs and buttons, the users can preview their file, select the table and then insert the data into MySQL. Simply edit the configuration file and you're good to go!
This all-new version allows users to upload their csv files directly using the script. Using the easy-to-use interface of drop-downs and buttons, the users can preview their file, select the table and then insert the data into MySQL. Simply edit the configuration file and you're good to go!
Category:
PHP Database abstraction layer RDBMS independent
Category:
Main Category
200
2047
830
286
175
1804
1573
913
1177
7596
70
919
60
2247
175
Join Mailing List
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.
Top 10
Directory Statistics
Links: 20048
Categories: 1275
Registered Users: 790
Mailing List Subscribers: 2049
Unique Outgoing Hits: 234751
Pagerank Statistics
PHP News