Estimated download time?

[seby]

i am storing filesize in mysql in KB.
i want to caculate the 'average' amount of time it will take to download, based on 56k, 640k and 1500k.

Example:
[pre]
Filesize: 10,000 KB

Estimated download time:

56k - 20 minutes
640k - 10 minutes
1500k - 5 minutes
[/pre]

.. What is the easiest method to do this on the fyi? anyone have ideas, suggestions?

[Silverlime]

I haven't tested this, but I am thinking this function should do the trick:

function download_timer ($file, $connection)
{
$time_secs = $file / connection;
$time_mins = $time_secs / 60;
return $time_mins;
}

I think that should work. The $file argument is the filesize (from the D😎, and the $connection argument is the connection speed in KB/S. Here's how I would call it:

echo 'File size: ' . $file . 'KB';
$speeds = array('56','640','1500');
while (list(, $speed) = each($speeds))
{
echo 'On ' . $speed . 'K: ' . download_timer($file,$speed);
}

[seby]

i tried using the second part, and i get a unknown download_timer function error.

[Silverlime]

You have to copy the first code (the function itself) into the file, also 🙂

[seby]

sorry bare with me.. it just looks funny.

function download_timer ($filesize, $connection) 
{ 
$time_secs = $file / $connection; 
$time_mins = $time_secs / 60; 
return $time_mins; 
}

echo 'File size: ' . $filesize . 'KB';

$speeds = array('56','640','1500'); 
while (list(, $speed) = each($speeds)) 
{ 
echo 'On ' . $speed . 'K: ' . download_timer($filesize,$speed); 
}

The first part, where you made the function, it doesn't pass anything. it returns $time_mins; but what does it do after that? This is how it echo on a 956 KB file:

On 56K: 0 On 640K: 0 On 1500K: 0

just a little confused 😉

[Silverlime]

This is the right code, you edited the function!

function download_timer ($file, $connection)  

{  

$time_secs = $file / $connection;  

$time_mins = $time_secs / 60;  

return $time_mins;  

} 

echo 'File size: ' . $filesize . 'KB'; 

$speeds = array('56','640','1500');  

while (list(, $speed) = each($speeds))  

{  

echo 'On ' . $speed . 'K: ' . download_timer($filesize,$speed);  

}

[seby]

Originally posted by Silverlime
This is the right code, you edited the function!

i did? they look the same to me .. hmm.

question: what is $connection doing if there is already an array with the connection speed?
can you test the code to see ?

[batman]

Why mess with functions to do a simple script?
You can use something like this, and get away just fine.

//your sql connect info here

//modify the query to get the size of file
$sql = mysql_query("SELECT file FROM table WHERE file='$file'");
$result = mysql_fetch_array($sql);
$file = $result['file'];
$1 = "$file / 56";
$2 = "$file / 640";
$3 = "$file / 1500";

echo "Estimated Download Speed: <br> 
56K: $1  640K: $2  1500K: $3";

Just modify it to fit your needs,
-Blake

[seby]

Batman... it returns this:

Parse error: parse error, unexpected T_LNUMBER, expecting T_VARIABLE or '$'

This is weird, I added your code you just a test.php file and it still gives that error, i dont see anything wrong with the code, weird?

[Silverlime]

Take the quotes away from his code here:

$1 = "$file / 56"; 
$2 = "$file / 640"; 
$3 = "$file / 1500";

And I would definitely use functions, much much cleaner. And the connection found in the array is passed to the function to the $connection variable. I guess I am speaking over your heads :rolleyes:

[seby]

Silverlime, I appreciate your help, but your code doesn't seem to work.. give it a test and you'll see what i mean.

Batman, I am getting weird numbers... see attached image. that can't be in seconds because there is no way a 56k connection can download 2 megs in 42 seconds... any ideas?

[batman]

hmmm....let me see. Are you positive that the file size it's returning is in kb?

[SP8600]

Devide

$1 = "$file / 56";

etc...

by 60 twice then it will be in minutes

$1 = "$file / 56 / 60 / 60";

[batman]

Oh yes 🙂 Here is new code:

//your sql connect info here 

//modify the query to get the size of file 
$sql = mysql_query("SELECT file FROM table WHERE file='$file'"); 
$result = mysql_fetch_array($sql); 
$file = $result['file']; 
$1 = $file / 56 / 60/ 60; 
$2 = $file / 640 / 60 / 60; 
$3 = $file / 1500 / 60 / 60; 

echo "Estimated Download Speed: <br> 
56K: $1  640K: $2  1500K: $3";