Home arrow PHP arrow Page 2 - File Management with PHP

Building the Database - PHP

We can find many articles related to uploading, viewing, and downloading files. This article is written on the basic concept of uploading and managing files. File uploading is the process of copying the file from your machine to the remote server. Other users of the same system then share this file by viewing or downloading it. What happens when you upload a file that already exists in the remote folder to which you are uploading?

TABLE OF CONTENTS:
  1. File Management with PHP
  2. Building the Database
  3. File_Size() and Display_form Functions
  4. The Main Program
By: Murali Dharan.M
Rating: starstarstarstarstar / 77
March 29, 2004

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

Name the database "upload". The database contains the table 'file_manager', which manages file information. The SQL statement for creating the table:


CREATE TABLE file_manager (
file_name varchar
(50) default NULL

file_type varchar
(20NOT NULL default ''
file_size varchar
(20NOT 
NULL 
default ''
file_modified varchar
(20NOT NULL default ''

file_parent_id mediumint
(9) default NULL
file_image_name varchar
(50
default 
NULL
 
KEY file_name (file_name), 
KEY file_image_name 
(file_image_name)

TYPE=MyISAM

File Management
I've written two programs to manage this file version. The first uploads the file (file_upload_manager.php), the second displays the file (file_upload_manager.php). The source code is tested on a Windows system.

NOTE:  Linux users, please change the folder path accordingly.

File Upload Manager:
This program displays a menu to select the file in your system, a check box and an Upload button. Once the user clicks the upload button, the program checks the file for existence, and undergoes a series of tests as described in the plan.

Now let's look at the code snippets used in the program.


$dir_path Variable:

This variable is the destination folder path.


$dir_path"C:apachehtdocsfilemanager";

This path is given for Windows-based systems. Please change your destination folder accordingly.


Get_New_File_Name() Function:

This function is called from the main program when the program encounters files that exist and show a difference in size, date or time. This function will generate a new file name and return to the main function.


function Get_New_FIle_Name($file_name)
{
  
$sqlQuery
="SELECT  file_image_name FROM file_manager WHERE  file_name 
LIKE '
$file_name%' AND  file_parent_id=1";
 
  
$fResult=mysql_query($sqlQuery);
  $Last_Version
=0;
  
$ver
=0;
 
  if(
mysql_num_rows($fResult)){
      
while($fRow=mysql_fetch_array($fResult)){          

 
list(
$junk,$ver)=explode("_VERSION",$fRow['file_image_name']);
         
list($ver,$extn)=explode(".",$ver);
         
$Last_Version 
$Last_Version $ver $Last_Version 
 
$ver;
       
}
  
}else{
      $new_file_name 
=$file_name."_VERSION".++$Last_Version;
      
return 
$new_file_name;
  
}
 
  if(
$Last_Version !=0){
      
$new_file_name
=$file_name."_VERSION".++$Last_Version;
      
return $new_file_name;
  
}
}

The sql query in the beginning of the function will fetch file names of previous versions. If the sql query returns record sets, it means the file has previous versions. The while loop is executed to store the generated version number, and the value obtained is stored in $Last_Version. Otherwise, the new file name will be generated as file-name_VERSION1.

The next if statement checks for $Last_Version != 0, if true, $Last_Version is incremented by 1 and a new file name is assigned.

The return statement will return a new file name generated to the called statement.



 
 
>>> More PHP Articles          >>> More By Murali Dharan.M
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

PHP ARTICLES

- Hackers Compromise PHP Sites to Launch Attac...
- Red Hat, Zend Form OpenShift PaaS Alliance
- PHP IDE News
- BCD, Zend Extend PHP Partnership
- PHP FAQ Highlight
- PHP Creator Didn't Set Out to Create a Langu...
- PHP Trends Revealed in Zend Study
- PHP: Best Methods for Running Scheduled Jobs
- PHP Array Functions: array_change_key_case
- PHP array_combine Function
- PHP array_chunk Function
- PHP Closures as View Helpers: Lazy-Loading F...
- Using PHP Closures as View Helpers
- PHP File and Operating System Program Execut...
- PHP: Effects of Wrapping Code in Class Const...

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: