Hi,
i wonder where i went wrong here:
if($_POST['getfile3'] != ""){
//insert attachment
$fileName = $_FILES['userfile3']['name'];
$tmpName = $_FILES['userfile3']['tmp_name'];
$fileSize = $_FILES['userfile3']['size'];
$fileType = $_FILES['userfile3']['type'];
//echo"<br> go here<br />";
$fp = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);
if(!get_magic_quotes_gpc())
{
$fileName = addslashes($fileName);
}
$fetch2 = ("INSERT INTO attachment2 (
tech_id,
FileName,
FileMime,
Filesize,
FileData,
Created)
VALUES (
'$tech_id',
'$fileName',
'$fileType',
'$fileSize',
'$content',
NOW())
")
or die(mysql_error());
mysql_query($fetch2) or die(mysql_error());
mysql_close();
}
if($_POST['getfile4'] != ""){
//insert attachment
$fileName = $_FILES['userfile4']['name'];
$tmpName = $_FILES['userfile4']['tmp_name'];
$fileSize = $_FILES['userfile4']['size'];
$fileType = $_FILES['userfile4']['type'];
$fp = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);
if(!get_magic_quotes_gpc())
{
$fileName = addslashes($fileName);
}
$fetch2 = ("INSERT INTO attachment2 (
tech_id,
FileName,
FileMime,
Filesize,
FileData,
Created)
VALUES (
'$tech_id',
'$fileName',
'$fileType',
'$fileSize',
'$content',
NOW())
")
or die(mysql_error());
mysql_query($fetch2) or die(mysql_error());
mysql_close();
}
if($_POST['getfile5'] != ""){
//insert attachment
$fileName = $_FILES['userfile5']['name'];
$tmpName = $_FILES['userfile5']['tmp_name'];
$fileSize = $_FILES['userfile5']['size'];
$fileType = $_FILES['userfile5']['type'];
$fp = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);
if(!get_magic_quotes_gpc())
{
$fileName = addslashes($fileName);
}
$fetch3 = ("INSERT INTO attachment2 (
tech_id,
FileName,
FileMime,
Filesize,
FileData,
Created)
VALUES (
'$tech_id',
'$fileName',
'$fileType',
'$fileSize',
'$content',
NOW())
")
or die(mysql_error());
mysql_query($fetch3) or die(mysql_error());
mysql_close();
}
if($_POST['getfile6'] != ""){
//insert attachment
$fileName = $_FILES['userfile6']['name'];
$tmpName = $_FILES['userfile6']['tmp_name'];
$fileSize = $_FILES['userfile6']['size'];
$fileType = $_FILES['userfile6']['type'];
$fp = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);
if(!get_magic_quotes_gpc())
{
$fileName = addslashes($fileName);
}
$fetch4 = ("INSERT INTO attachment2 (
tech_id,
FileName,
FileMime,
Filesize,
FileData,
Created)
VALUES (
'$tech_id',
'$fileName',
'$fileType',
'$fileSize',
'$content',
NOW())
")
or die(mysql_error());
mysql_query($fetch4) or die(mysql_error());
mysql_close();
}
as you can see all were just the same codings in different fields in a form. i was trying to upload multiple attachments here but php giving me errors or warnings:
Warning: fread(): supplied argument is not a valid stream resource in
C:\xampp\htdocs\teamsite\support\tech_submit.php on line
69
Warning: fclose(): supplied argument is not a valid stream resource in
C:\xampp\htdocs\teamsite\support\tech_submit.php on line
71
Warning: mysql_query() [
function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in
C:\xampp\htdocs\teamsite\support\tech_submit.php on line
164
Warning: mysql_query() [
function.mysql-query]: A link to the server could not be established in
C:\xampp\htdocs\teamsite\support\tech_submit.php on line
164
Access denied for user 'ODBC'@'localhost' (using password: NO)
the first attachment had been uploaded but the others were not.
Please help.
Thanks in advance! I appreciate it.
-R