Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #56436

Re: Cookie gets changed when hit comes from a referrer

Show key headers only | View raw

On Tue, Oct 8, 2013 at 1:30 PM, Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> wrote:
> Is there any better way to identif a previous visitor? i tried cookies which
> failed for me for the reason i opened this thread and host like follows:
>
>                 # try to locate the visitor
>                 cur.execute('''SELECT * FROM visitors WHERE counterID = %s
> and host = %s''', (cID, host) )
>                 data = cur.fetchone()
>
>                 if not data:
>                         # if first time visitor on this page, create new
> record
>                         cur.execute('''INSERT INTO visitors (counterID,
> host, city, useros, browser, ref, lastvisit) VALUES (%s, %s, %s, %s, %s, %s,
> %s)''',
>                                                    (cID, host, city, useros,
> browser, ref, lastvisit) )
>                 else:
>                         # since visitor exists just update his record
>                         cur.execute('''UPDATE visitors SET city = %s, useros
> = %s, browser = %s, ref = %s, hits = hits + 1, lastvisit = %s''', (city,
> useros, browser, ref, lastvisit) )
> =======
>
> Please tell me if you can think fo something else.

Yes! there is a very simple and comprehensive way to learn about your
visitors.  Use Google Analytics.  Its free, you only need a google
account to open an analytics account.  They give you a small bit of
javascript that you copy and past to your pages.  If you are using a
template to create your pages, this is easy, since you just add google
code to the template.
>
> --
> https://mail.python.org/mailman/listinfo/python-list



-- 
Joel Goldstick
http://joelgoldstick.com

Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Cookie gets changed when hit comes from a referrer Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-08 13:04 +0300
  Re: Cookie gets changed when hit comes from a referrer Ian Kelly <ian.g.kelly@gmail.com> - 2013-10-08 05:08 -0600
    Re: Cookie gets changed when hit comes from a referrer Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-08 17:18 +0300
      Re: Cookie gets changed when hit comes from a referrer Ian Kelly <ian.g.kelly@gmail.com> - 2013-10-08 22:53 -0600
        Re: Cookie gets changed when hit comes from a referrer Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-09 09:47 +0300
          Re: Cookie gets changed when hit comes from a referrer Ben Finney <ben+python@benfinney.id.au> - 2013-10-09 18:12 +1100
    Re: Cookie gets changed when hit comes from a referrer Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-08 17:36 +0300
  Re: Cookie gets changed when hit comes from a referrer Denis McMahon <denismfmcmahon@gmail.com> - 2013-10-08 15:55 +0000
    Re: Cookie gets changed when hit comes from a referrer Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-08 19:04 +0300
      Re: Cookie gets changed when hit comes from a referrer Joel Goldstick <joel.goldstick@gmail.com> - 2013-10-08 13:10 -0400
      Re: Cookie gets changed when hit comes from a referrer Denis McMahon <denismfmcmahon@gmail.com> - 2013-10-08 19:29 +0000
        Re: Cookie gets changed when hit comes from a referrer Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-09 01:52 +0300
          Re: Cookie gets changed when hit comes from a referrer Ned Batchelder <ned@nedbatchelder.com> - 2013-10-08 19:57 -0400
          Re: Cookie gets changed when hit comes from a referrer Steven D'Aprano <steve+comp.lang.python@pearwood.info> - 2013-10-09 01:33 +0000
            Re: Cookie gets changed when hit comes from a referrer Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-09 11:24 +0300
              Re: Cookie gets changed when hit comes from a referrer Mark Lawrence <breamoreboy@yahoo.co.uk> - 2013-10-09 09:44 +0100
              Re: Cookie gets changed when hit comes from a referrer Denis McMahon <denismfmcmahon@gmail.com> - 2013-10-09 14:45 +0000
              Re: Cookie gets changed when hit comes from a referrer Piet van Oostrum <piet@vanoostrum.org> - 2013-10-09 14:36 -0400
                Re: Cookie gets changed when hit comes from a referrer Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-10 00:29 +0300
                Re: Cookie gets changed when hit comes from a referrer Joel Goldstick <joel.goldstick@gmail.com> - 2013-10-09 18:03 -0400
                Re: Cookie gets changed when hit comes from a referrer Mark Lawrence <breamoreboy@yahoo.co.uk> - 2013-10-09 23:26 +0100
          Re: Cookie gets changed when hit comes from a referrer Mark Lawrence <breamoreboy@yahoo.co.uk> - 2013-10-09 08:00 +0100
          Re: Cookie gets changed when hit comes from a referrer Denis McMahon <denismfmcmahon@gmail.com> - 2013-10-09 14:43 +0000
            Re: Cookie gets changed when hit comes from a referrer Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-09 18:00 +0300
              Re: Cookie gets changed when hit comes from a referrer Joel Goldstick <joel.goldstick@gmail.com> - 2013-10-09 11:20 -0400
              Re: Cookie gets changed when hit comes from a referrer Mark Lawrence <breamoreboy@yahoo.co.uk> - 2013-10-09 16:39 +0100
              Re: Cookie gets changed when hit comes from a referrer Denis McMahon <denismfmcmahon@gmail.com> - 2013-10-09 18:06 +0000
                Re: Cookie gets changed when hit comes from a referrer Mark Lawrence <breamoreboy@yahoo.co.uk> - 2013-10-09 19:28 +0100
                Re: Cookie gets changed when hit comes from a referrer Tim Chase <python.list@tim.thechases.com> - 2013-10-09 14:26 -0500
                Re: Cookie gets changed when hit comes from a referrer Mark Lawrence <breamoreboy@yahoo.co.uk> - 2013-10-09 20:40 +0100
                Re: Cookie gets changed when hit comes from a referrer Steven D'Aprano <steve+comp.lang.python@pearwood.info> - 2013-10-09 23:48 +0000
                Re: Cookie gets changed when hit comes from a referrer Chris Angelico <rosuav@gmail.com> - 2013-10-10 11:18 +1100
                Re: Cookie gets changed when hit comes from a referrer Denis McMahon <denismfmcmahon@gmail.com> - 2013-10-10 00:31 +0000
                Re: Cookie gets changed when hit comes from a referrer Steven D'Aprano <steve+comp.lang.python@pearwood.info> - 2013-10-10 01:10 +0000
                Re: Cookie gets changed when hit comes from a referrer Chris Angelico <rosuav@gmail.com> - 2013-10-10 12:28 +1100
                Re: Cookie gets changed when hit comes from a referrer Mark Lawrence <breamoreboy@yahoo.co.uk> - 2013-10-10 06:21 +0100
                Re: Cookie gets changed when hit comes from a referrer rusi <rustompmody@gmail.com> - 2013-10-09 22:36 -0700
                Re: Cookie gets changed when hit comes from a referrer Mark Lawrence <breamoreboy@yahoo.co.uk> - 2013-10-10 06:56 +0100
                Re: Cookie gets changed when hit comes from a referrer Ben Finney <ben+python@benfinney.id.au> - 2013-10-10 17:01 +1100
                Re: Cookie gets changed when hit comes from a referrer Steven D'Aprano <steve@pearwood.info> - 2013-10-10 07:20 +0000
                Re: Cookie gets changed when hit comes from a referrer Steven D'Aprano <steve@pearwood.info> - 2013-10-10 07:18 +0000
                Re: Cookie gets changed when hit comes from a referrer Antoon Pardon <antoon.pardon@rece.vub.ac.be> - 2013-10-10 10:50 +0200
                Re: Cookie gets changed when hit comes from a referrer Denis McMahon <denismfmcmahon@gmail.com> - 2013-10-10 13:42 +0000
                Re: Cookie gets changed when hit comes from a referrer Ben Finney <ben+python@benfinney.id.au> - 2013-10-10 11:43 +1100
                Re: Cookie gets changed when hit comes from a referrer Roy Smith <roy@panix.com> - 2013-10-09 20:58 -0400
                Learning about HTTP [was: Cookie gets changed when hit comes from a referrer] Tim Golden <mail@timgolden.me.uk> - 2013-10-10 08:44 +0100
                Re: Cookie gets changed when hit comes from a referrer Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2013-10-10 19:45 -0400
                Re: Cookie gets changed when hit comes from a referrer Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2013-10-10 19:48 -0400
              Re: Cookie gets changed when hit comes from a referrer Denis McMahon <denismfmcmahon@gmail.com> - 2013-10-09 18:06 +0000
    Re: Cookie gets changed when hit comes from a referrer Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-08 20:30 +0300
      Re: Cookie gets changed when hit comes from a referrer Joel Goldstick <joel.goldstick@gmail.com> - 2013-10-08 13:47 -0400
        Re: Cookie gets changed when hit comes from a referrer Steven D'Aprano <steve+comp.lang.python@pearwood.info> - 2013-10-09 01:24 +0000

csiph-web