Uploading mutiple binary files in Mysql with Php

**ronverdonk** · Nov 24 '06, 09:34 PM

Read the Posting Guidelines about usage of php, code and html tags around code you display! I will not even try to read that code from my screen!

Ronald :cool:

**underground** · Nov 24 '06, 11:14 PM

Soory for the violation.
Here is the PHP script.
[PHP]<?php
if(isset($_POST['upload']) && $_FILES['userfile']['size'] && $_FILES['audiofile1']['size'] && $_FILES['audiofile2']['size'] && $_FILES['audiofile3']['size'] && $_FILES['audiofile4']['size'] && $_FILES['audiofile5']['size'] && $_FILES['audiofile6']['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($tmpNa me));
$content = addslashes($con tent);
fclose($fp);
$fileName1 = $_FILES['audiofile1']['name'];
$tmpName1 = $_FILES['audiofile1']['tmp_name'];
$fileSize1 = $_FILES['audiofile1']['size'];
$fileType1 = $_FILES['audiofile1']['type'];

$fp = fopen($tmpName, 'r');
$audiofile1 = fread($fp, filesize($tmpNa me));
$audiofile1 = addslashes($aud iofile1);
fclose($fp);
$fileName2 = $_FILES['audiofile2']['name'];
$tmpName2 = $_FILES['audiofile2']['tmp_name'];
$fileSize2 = $_FILES['audiofile2']['size'];
$fileType2 = $_FILES['audiofile2']['type'];

$fp = fopen($tmpName, 'r');
$audiofile2 = fread($fp, filesize($tmpNa me));
$audiofile2 = addslashes($aud iofile2);
fclose($fp);
$fileName3 = $_FILES['audiofile3']['name'];
$tmpName3 = $_FILES['audiofile3']['tmp_name'];
$fileSize3 = $_FILES['audiofile3']['size'];
$fileType3 = $_FILES['audiofile3']['type'];

$fp = fopen($tmpName, 'r');
$audiofile3 = fread($fp, filesize($tmpNa me));
$audiofile3 = addslashes($aud iofile3);
fclose($fp);
$fileName4 = $_FILES['audiofile4']['name'];
$tmpName4 = $_FILES['audiofile4']['tmp_name'];
$fileSize4 = $_FILES['audiofile4']['size'];
$fileType4 = $_FILES['audiofile4']['type'];

$fp = fopen($tmpName, 'r');
$audiofile4 = fread($fp, filesize($tmpNa me));
$audiofile4 = addslashes($aud iofile4);
fclose($fp);
$fileName5 = $_FILES['audiofile5']['name'];
$tmpName5 = $_FILES['audiofile5']['tmp_name'];
$fileSize5 = $_FILES['audiofile5']['size'];
$fileType5 = $_FILES['audiofile5']['type'];

$fp = fopen($tmpName, 'r');
$audiofile5 = fread($fp, filesize($tmpNa me));
$audiofile5 = addslashes($aud iofile5);
fclose($fp);
$fileName6 = $_FILES['audiofile6']['name'];
$tmpName6 = $_FILES['audiofile6']['tmp_name'];
$fileSize6 = $_FILES['audiofile6']['size'];
$fileType6 = $_FILES['audiofile6']['type'];

$fp = fopen($tmpName, 'r');
$audiofile6 = fread($fp, filesize($tmpNa me));
$audiofile6 = addslashes($aud iofile6);
fclose($fp);
if(!get_magic_q uotes_gpc())
{
$fileName = addslashes($fil eName);
$fileName1 = addslashes($fil eName1);
$fileName2 = addslashes($fil eName2);
$fileName3 = addslashes($fil eName3);
$fileName4 = addslashes($fil eName4);
$fileName5 = addslashes($fil eName5);
$fileName6 = addslashes($fil eName6);
}
include 'config.php';
include 'opendb.php';

$query = "INSERT INTO audio (name, size, type, content, name1, size1, type1, audiofile1, name2, size2, type2, audiofile2, name3, size3, type3, audiofile3, name4, size4, type4, audiofile4, name5, size5, type5, audiofile5, name6, size6, type6, audiofile6 ) ".
"VALUES ('$fileName', '$fileSize', '$fileType', '$content', '$fileName1', '$fileSize1', '$fileType1', '$audiofile1', '$fileName2', '$fileSize2', '$fileType2', '$audiofile2', '$fileName3', '$fileSize3', '$fileType3', '$audiofile3', '$fileName4', '$fileSize4', '$fileType4', '$audiofile4', '$fileName5', '$fileSize5', '$fileType5', '$audiofile5', '$fileName6', '$fileSize6', '$fileType6', '$audiofile6')" ;

mysql_query($qu ery) or die('Error, query failed');
include 'closedb.php';

echo "<br>File $fileName uploaded<br> File $fileName1 uploaded<br>Fil e $fileName2 uploaded<br>Fil e $fileName3 uploaded<br>Fil e $fileName4 uploaded<br>Fil e $fileName5 uploaded<br>Fil e $fileName6 uploaded<br>";
}
?>
[/PHP]
and the form looks like this:
[html]
<form method="post" enctype="multip art/form-data">
<table width="350" border="0" cellpadding="1" cellspacing="1" class="box">
<tr>
<td width="246">
<input type="hidden" name="MAX_FILE_ SIZE" value="88880000 00">
<input name="userfile" type="file" id="userfile">
</td>
</tr>
<tr>
<td width="246">
<input type="hidden" name="MAX_FILE_ SIZE" value="88800000 0">
<input name="audiofile 1" type="file" id="audiofile1" >
</td>
</tr>
<tr>
<td width="246">
<input type="hidden" name="MAX_FILE_ SIZE" value="88800000 0">
<input name="audiofile 2" type="file" id="audiofile2" >
</td>
</tr>
<tr>
<td width="246">
<input type="hidden" name="MAX_FILE_ SIZE" value="88880000 00">
<input name="audiofile 3" type="file" id="audiofile3" >
</td>
</tr>
<td width="246">
<input type="hidden" name="MAX_FILE_ SIZE" value="88880000 00">
<input name="audiofile 4" type="file" id="audiofile4" >
</td>
</tr>
<td width="246">
<input type="hidden" name="MAX_FILE_ SIZE" value="88800000 0">
<input name="audiofile 5" type="file" id="audiofile5" >
</td>
</tr>
<td width="246">
<input type="hidden" name="MAX_FILE_ SIZE" value="88880000 00">
<input name="audiofile 6" type="file" id="audiofile6" >
</td>
</tr>
<tr>
<td width="80"><inp ut name="upload" type="submit" class="box" id="upload" value=" Upload "></td>
</tr>
</table>
</form>[/html]

I've managed to get the the size, name, and type for each the files uploaded to the database but the script only rights the data of the "userfile" value in the form in the database and rewrites to the audio1, audio2..etc..

Ronald thank your for help on my last post,"passing varibles to Php Script" and since then I've managed to find myself in another mess with the above!!!!

Uploading mutiple binary files in Mysql with Php

Uploading mutiple binary files in Mysql with Php

Comment

Comment