By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,983 Members | 1,717 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,983 IT Pros & Developers. It's quick & easy.

Update a counter when a link is clicked

P: n/a
Hello

I have seen some tutorials to put a update a counter field in a record. I
have the counter field in a table that also has a field for a path to file.

I display the records in a table on a web page e.g.

IndexNo ............Title................................ Link
.................................... Count
......1.............MyFileName........www.mysite/files/MyFileName.doc........
......0
etc

User can click on the Link field in the table to download the file.

The problem is I can't find a way that will run an update query along the
lines of

$Query = mysql_query("UPDATE Resources SET Count = Count + 1 WHERE IndexNo
= '$IndexNo');

when the user clicks the link

Can anyone suggest a way or direct me to a tutorial

Thanks
Ian

Apr 26 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Ian Davies wrote:
Hello

I have seen some tutorials to put a update a counter field in a record. I
have the counter field in a table that also has a field for a path to
file.

I display the records in a table on a web page e.g.

IndexNo ............Title................................ Link
................................... Count
......1.............MyFileName........www.mysite/files/MyFileName.doc........ .....0
etc

User can click on the Link field in the table to download the file.

The problem is I can't find a way that will run an update query along the
lines of

$Query = mysql_query("UPDATE Resources SET Count = Count + 1 WHERE
IndexNo
= '$IndexNo');

when the user clicks the link

Can anyone suggest a way or direct me to a tutorial

Thanks
Ian


Hi,

Your question is very clear, but if I understand right, this may help:

1) Make a link to a increasecounter.php and add the filename:
<a href="increasecounter.php?filename=MyFileName.doc" >

2) In increasecounter.php:
$filename = $_GET["filename"];
// do your update in the db here

3) Redirect to the file
header("Location: MyFileName.doc");
exit;

Regards,
Erwin Moller

Apr 27 '06 #2

P: n/a
Thanks for your advice
Your code was just what I was looking for
It is updating the table with the counter but it is not bringing up the file
to download any more

The modified code is as follows

<a href="increasecounter.php?filename=<?php echo $Link; ?>"

The $Link returns the full path to the file (from the same table as the
count field)

In my increase counter.php I have

***************************************
$filename = $_GET["filename"];
echo $filename;
$Query = mysql_query("UPDATE Resources SET count = count + 1 WHERE Link =
'$filename'");
header("Location: $filename");
exit;
***************************************
I put the echo in just to check the file name is correct
which it is as it is used in the SQLs WHERE clause and it updates the record
as I mentioned earlier
But the file to download is not appearing. Can you see what is wrong
The address in the browser window is as follows if it helps
http://www.mysite.co.uk/increasecoun...ers/MyFile.doc

which appears to be wrong
when the file was downloading previously the address would have been

http://www.mysite.co.uk/Resources/Others/MyFile.doc

Any clues
Thanks
Ian

"Erwin Moller"
<si******************************************@spam yourself.com> wrote in
message news:44***********************@news.xs4all.nl...
Ian Davies wrote:
Hello

I have seen some tutorials to put a update a counter field in a record. I have the counter field in a table that also has a field for a path to
file.

I display the records in a table on a web page e.g.

IndexNo ............Title................................ Link
................................... Count

......1.............MyFileName........www.mysite/files/MyFileName.doc........
.....0
etc

User can click on the Link field in the table to download the file.

The problem is I can't find a way that will run an update query along the lines of

$Query = mysql_query("UPDATE Resources SET Count = Count + 1 WHERE
IndexNo
= '$IndexNo');

when the user clicks the link

Can anyone suggest a way or direct me to a tutorial

Thanks
Ian


Hi,

Your question is very clear, but if I understand right, this may help:

1) Make a link to a increasecounter.php and add the filename:
<a href="increasecounter.php?filename=MyFileName.doc" >

2) In increasecounter.php:
$filename = $_GET["filename"];
// do your update in the db here

3) Redirect to the file
header("Location: MyFileName.doc");
exit;

Regards,
Erwin Moller

Apr 27 '06 #3

P: n/a
You cannot have anything printed before header(). Remove echo filename;
and try running the script.

Hope this helps.

Thanks and God Bless!!

Ehsan
http://ehsan.bdwebwork.com

Apr 28 '06 #4

P: n/a
Ehsan

That was the problem
Thanks

Ian
"Ehsan" <ha*********@gmail.com> wrote in message
news:11*********************@i39g2000cwa.googlegro ups.com...
You cannot have anything printed before header(). Remove echo filename;
and try running the script.

Hope this helps.

Thanks and God Bless!!

Ehsan
http://ehsan.bdwebwork.com

Apr 28 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.