Page Paths & Mysql Database

[golfinggod]

Hi all
I want to create a script that tracks the path of a visitor through a site and then stores that path in a database.

Can some suggest a way to actually store the path in the database, ie. some sort of format.

Should I store each page as a seperate row with a date,time,seconds or combine the paths into one long string say seperated by "-" and then insert this.

I would like to be able to query the databse and bring out the results.

What do you think would be the most beneficial in terms of space saving and ease of coding

Thanks

🙂

[Agirre]

Seperating by '-' is not recommended, I think. If you'll explode these later, you'll surely will get errors. Some URL contains '-' to. Then you must use an "unique" seperate; like '|*@'36Y1' My way I would do it, is to throw each URL in a row.
Also, I would build up these database, existing out of an unique ID, IP, URL and timestamp.

Something like

$sql = "INSERT INTO `db`  ( `id` , `ip` , `url` , `timestamp` ) VALUES ('', '".$_SERVER['REMOTE_ADDR']."', '".$_SERVER['PHP_SELF']."', '".time()."')';
mysql_query($sql);

Something like that, where id is an unique auto_increment.

[golfinggod]

thanks🙂