[Building a File Publishing Tool / Web Page]

Yes, Five

 

Sort of a 'Excel File Parser' in PHP.

I am already using PHPfileexplorer tool but that only good to retrieve data from excel file to html, but not to save that data in database.

[Building a File Publishing Tool / Web Page]

Hi,

 

I am already saving the file name to a seperate table in a database. - Acheived this by listing the file name, and passing the name as a variable to mysql_query insert statement.

 

Now I need is to a 'save the data in those excel files' into the 'database'. - Controlling this via Web Inteface.

 

Regards,

[Building a File Publishing Tool / Web Page]

Hi friends

 

I am developing a functionality in a website where a Admin can publish/save 'excel' files to a database, that are uploaded to a server by members. To achieve this I have devised the following steps.

 

1. A webpage that let admin view all the files uploaded on the server in a particular directory (.files/) . - DONE

2. A PHP code that can grab names of the files in a array.

3. A PHP wepage that can automatically publish/save those file to a database, without human intervention.

[This page being able to read the array, and store the results in a database].

 

Its a bit complicated process, but does anyone knows how to acheive this as to what should steps should I take to acheive this. Please guide me through this. If you want any more clarification as to what I am trying to achieve, then in simple term 'Publishing a file to database, via web interface'.

 

Regards,

Abhishek

 

[Listing files from a directory]

Thanks for all your help.

 

I am really grateful to you people.

 

I am using this code, as I found it on php.net, but sooner or later I will try scandir() function to list file.

 

Thanks again.

[Simple file upload problem]

Hi,

 

Try making the changes that above user has mentioned.

 

Otherwise try this below script that works for my project

 

	

<input type='file' name='filename' size='25'>
<input type='hidden' name='action' value='fileupload'><br>
<input type=submit value='Upload File'>";

<?php

//Catching the variable value for upload script and setting the maximum upload size of a file.
$action = $_POST["action"];
$max_size = "1048576"; // Max size in BYTES (1MB)

if ($action == 'fileupload')
{
	if ($_FILES["filename"]["size"] > $max_size) die ("<b>File too big!  Try again...</b>");

		$location="./files/";
		copy($_FILES["filename"]["tmp_name"],$location.$_FILES["filename"]["name"]) or die("<b>Unknown error!</b>");
		$xlsfilelocation=$location.$_FILES["filename"]["name"];								
		echo "<b><br><br>File Uploaded.</b>";
		// for debug -->  $filename --> ".$destination."/".$filename_name."</h2>";
}
?>

 

Regards,

Abhishek

[Listing files from a directory]

Thanks,

 

I understood that it means that reads the list of files, till there are no more in that directory.

 

So what role does !== [not identical to] plays in the while loop.

 

Regards

[Listing files from a directory]

Hi friends,

 

I took this script from php.net that lists a name of file from a specified directory.

 

	$path = "./files/";
if ($handle = opendir($path)) 
{
# 
while (false !== ($file = readdir($handle)))
{
	if ($file != "." && $file != "..")
	{
		$thelist .= '<a href="'.$file.'">'.$file.'</a>';
	}
}
closedir($handle);
}

 

can someone please shed off some light as to how this line of code is processed, and what it means.

 

while (false !== ($file = readdir($handle)))

 

Regards,

Abhishek