RE: [PHP-DB] Page Use
If it is a low traffic site, then the db writes should not be bad at all. You can simply have the user log in then set their username or something in a session variable, then you can use that to keep track of them in the db. Eddie -Original Message- From: Tim Winters [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 9:10 AM To: 'Mike'; 'PHP-DB' Subject: RE: [PHP-DB] Page Use Thanks Mike, You make some good points. >From a volume point of view I don't think making the writes to the DB will have much effect as it's a low traffic site. I guess I'm going to have to do some reading on SESSION() Thanks!! Tim Winters Creative Development Manager Sampling Technologies Incorporated 1600 Bedford Highway, Suite 212 Bedford, Nova Scotia B4A 1E8 www.samplingtechnologies.com [EMAIL PROTECTED] [EMAIL PROTECTED] Office: 902 450 5500 Cell: 902 430 8498 Fax:: 902 484 7115 -Original Message- From: Mike [mailto:[EMAIL PROTECTED] Sent: June 23, 2003 9:37 AM To: [EMAIL PROTECTED]; 'PHP-DB' Subject: RE: [PHP-DB] Page Use I'm sure an application like this has already been written, but here are some considerations if you'd like to build your own: -You need to start a session or have some other functionality that identifies each user uniquely as they browse your pages. -For EVERY page the user visits, you're going to need to record that information in a database (page, userID, time, etc) -You can't really record when they leave - but more accurately when they browse another page. This will give you the approx. end time to the previous page view and also allow you to "track" their flow through the site. -When you create your reporting interface, just have it ignore gaps of a certain length of time between page views. If someone has a gap of 10 hours, then they've probably gone to bed or left work and come back to it the next day. It doesn't make sense to count the page view as being "10 hours long". So yes, it's possible with PHP. Is it worthwhile? Eh, maybe. But just realize the overhead that you'll be putting on a busy site with a DB entry for EVERY page view - even for pages with no dynamic content (not to mention any pages that might require real DB querying). -M -Original Message- From: Tim Winters [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 8:06 AM To: 'PHP-DB' Subject: [PHP-DB] Page Use Hello, I'm interested in setting up a system whereby I can track a users movements through a site. I particularly I am interested in recording both that the user actually hit the page but also the time he spent on that page. Is this possible using PHP and if so how? Thx Tim Winters Creative Development Manager Sampling Technologies Incorporated 1600 Bedford Highway, Suite 212 Bedford, Nova Scotia B4A 1E8 www.samplingtechnologies.com [EMAIL PROTECTED] [EMAIL PROTECTED] Office: 902 450 5500 Cell: 902 430 8498 Fax:: 902 484 7115 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Page Use
On Mon, 23 Jun 2003 10:33:59 -0300 Tim Winters <[EMAIL PROTECTED]> wrote: > Interesting Pierre, > > Is this something you have ever used? I have tested it for a few weeks ago (and starting to translate the doc to fr ;). I use it in a current project. However be sure this is really something good and well maintained, Sebastian Bergmann did a really good job here. hth pierre -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Page Use
Interesting Pierre, Is this something you have ever used? Thanks for the reply Tim Winters Creative Development Manager Sampling Technologies Incorporated 1600 Bedford Highway, Suite 212 Bedford, Nova Scotia B4A 1E8 www.samplingtechnologies.com [EMAIL PROTECTED] [EMAIL PROTECTED] Office: 902 450 5500 Cell: 902 430 8498 Fax:: 902 484 7115 -Original Message- From: Pierre-Alain Joye [mailto:[EMAIL PROTECTED] Sent: June 23, 2003 10:12 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Page Use Hello, something really good: http://www.phpopentracker.de/ hth pierre -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Page Use
Thanks Mike, You make some good points. >From a volume point of view I don't think making the writes to the DB will have much effect as it's a low traffic site. I guess I'm going to have to do some reading on SESSION() Thanks!! Tim Winters Creative Development Manager Sampling Technologies Incorporated 1600 Bedford Highway, Suite 212 Bedford, Nova Scotia B4A 1E8 www.samplingtechnologies.com [EMAIL PROTECTED] [EMAIL PROTECTED] Office: 902 450 5500 Cell: 902 430 8498 Fax:: 902 484 7115 -Original Message- From: Mike [mailto:[EMAIL PROTECTED] Sent: June 23, 2003 9:37 AM To: [EMAIL PROTECTED]; 'PHP-DB' Subject: RE: [PHP-DB] Page Use I'm sure an application like this has already been written, but here are some considerations if you'd like to build your own: -You need to start a session or have some other functionality that identifies each user uniquely as they browse your pages. -For EVERY page the user visits, you're going to need to record that information in a database (page, userID, time, etc) -You can't really record when they leave - but more accurately when they browse another page. This will give you the approx. end time to the previous page view and also allow you to "track" their flow through the site. -When you create your reporting interface, just have it ignore gaps of a certain length of time between page views. If someone has a gap of 10 hours, then they've probably gone to bed or left work and come back to it the next day. It doesn't make sense to count the page view as being "10 hours long". So yes, it's possible with PHP. Is it worthwhile? Eh, maybe. But just realize the overhead that you'll be putting on a busy site with a DB entry for EVERY page view - even for pages with no dynamic content (not to mention any pages that might require real DB querying). -M -Original Message- From: Tim Winters [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 8:06 AM To: 'PHP-DB' Subject: [PHP-DB] Page Use Hello, I'm interested in setting up a system whereby I can track a users movements through a site. I particularly I am interested in recording both that the user actually hit the page but also the time he spent on that page. Is this possible using PHP and if so how? Thx Tim Winters Creative Development Manager Sampling Technologies Incorporated 1600 Bedford Highway, Suite 212 Bedford, Nova Scotia B4A 1E8 www.samplingtechnologies.com [EMAIL PROTECTED] [EMAIL PROTECTED] Office: 902 450 5500 Cell: 902 430 8498 Fax:: 902 484 7115 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Page Use
Hello, something really good: http://www.phpopentracker.de/ hth pierre -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Page Use
> So yes, it's possible with PHP. Is it worthwhile? Eh, maybe. But just > realize the overhead that you'll be putting on a busy site > with a DB entry > for EVERY page view - even for pages with no dynamic content > (not to mention > any pages that might require real DB querying). Why not use click-stream analysis software that is out there? My ISP offers the log-analyzer FunnelWeb from Quest. It does not add any overhead because it parses the log files offline (and makes some assumptions about sessions) to track individual users through my site. I dont know how expensive it is, but there is a free download. I am not affiliated with Quest, but I have become a big fan of FunnelWeb. matt -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Page Use
I'm sure an application like this has already been written, but here are some considerations if you'd like to build your own: -You need to start a session or have some other functionality that identifies each user uniquely as they browse your pages. -For EVERY page the user visits, you're going to need to record that information in a database (page, userID, time, etc) -You can't really record when they leave - but more accurately when they browse another page. This will give you the approx. end time to the previous page view and also allow you to "track" their flow through the site. -When you create your reporting interface, just have it ignore gaps of a certain length of time between page views. If someone has a gap of 10 hours, then they've probably gone to bed or left work and come back to it the next day. It doesn't make sense to count the page view as being "10 hours long". So yes, it's possible with PHP. Is it worthwhile? Eh, maybe. But just realize the overhead that you'll be putting on a busy site with a DB entry for EVERY page view - even for pages with no dynamic content (not to mention any pages that might require real DB querying). -M -Original Message- From: Tim Winters [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 8:06 AM To: 'PHP-DB' Subject: [PHP-DB] Page Use Hello, I'm interested in setting up a system whereby I can track a users movements through a site. I particularly I am interested in recording both that the user actually hit the page but also the time he spent on that page. Is this possible using PHP and if so how? Thx Tim Winters Creative Development Manager Sampling Technologies Incorporated 1600 Bedford Highway, Suite 212 Bedford, Nova Scotia B4A 1E8 www.samplingtechnologies.com [EMAIL PROTECTED] [EMAIL PROTECTED] Office: 902 450 5500 Cell: 902 430 8498 Fax:: 902 484 7115 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Page Use
use sessions and a database table enter page name and timestamp it for each page request Analyse from the timestamp order and the time difference. Let me know if you want more details HTH Peter -Original Message- From: Tim Winters [mailto:[EMAIL PROTECTED] Sent: 23 June 2003 13:06 To: 'PHP-DB' Subject: [PHP-DB] Page Use Hello, I'm interested in setting up a system whereby I can track a users movements through a site. I particularly I am interested in recording both that the user actually hit the page but also the time he spent on that page. Is this possible using PHP and if so how? Thx Tim Winters Creative Development Manager Sampling Technologies Incorporated 1600 Bedford Highway, Suite 212 Bedford, Nova Scotia B4A 1E8 www.samplingtechnologies.com [EMAIL PROTECTED] [EMAIL PROTECTED] Office: 902 450 5500 Cell: 902 430 8498 Fax:: 902 484 7115 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php