PHP Forum

**julie517** · 10-28-2009, 04:37 AM

Hi,

I am new here and bit confused with one of my php projects.

Any help is highly appreciated.

My Problem :

I want users to upload multiple files at a time and store the data in mysql.

I have done this for one file, where in user can upload one file and the
data is processed and inserted to mysql...

My question is how can i do the same for multiple files.

My HTML Codes and php code to upload one file is as follows :

________Html Codes ____________________________

<html>

<head>

<title>New Page 1</title>
</head>

<body>
<form method="post" enctype="multipart/form-data" action="upload.php">
<table width="350" border="0" cellpadding="1" cellspacing="1" class="box">
<tr>
<td width="246">
<input type="hidden" name="MAX_FILE_SIZE" value="2000000">
<input name="userfile" type="file" id="userfile" size="20">
</td>
<td width="80"><input name="upload" type="submit" class="box" id="upload" value=" Upload "></td>
</tr>
</table>
</form>
</body>

</html>

___________________PHP CODES _________________________

<?php
if(isset($_POST['upload']) && $_FILES['userfile']['size'] > 0)
{
$fileName = $_FILES['userfile']['name'];
$tmpName = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];

$fp = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);

if(!get_magic_quotes_gpc())
{
$fileName = addslashes($fileName);
}
// Make a MySQL Connection
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("pj1") or die(mysql_error());
mysql_query("CREATE TABLE usrfiles(
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(30) NOT NULL,
type VARCHAR(30) NOT NULL,
size INT NOT NULL,
content MEDIUMBLOB NOT NULL,
PRIMARY KEY(id)
)")
or die(mysql_error());

$query = "INSERT INTO usrfiles (name, size, type, content ) ".
"VALUES ('$fileName', '$fileSize', '$fileType', '$content')";

mysql_query($query) or die('Error, query failed');

echo "<br>File $fileName uploaded<br>";
echo "<br> New File Created with data<br>";

}
?>

_______________________END CODE_________________

Julie

**chrishirst** · 10-28-2009, 05:19 AM

a foreach loop

**tripy** · 10-28-2009, 05:19 AM

make the upload hanlder a function, and do an iteration over $_FILES[]:

PHP Code:


			
<?php
function dbInit(){
    mysql_connect("localhost", "root", "") or die(mysql_error());
    mysql_select_db("pj1") or die(mysql_error());
    
    mysql_query("CREATE TABLE if not exists usrfiles(
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(30) NOT NULL,
type VARCHAR(30) NOT NULL,
size INT NOT NULL,
content MEDIUMBLOB NOT NULL,
PRIMARY KEY(id)
)") or die(mysql_error());
}

function handleUpload($index){
    if(isset($_FILES[$index]===false){
        return false;
    }
    
    $fileName = $_FILES[$index]['name'];
    $tmpName = $_FILES[$index]['tmp_name'];
    $fileSize = $_FILES[$index]['size'];
    $fileType = $_FILES[$index]['type'];
    
    $fp = fopen($tmpName, 'r');
    $content = fread($fp, filesize($tmpName));
    $content = addslashes($content);
    fclose($fp);
    
    if(!get_magic_quotes_gpc()){
        $fileName = addslashes($fileName);
    }
    
    if($fileSize>0){
        dbInit();
        $query = "INSERT INTO usrfiles (name, size, type, content ) ".
"VALUES ('$fileName', '$fileSize', '$fileType', '$content')";

        mysql_query($query) or die('Error, query failed');
    
        echo "<br>File $fileName uploaded<br>";
        echo "<br> New File Created with data<br>";
    }
}

if(isset($_POST['upload'])){
    foreach($_FILES as $key=>$ar){
        handleUpload($key);
    }
} 

?>

This is just typed in notepad, live, so I don't guarantee there is no error, but you'll get the idea and the start point.

**jim1228** · 10-28-2009, 02:09 PM

Just a tip:

Use mysql_real_escape_string rather then addslashes

**julie517** · 10-30-2009, 02:07 AM

I am still unable to get this done, have searched the net a lot but could
not find and proper codes for this.

Kindly help with the exact codes.

thanks

Julie

**lizciz** · 10-30-2009, 03:31 AM

That's what Tripy did, gave you the exact codes. Have you tried it?

**fortressrealcap** · 09-06-2011, 03:15 PM

Quote:

Originally Posted by tripy

make the upload hanlder a function, and do an iteration over $_FILES[]:

PHP Code:


			
<?php

function dbInit(){

    mysql_connect("localhost", "root", "") or die(mysql_error());

    mysql_select_db("pj1") or die(mysql_error());

    

    mysql_query("CREATE TABLE if not exists usrfiles(

id INT NOT NULL AUTO_INCREMENT,

name VARCHAR(30) NOT NULL,

type VARCHAR(30) NOT NULL,

size INT NOT NULL,

content MEDIUMBLOB NOT NULL,

PRIMARY KEY(id)

)") or die(mysql_error());

}



function handleUpload($index){

    if(isset($_FILES[$index]===false){

        return false;

    }

    

    $fileName = $_FILES[$index]['name'];

    $tmpName = $_FILES[$index]['tmp_name'];

    $fileSize = $_FILES[$index]['size'];

    $fileType = $_FILES[$index]['type'];

    

    $fp = fopen($tmpName, 'r');

    $content = fread($fp, filesize($tmpName));

    $content = addslashes($content);

    fclose($fp);

    

    if(!get_magic_quotes_gpc()){

        $fileName = addslashes($fileName);

    }

    

    if($fileSize>0){

        dbInit();

        $query = "INSERT INTO usrfiles (name, size, type, content ) ".

"VALUES ('$fileName', '$fileSize', '$fileType', '$content')";



        mysql_query($query) or die('Error, query failed');

    

        echo "<br>File $fileName uploaded<br>";

        echo "<br> New File Created with data<br>";

    }

}



if(isset($_POST['upload'])){

    foreach($_FILES as $key=>$ar){

        handleUpload($key);

    }

} 



?>

This is just typed in notepad, live, so I don't guarantee there is no error, but you'll get the idea and the start point.

Hey Trippy,

That's a smart idea, i'm trying to do something similar but the form I'm using is quite long and the files need to be appended to the record the form is already creating. I'm going to look into it but any other thoughts and ideas would be appreciated.
Thx

**dgkindy** · 09-06-2011, 07:06 PM

If your not too proud to be borrow and steel, here is a nice system for uploading several files. I used it to upload 100 files all at once and it provides a status for each file that is uploaded.

http://webdeveloperplus.com/jquery/m...-using-jquery/