hi,
i wrote a code to upload a resume in mysql database and download that one .
But in my database name,type,size of the file stored but content of the file not stored. So in my database content filed is empty.plz tell that what's the problem in my code.
[PHP]
<?
include("db.php ");
if(isset($_POST['upload']) && $_FILES['userfile']['size'] > 0)
{
$fileName = $_FILES['userfile']['name'];
$tmpName = $_FILES['userfile']['tmpname'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];
$fp = fopen($tmpName, 'rb');
$content = fread($fp, filesize($tmpNa me));
$content = addslashes($con tent);
fclose($fp);
if(!get_magic_q uotes_gpc())
{
$fileName = addslashes($fil eName);
}
$query = "INSERT INTO upload (name, size, type, content ) ".
"VALUES ('$fileName', '$fileSize', '$fileType', '$content')";
mysql_query($qu ery) or die('Error, query failed');
echo "<br>File $fileName uploaded<br>";
}
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 2</title>
</head>
<body>
<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="2000000" >
<input name="userfile" type="file" id="userfile">
</td>
<td width="80"><inp ut name="upload" type="submit" class="box" id="upload" value=" Upload "></td>
</tr>
</table>
</form>
</body>
</html>
[/PHP]
And i got the errors as
Warning: fread(): supplied argument is not a valid stream resource in e:\project\grap hic\docu.php on line 11
Warning: fclose(): supplied argument is not a valid stream resource in e:\project\grap hic\docu.php on line 13
i wrote a code to upload a resume in mysql database and download that one .
But in my database name,type,size of the file stored but content of the file not stored. So in my database content filed is empty.plz tell that what's the problem in my code.
[PHP]
<?
include("db.php ");
if(isset($_POST['upload']) && $_FILES['userfile']['size'] > 0)
{
$fileName = $_FILES['userfile']['name'];
$tmpName = $_FILES['userfile']['tmpname'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];
$fp = fopen($tmpName, 'rb');
$content = fread($fp, filesize($tmpNa me));
$content = addslashes($con tent);
fclose($fp);
if(!get_magic_q uotes_gpc())
{
$fileName = addslashes($fil eName);
}
$query = "INSERT INTO upload (name, size, type, content ) ".
"VALUES ('$fileName', '$fileSize', '$fileType', '$content')";
mysql_query($qu ery) or die('Error, query failed');
echo "<br>File $fileName uploaded<br>";
}
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 2</title>
</head>
<body>
<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="2000000" >
<input name="userfile" type="file" id="userfile">
</td>
<td width="80"><inp ut name="upload" type="submit" class="box" id="upload" value=" Upload "></td>
</tr>
</table>
</form>
</body>
</html>
[/PHP]
And i got the errors as
Warning: fread(): supplied argument is not a valid stream resource in e:\project\grap hic\docu.php on line 11
Warning: fclose(): supplied argument is not a valid stream resource in e:\project\grap hic\docu.php on line 13
Comment