[PHP] Re: Help needed with calculation

[Ben]

Chris Payne wrote:

Hi everyone,

I'm not sure of the correct formula for this, if I have a file - just
for example, that is 10245458756 bytes long and the download speed is
60KB a second, what formula would I use to calculate how many
seconds/minutes/hours it would take to download the file?

Maths really isn't my strong point and formulas go over my head
otherwise I wouldn't ask :-(

Thanks everyone

Chris


$size = 1024548756; // in bytes
$kb_per_sec = 60;   // I assume you'll fill these in from elsewhere?

$b_per_sec = $kb_per_sec * 1024;

$seconds = $size / $b_per_sec;
$minutes = 0;
$hours = 0;

if($seconds > 60)
{
  // 60 seconds to a minute
  $minutes = (int)($seconds / 60);
  $seconds -= $minutes * 60;

  if($minutes > 60)
  {
// 60 minutes to an hour
$hours = (int)($minutes / 60);
$minutes -= $hours * 60;

// if you want to go further and calculate days, have at :)
  }
}

You could also approach this using modulus, but if you're not confident 
with math, this might be a more intuitive approach.


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Re: Help needed / failed to open stream: Permission denied

[Mark Rees]

 >
> > This is line 57 $file_handle = fopen("./" . $file_name, "r");
>
> It seems that the user your web server runs as may not have permission to
> open that file. Also, you might want to double check that ./$ile_name is a
> valid path.

And if you're planning to write to the file, you need to specify that. "r"
means "open for reading only". Read up on the possibilities here:

http://uk2.php.net/fopen

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Re: Help needed / failed to open stream: Permission denied

[David Robley]

Ndagi Mutiri wrote:

> Hello,
> 
> Trying to read a binary file in MySQL database, i have the following error
> :
> 
> Warning: fopen(./) [function.fopen]: failed to open stream: Permission
> denied in d:\...\download.php on line 57
> 
> This is line 57 $file_handle = fopen("./" . $file_name, "r");

It seems that the user your web server runs as may not have permission to
open that file. Also, you might want to double check that ./$ile_name is a
valid path.
 
> and my function
> 
> function db_download_file($dbname, $file, $idreunion) {
> //Sélectionne la base de données
> mysql_select_db($dbname);
> 
> //Requête SQL
> $select = "SELECT " . $file . " FROM inter_vertaaldienst WHERE id_reunion
> = '" . $idreunion . "'";
> 
> //Exécution de la requête
> $file_records = @mysql_query($select);
> 
> //En cas d'erreur, on affiche un message
> if (!$file_records){echo('Erreur :' . mysql_error().'');}
> //Autrement, on affiche le fichier
> else{
> if($file_record = mysql_fetch_array($file_records)){
> $file_handle = fopen("./" . $file_name, "r");
> $file_bytes = $file_record[0];
> fwrite($file_handle, $file_bytes, strlen($file_bytes));
> $return_value = "./" . $file_name;
> }
> }
> return($return_value);
> }
> 
> Thank for your help.
> Ndagi




Cheers
-- 
David Robley

A cat will go "quack" - if you squeeze it hard enough.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Re: Help Needed

[Mark Rees]

http://uk2.php.net/manual/en/function.mssql-query.php

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Re: Help needed

[Jason Barnett]

Completely new?  Well, there are a lot of articles on the web that will 
get you started... just try googling for "MySQL PHP tutorial".  If 
you're willing to put in the time you can do it yourself... but there 
are a lot of PHPers out there that can do it for you right now.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Re: Help needed

[Pete Morganic]

Where does thejavascript fit ?

Nirmala P wrote:
Hi Pete Morganic ,
Thanks for reply. But the code is not solving my problem. May be I did 
not epress my problem clearly.
Actually I wanted to store the returned value so that I can write it on 
page like
{ test = ');
 document.write(test);
}
and moreover the value I am passing is  "material"  and "E" is not 
getting parsed to PHP function. PHP function input for $field and $lang  
will be FieldName and LangName only.

looking for help
regards
Nirmala P.
On Mon, 30 Jun 2003 Pete Morganic wrote :

Nirmala P wrote:

Hi list,
This time i am pasting my code could any body tell where wrong I am ?

   if(!$db) echo("Connect to localhost mysql database failed");

   if(!mysql_select_db("eshop",$db)) echo ("Selection of eshop failed 
on MySQL database");

   $Sql = "SELECT " . $field ." FROM language where LangCode = 
"."'".$lang."'";

   $result = mysql_query($Sql,$db);

   if($result)
   {
 $myrow = mysql_fetch_array($result);
 $value = $myrow[$field];
// return valus
return($value);
   }
   else echo (" No Record Found");
 }
?>

  FieldName = "Material";
  LangName = "E";