Posted by David Robley on 10/19/05 12:37

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('<p>Erreur :' . mysql_error().'<p>');}
> //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.

[Back to original message]