Tech aspirant – The ultimate technology Blog

PHP Personal Home Page now it is Hypertext Pre Processor.

Version : 6 (PHP 6)

Advantages,

• Addition of improved MySql Extension
• PHP 6 support Unicode, so that PHP 6 can handle all languages in the world. I faced lot of problems with ‘Malayalam’ font integration.
• PHP 6 cleans up a lot of garbbages that was left in php 5
• The two biggest removals are the “Magic Quotes” and “register globals” features

Download and Test PHP 6 at http://snaps.php.net/

What is magic Quotes ?

It automatically escapes single quotes or double quotes in form data by inserting a “\” Back slash in front of it. Now this automatic feature called magic Quotes has been removed  in PHP6.

Go through my cv page http://arunrajr.com/blog/my-cv/

How to create a directory structure ? or
How to creata a tree structure  ? or
How to design a database for a tree structure ? or
How to design a database for storing hierarchical structure ?

using single table

Create a table like this

CREATE TABLE `category` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) default NULL,
`descr` text,
`parent` int(11) default NOT NULL,
PRIMARY KEY  (`id`)
)

This table containing fields id,name,description and parent.Here all are familiar fields except parent.
Parent field is used to store the id of parent item . So that we can select the sub category by querying the database

with parent==id .

First upon we have to display main category by querying parent==’0′,
Then sub category by querying parent==1 or some thing like that
I think this information useful .

Regards,
Arun Raj R
Kadampanad