question about download counter??

kfresh

I have the following script to track the downloads

<? php
$cm = "Location: $file";
header ($cm);

$db_user        = "username";
$db_passwd      = "paswword";
$db_name        = "dbname";

$db = mysql_connect("localhost", $db_user, $db_passwd);
mysql_select_db($db_name, $db);

mysql_query("UPDATE downloads SET counter=counter+1 WHERE file='$file'",$db);

if (mysql_affected_rows($db) < 1) {
 $result = mysql_query("INSERT INTO downloads VALUES ('$file', 1)", $db); }
mysql_close($db);
?>

and the following table set up

file | counter

(url) | (number of clicks)

and i found a script onthis forum to display the counter on the page....

<? 
$conn = mysql_connect("localhost", "username", "passwords"); 
mysql_select_db("database"); 
$query = "select * from downloads"; 
$result = mysql_query($query) or die(mysql_error()); 
$row = mysql_fetch_object($result); 
$dlnum = $row->dlnum; 
echo "Downloads of something: ".$dlnum; 
mysql_close($conn); 
?>

my questions is... i'm going to have multiple download links on the same page... how would i change the second script to be able to display the counter results? and how would i displayed multiple different counters on one page for each download??

any help would be great....

laserlight

Well, how you want the download counter displayed is actually up to you.
One way would be to place the number in parentheses next to the download link.

You just need to query for the counter info, and then loop through the results.

kfresh

yeah i dont need any advance display of it... i'm just going to have a regular text number next to the file...

forgive me.. i'm a newbie.... and i just need to know... how i would go about replicating the counter for multiple files displayed on one page...

laserlight

one simple way would be to loop through the result set of the query and store in an array that you can then re-use on that page.

kfresh

can you give me an example of how to do that? like i said.. i'm still a newbie... and i'll probably get would you saying if i saw it...

thanx

laserlight

I'm not too clear what are your table and column names, so you'll probably have to modify this example:

<?php
$conn = mysql_connect("localhost", "username", "passwords"); 
mysql_select_db("database");
$query = "select * from downloads";
$result = mysql_query($query) or die(mysql_error());
$downloads_counter = array();
while ($row = mysql_fetch_assoc($result)) {
	$url = $row['url']; //this URL (e.g. download1.zip)
	//number of downloads associated with this URL
	$downloads_counter[] = $row['dlnum'];
}

echo '<a href="mydownload1.zip">Download1</a>(' . $downloads['download1.zip'] . ')';
?>

kfresh

Thanx!!!...ok... i almost have it working....

this is how my table looks

file | counter

audio/5ela_aintnolove.ram | 4

i still trying to get the counter number to display....

laserlight

In that case, the while loop should read:

while ($row = mysql_fetch_assoc($result)) {
    $url = $row['file']; //this URL (e.g. download1.zip)
    //number of downloads associated with this URL
    $downloads_counter[$url] = $row['counter'];
}

of course, if you know the ordering of the data in the table, you can use

while ($row = mysql_fetch_assoc($result)) {
     //number of downloads associated with current URL
    $downloads_counter[] = $row['counter'];
}

kfresh

sweet.... it worked!!! thanks for your help man....

and all i have to do is replicate the echo code through the page for the different files?

laserlight

yes, you probably have to do that.