Rating Options [PHP] - [Simple download counter] - [Gio], for the confused one

[_*Gio_*]

Ok this tutorial will simply show you how to display the number of times a certain file has been downloaded. It can also be altered to show number of times it was clicked.

The SQL

CODE

CREATE TABLE counter (
id int(5) DEFAULT '0' NOT NULL auto_increment,
FileName varchar(50) NOT NULL,
FileURL varchar(255) NOT NULL,
Count int(5) NOT NULL,
PRIMARY KEY (id)
);

Basically the sql table has fields for the id, which is unique for each file, the file name, the file url, and the count.

The viewing of the file.

View.php

CODE

<?php

include "connect.php";

$x ="SELECT * from counter order by FileName";
$result = mysql_query($x) or die
("Could not execute query : $x." . mysql_error());

echo "<p align=center><b>File Download</b></p>";
echo "<ol>";

while ($row=mysql_fetch_array($result))
{
$id = $row["id"];
$FileName = $row["FileName"];
$FileURL = $row["FileURL"];
$Count =$row["Count"];


echo "<li><a href=download.php?id=$id>$FileName</a></li>";
}
?>

First you connect then you select the downloads and order them by the filename, and if sql will not connect the script dies immediately. Then you echo File Download fetch the resaults of your previous query and order them out to look pretty, then link them!

Now for the download counter, and of course the download!

Download.php

CODE

<?php

// Database connection stuff here

$x ="SELECT * from counter where id='$id'";
$result = mysql_query($x) or die
("Could not execute query : $x." . mysql_error());

while ($row = mysql_fetch_array($result))
{
$id = $row["id"];
$FileName = $row["FileName"];
$FileURL = $row["FileURL"];
$Count = $row["Count"];

header('Location: '.$FileURL);

$x ="update counter set Count=Count+1 where id='$id'";
$result = mysql_query($x) or die
("Could not execute query : $x." . mysql_error());

}

?>

Ok I shall explain this part as well. First you query the database and get the id of the file selected. Then it finds it or the script automatically dies. Define the id filename fileurl and the times downloaded. It redirects the user to the file, and adds 1 more number to the download stats.

[_*Jay_*]

nice tut, nice to see p2l can write them as well as provide links to them

[_*Gio_*]

Yah I am still not sure why Faken never premoted me to staff, but I am just trying to get the p2l tut count up so were not just an indexing service.

[_*Anarchy_*]

very useful...

[_*Gio_*]

Thanks dude, I was wondering if anyone actually read them.

[_*SERB-4-LIFE_*]

i do i read every single one in the forum and heaps from the site

[_*Andy_*]

^^ nice... alot of that confuses me as well as it has been explained.

PHP is not my thing, feels good when you set something up though, HAHA. Nice tut, will definatley come in handy!

Thanks,
Andy

[_*SERB-4-LIFE_*]

well its not my thing but it is when someone does all the code for me and tells me how to use it but all i can write in php is <?php ?> thats it

so thats whats so special about this site, it gives me the code and its easy to use

[_*Gio_*]

Hey I am always happy to provide. Just do not ask for everything, it is easier sometimes to try to do it yourself then ask for help with what ever your not getting. That way you dont seem greedy.

[_*SERB-4-LIFE_*]

i did as much as i could with no help now i need it

[_*Gio_*]

Sorry but I do not think of

CODE

<?

?>

As real coding, I mean put some real effort into it. Things will not always be done for you for free. Sometimes you gotta give alittle to get alittle.

[_*SERB-4-LIFE_*]

yeh i know is there a site where it learns u step by step php ??

[_*Jay_*]

i'd love to create such a site if i ever got time

[_*Gio_*]

That would take sooo long though, try W3 Schools. They teach you stuff step by step and even provide tests for you to take.

[_*Anarchy_*]

yeah, w3schools look great, i just started, and it looks like they provide pretty much everything.

[_*Gio_*]

Kind of, pretty much as basic as it gets.

[_*SERB-4-LIFE_*]

yeh but it takes a while to finish all of it

[_*Gio_*]

Anyways back on topic, SERB did you decide to use this one?

[_*SERB-4-LIFE_*]

yeh i did when u come to msn ull give me a leson on how to use this i want to use it but its 2 complicated so ull help me out

[_*Gio_*]

I will do, just post any problems with it here so they can be fixed immediately.