TalkPHP - View Single Post - Warning: fread(): supplied argument is not a valid stream resource

sarmenhb · 04-21-2008, 05:23 AM

what did i do wrong here?

Code:

<?php
require("config.php");
if(isset($_POST['btnupload']) && $_FILE['filetag']['size'] > 0) {


#--------------------------------------------
# 	VARIABLES
#--------------------------------------------

$filename = $_FILE['filetag']['name'];
$filetype = $_FILE['filetag']['type'];
$filesize = $_FILE['filetag']['size'];
$tmp_filename = $_FILE['filetag']['tmp_name'];


#--------------------------------------------
#  Upload file to database
#--------------------------------------------

$fp = fopen($tmp_filename, 'r');
$file_content = fread($fp, filesize($tmp_filename));
$file_content = addslashes($file_content);
$filename = addslashes($filename);
fclose($fp);
#--------------------------------------------
#	Query to upload
#--------------------------------------------

$sql = "INSERT INTO tbl_upload VALUES(null,'$filename','$filesize','$filetype','$file_content')";
mysql_query("$sql");

echo "file uploaded";

}

?>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
</head>

<body>

<form method="post" enctype="multipart/form-data">

<input type="hidden" name="maxfilesize" value="2000000" />
<input type="file" name="filetag" />
<input type="submit" name="btnupload" value="upload" />






</form>


</body>
</html>

here is the table description

Code:

CREATE TABLE `tbl_upload` (
  `id`       int AUTO_INCREMENT NOT NULL,
  `name`     varchar(30) NOT NULL,
  `type`     varchar(30) NOT NULL,
  `size`     int NOT NULL,
  `content`  mediumblob NOT NULL,
  /* Keys */
  PRIMARY KEY (`id`)
) ENGINE = InnoDB;

here is php.ini

Code:

;;;;;;;;;;;;;;;;
; File Uploads ;
;;;;;;;;;;;;;;;;

; Whether to allow HTTP file uploads.
file_uploads = On

; Temporary directory for HTTP uploaded files (will use system default if not
; specified).
upload_tmp_dir = "c:/wamp/tmp"

; Maximum allowed size for uploaded files.
upload_max_filesize = 20M