473,326 Members | 2,192 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Landing URL auto writes to database (how?)

Not quite sure where to start with this one; can anyone point me in the right direction?

I send emails to my customers which contain various links. When the customer clicks the link embedded within the email, I want the page they land at to automatically write that users email address (from the email they received) with the date and time stamp of their click directly to a data gathering table in the database.

Now, I am not familiar with PHP but can use HTML and javascript. Any assistance gratefully accepted.

Nick
Virtual Server
PHP 5.1.2
MySQL server 5.0.18
Web Server: Apache/2.2.3 (Linux/SUSE)
May 20 '08 #1
3 1310
Atli
5,058 Expert 4TB
Hi.

This can be achieved in various ways by using PHP and MySQL.

The first thing that comes to mind would be:
  • When sending an email, log it in your database along with a unique number (perhaps the using the microtime() function).
  • Append that unique number to the links, so that they can be read via the $_GET array. For example: www.example.com/page.php?id=123456
  • When the link is clicked, have your PHP code match the number to your database log and retrieve the email.
  • Add the hit to your database.
May 20 '08 #2
dlite922
1,584 Expert 1GB
...I am not familiar with PHP but can use HTML and javascript...
You definetly need to know PHP and how to use PHP with MySQL perhaps we can direct you to some sites

Here's one we love: http://w3schools.com/php/default.asp
May 21 '08 #3
TheServant
1,168 Expert 1GB
You definetly need to know PHP and how to use PHP with MySQL perhaps we can direct you to some sites

Here's one we love: http://w3schools.com/php/default.asp
For a very basic one, I used tizag which started me off on my PHP road!
May 21 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: Harold | last post by:
Hi, I have a question in SQL Server 2K, I use SQL Profile to trace, and find Stored Procedure was auto recompiled, like this row in the trace: SP:Recompile 15 1680 76 2004-02-27 16:01:11.610 ...
8
by: Bruce Stockwell | last post by:
the setup: Webservice/WinClient application/SQL server. VS.Net (visual basic) winform wizard creates a simple form with load cancel cancelall and datagrid bound to a simple Dataset with one...
20
by: Vijay Kumar R. Zanvar | last post by:
Hello, Unlike register, auto keyword can not be used to declare formal parameter(s). Is there any specific reason for this? Kind regards, Vijay Kumar R. Zanvar
6
by: Alpha | last post by:
I retrieve a table with only 2 columns. One is a auto-generated primary key column and the 2nd is a string. When I add a new row to the dataset to be updated back to the database. What should I...
13
by: Matik | last post by:
Hello everybody, First: SQL Server 2000 sp3a, HP cluster server, MS 2003 server, database recovery model simple Torn page detection: When I have this option turned on, processes conected with...
13
by: S.Dickson | last post by:
I had an access database that i use as an ordering system. I have a form for entering customer details. When i add a new customer on the form the customer number is an auto number that appears when...
9
by: Beowulf | last post by:
I was having this problem: http://groups.google.com/group/microsoft.public.sqlserver.server/msg/e36e423972323378?dmode=source with it taking an inordinate amount of time to enumerate the...
9
by: danielbuus | last post by:
Hey there :) I'm using Ruby on Rails to create a migration of a legacy database on an MS SQL Server. I'd like to name my constraints myself, such as 'pk_authors', but in the cases where a table...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.