file upload into mysql ( 7 Views )

1. I'm attempting to use the sample code from chapter 11 of Kevin Yank's book -- Database Driven Website. Everything <i>appears</i> to work. However, whenever I check the size of the temporary file created by php, it's size is 0. Therefore, none of the file actually gets put into mysql. Here is the code:
   
   $uploadfile = $_FILES['uploadfile']['tmp_name'];
   $uploadname = $_FILES['uploadfile']['name'];
   $uploadtype = $_FILES['uploadfile']['type'];
   $uploaddesc = $_POST['desc'];
   
   // open file for binary reading ('rb')
   $tempfile = fopen($uploadfile, 'rb');
   
   // read the entire file into memory using PHP's
   // filesize function to get the file size
   $filedata = fread($tempfile, filesize($uploadfile));
   
   // prepare for database insert by adding backslashes
   // before special characters
   $filedata = addslashes($filedata);
   
   // create the SQL query
   $sql = "INSERT INTO textandimages SET
   file_name = '$uploadname',
   mime_type = '$uploadtype',
   description = '$uploaddesc',
   file_data = '$filedata'";
   
   // perform the insert
   $ok = @mysql_query($sql);
   
   Any help would be appreciated. Thank you.
   
   
   (kerem ozan, Japan)


2. uploading binary data in mysql
    
   Quote:

   Originally Posted by anied52 I'm attempting to use the sample code from chapter 11 of Kevin Yank's book -- Database Driven Website. Everything <i>appears</i> to work. However, whenever I check the size of the temporary file created by php, it's size is 0. Therefore, none of the file actually gets put into mysql. Here is the code: $uploadfile = $_FILES['uploadfile']['tmp_name']; $uploadname = $_FILES['uploadfile']['name']; $uploadtype = $_FILES['uploadfile']['type']; $uploaddesc = $_POST['desc']; // open file for binary reading ('rb') $tempfile = fopen($uploadfile, 'rb'); // read the entire file into memory using PHP's // filesize function to get the file size $filedata = fread($tempfile, filesize($uploadfile)); // prepare for database insert by adding backslashes // before special characters $filedata = addslashes($filedata); // create the SQL query $sql = "INSERT INTO textandimages SET file_name = '$uploadname', mime_type = '$uploadtype', description = '$uploaddesc', file_data = '$filedata'"; // perform the insert $ok = @mysql_query($sql); Any help would be appreciated. Thank you.

   Im not sure why you would want to upload binary data into your database, its slow and not a very efficient way to retrieve the data. You might want to email Kevin directly for some form of explanation.
   
   good luck,
   
   
   (Mehmet Can, Serbia and Montenegro)

Related Topics ... (or search in 1.720.883 topics !)