Posts Tagged ‘mysql
Reordering nested sets using PHP and Javascript
The adjancency method
Representing a tree of nodes, for example product categories, in a relational database is not hard. The most common way of doing it is to store a parentid with each node. This is also known as the adjacency list model. It is sometimes also referred to as the recursive model. Whatever the name [...]
The nested set model – hierarchical data in MySQL
I’m working on a small PHP project handling data which is organized in a hierarchical fashion. This is a common task and I have done it before creating forums and the like. This time no different than any other I was swearing over the rather ugly and most of all inefficient code needed for fetching [...]
MySQL 4, Apache 1.3 and PHP 4.3 on Solaris x86
Yesterday I decided it was time to get a proper PHP 4 environment configured on my new machine running the x86 version of Solaris 9. I know going outside Windows or Linux with PHP sometimes can be tricky. I haven’t used PHP on Solaris since my time at AOL in Dublin three years ago, so I decided to write down exactly [...]
PHP5 Overview
PHP5 is still far from being finished even though you can already download a beta version. The performance improvements, the better object orientation and XML support, the new PDO extension and many other small and large changes make many of us wish it was already here. After attending the PHP Conference 2003 in Frankfurt I [...]
