RE: [PHP] A MYSQL COUNTER
The question you must answer first: what do you intend to do with the data once it's collected? Will you simply review the data without sorting it or performing data manipulation? If so, why incur the overhead of MYSQL? If all you need to do is log the user page hits, use a text file; then use grep/awk/sed/perl/php to search for specific users with their page hits, etc. Define your requirements more explicitly, then choose a solution. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Monday, February 11, 2002 6:39 PM To: Georgie Casey; [EMAIL PROTECTED] Subject: RE: [PHP] A MYSQL COUNTER This is too much for a text file. You should definitely use MySQL for this. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Georgie Casey [mailto:[EMAIL PROTECTED]] Sent: Monday, February 11, 2002 3:22 PM To: [EMAIL PROTECTED] Subject: [PHP] A MYSQL COUNTER I need a way of tracking what user was logged in when vieweing a particular member page, so I'm thinking of having EVERY unique page view of each member page added to a MySQL database, which just the ip, time and date, server name and browser, stuff like that. Is this too much for a MySQL DB??? Should I just write all the info to a textfile??? TANX -- Regards, Georgie Casey [EMAIL PROTECTED] *** http://www.filmfind.tv Ireland's Online Film Production Directory *** -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] A MYSQL COUNTER
whenever they're is a new unique visitor, I want a script to email the member about who visited. And have a permanent record for each member of who viewed their pages, accesible when they login. Rick Emery [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... The question you must answer first: what do you intend to do with the data once it's collected? Will you simply review the data without sorting it or performing data manipulation? If so, why incur the overhead of MYSQL? If all you need to do is log the user page hits, use a text file; then use grep/awk/sed/perl/php to search for specific users with their page hits, etc. Define your requirements more explicitly, then choose a solution. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Monday, February 11, 2002 6:39 PM To: Georgie Casey; [EMAIL PROTECTED] Subject: RE: [PHP] A MYSQL COUNTER This is too much for a text file. You should definitely use MySQL for this. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Georgie Casey [mailto:[EMAIL PROTECTED]] Sent: Monday, February 11, 2002 3:22 PM To: [EMAIL PROTECTED] Subject: [PHP] A MYSQL COUNTER I need a way of tracking what user was logged in when vieweing a particular member page, so I'm thinking of having EVERY unique page view of each member page added to a MySQL database, which just the ip, time and date, server name and browser, stuff like that. Is this too much for a MySQL DB??? Should I just write all the info to a textfile??? TANX -- Regards, Georgie Casey [EMAIL PROTECTED] *** http://www.filmfind.tv Ireland's Online Film Production Directory *** -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] A MYSQL COUNTER
I just looked at your website (http://www.filmfind.tv) to get a better feeling for what you might be after. Based upon your comments below and the purpose of filmfind.tv, it appears a mysql solution might be required. At the least, you need to store the email address of your members. I assume you already have that stored elsewhere. Second, the requirement for new unique visitor is the phrase that pays here. You will need to maintain a list of visitors and search that list to determine uniqueness. A database would be the fastest to develop. As to whether your application is too much for MYSQLworry not. There are MYSQL DBs out there with millions of rows and very complex relational structures. -Original Message- From: Georgie Casey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 11:00 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] A MYSQL COUNTER whenever they're is a new unique visitor, I want a script to email the member about who visited. And have a permanent record for each member of who viewed their pages, accesible when they login. Rick Emery [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... The question you must answer first: what do you intend to do with the data once it's collected? Will you simply review the data without sorting it or performing data manipulation? If so, why incur the overhead of MYSQL? If all you need to do is log the user page hits, use a text file; then use grep/awk/sed/perl/php to search for specific users with their page hits, etc. Define your requirements more explicitly, then choose a solution. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Monday, February 11, 2002 6:39 PM To: Georgie Casey; [EMAIL PROTECTED] Subject: RE: [PHP] A MYSQL COUNTER This is too much for a text file. You should definitely use MySQL for this. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Georgie Casey [mailto:[EMAIL PROTECTED]] Sent: Monday, February 11, 2002 3:22 PM To: [EMAIL PROTECTED] Subject: [PHP] A MYSQL COUNTER I need a way of tracking what user was logged in when vieweing a particular member page, so I'm thinking of having EVERY unique page view of each member page added to a MySQL database, which just the ip, time and date, server name and browser, stuff like that. Is this too much for a MySQL DB??? Should I just write all the info to a textfile??? TANX -- Regards, Georgie Casey [EMAIL PROTECTED] *** http://www.filmfind.tv Ireland's Online Film Production Directory *** -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] A MYSQL COUNTER
yea, I'm going to use MySQL for it. Tanx Rick Emery [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I just looked at your website (http://www.filmfind.tv) to get a better feeling for what you might be after. Based upon your comments below and the purpose of filmfind.tv, it appears a mysql solution might be required. At the least, you need to store the email address of your members. I assume you already have that stored elsewhere. Second, the requirement for new unique visitor is the phrase that pays here. You will need to maintain a list of visitors and search that list to determine uniqueness. A database would be the fastest to develop. As to whether your application is too much for MYSQLworry not. There are MYSQL DBs out there with millions of rows and very complex relational structures. -Original Message- From: Georgie Casey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 11:00 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] A MYSQL COUNTER whenever they're is a new unique visitor, I want a script to email the member about who visited. And have a permanent record for each member of who viewed their pages, accesible when they login. Rick Emery [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... The question you must answer first: what do you intend to do with the data once it's collected? Will you simply review the data without sorting it or performing data manipulation? If so, why incur the overhead of MYSQL? If all you need to do is log the user page hits, use a text file; then use grep/awk/sed/perl/php to search for specific users with their page hits, etc. Define your requirements more explicitly, then choose a solution. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Monday, February 11, 2002 6:39 PM To: Georgie Casey; [EMAIL PROTECTED] Subject: RE: [PHP] A MYSQL COUNTER This is too much for a text file. You should definitely use MySQL for this. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Georgie Casey [mailto:[EMAIL PROTECTED]] Sent: Monday, February 11, 2002 3:22 PM To: [EMAIL PROTECTED] Subject: [PHP] A MYSQL COUNTER I need a way of tracking what user was logged in when vieweing a particular member page, so I'm thinking of having EVERY unique page view of each member page added to a MySQL database, which just the ip, time and date, server name and browser, stuff like that. Is this too much for a MySQL DB??? Should I just write all the info to a textfile??? TANX -- Regards, Georgie Casey [EMAIL PROTECTED] *** http://www.filmfind.tv Ireland's Online Film Production Directory *** -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] A MYSQL COUNTER
This is too much for a text file. You should definitely use MySQL for this. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Georgie Casey [mailto:[EMAIL PROTECTED]] Sent: Monday, February 11, 2002 3:22 PM To: [EMAIL PROTECTED] Subject: [PHP] A MYSQL COUNTER I need a way of tracking what user was logged in when vieweing a particular member page, so I'm thinking of having EVERY unique page view of each member page added to a MySQL database, which just the ip, time and date, server name and browser, stuff like that. Is this too much for a MySQL DB??? Should I just write all the info to a textfile??? TANX -- Regards, Georgie Casey [EMAIL PROTECTED] *** http://www.filmfind.tv Ireland's Online Film Production Directory *** -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
