777 upload permission problem

[esandra]

this script is supposed to save my $csvfile to a .sql file name $ouputfile  into a folder called files/

 

$csvfile = $_FILES['file']['name']; //form from another folder

 

$save = 1;

$outputfile = "output.sql";

 

here is the save script

if($save) {

chmod($csvfile, 0777);

if(!is_writable($outputfile)) {

echo "File is not writable, check permissions.\n"; //when i execute this script, it goes in here

}

 

else {

$file2 = fopen($outputfile,"w");

 

if(!$file2) {

echo "Error writing to the output file.\n";

}

else {

fwrite($file2,$queries);

fclose($file2);

}

}

[esandra]

here is my whole xls to sql upload script just in case youll need it

$csvfile = $_FILES['file']['name'];
/********************************/
/* Would you like to add an ampty field at the beginning of these records?
/* This is useful if you have a table with the first field being an auto_increment integer
/* and the csv file does not have such as empty field before the records.
/* Set 1 for yes and 0 for no. ATTENTION: don't set to 1 if you are not sure.
/* This can dump data in the wrong fields if this extra field does not exist in the table
/********************************/
$addauto = 0;
/********************************/
/* Would you like to save the mysql queries in a file? If yes set $save to 1.
/* Permission on the file should be set to 777. Either upload a sample file through ftp and
/* change the permissions, or execute at the prompt: touch output.sql && chmod 777 output.sql
/********************************/
$save = 1;
$outputfile = "output.sql";
/********************************/


if(!file_exists($csvfile)) {
echo "File not found. Make sure you specified the correct path.\n";
exit;
}

$file = fopen($csvfile,"r");

if(!$file) {
echo "Error opening data file.\n";
exit;
}

$size = filesize($csvfile);

if(!$size) {
echo "File is empty.\n";
exit;
}

$csvcontent = fread($file,$size);

fclose($file);

$con = @mysql_connect($databasehost,$databaseusername,$databasepassword) or die(mysql_error());
@mysql_select_db($databasename) or die(mysql_error());

$lines = 0;
$queries = "";
$linearray = array();

foreach(explode($lineseparator,$csvcontent) as $line) {

$lines++;

$line = trim($line," \t");

$line = str_replace("\r","",$line);

/************************************
This line escapes the special character. remove it if entries are already escaped in the csv file
************************************/
$line = str_replace("'","\'",$line);
/*************************************/

$linearray = explode($fieldseparator,$line);

$linemysql = implode("','",$linearray);

if($addauto)
	$query = "insert into $databasetable values('','$linemysql');";
else
	$query = "insert into $databasetable values('$linemysql');";

$queries .= $query . "\n";

@mysql_query($query);
}

@mysql_close($con);

if($save) {
chmod($csvfile, 0777);
if(!is_writable($outputfile)) {
	echo "File is not writable, check permissions.\n";
}

else {
	$file2 = fopen($outputfile,"w");

	if(!$file2) {
		echo "Error writing to the output file.\n";
	}
	else {
		fwrite($file2,$queries);
		fclose($file2);
	}
}}

echo "Found a total of $lines records in this csv file.\n";

[KingOfHeart]

If my memory serves right. Try right clicking on the file/folder and look for something about permissions or Chmod or cmod. Then check everything you want to allow.

[chintansshah]

Hello,

 

Please check following things.

1. File uploaded/created properly

2. Where you saved your $outputfile, give server path.

3. chmod, check path also

4. is_writable, please give a file path also.

 

For, debugging mode, please put exit(); after chmod and run the script and check if file has 777 permission or not.

 

[inversesoft123]

Do you got internal server error after opening file on web browser? IF so check your php.ini file about mod suPHP.