Geek asks and answers

PHP form does not send images to MySQL table

I have a PHP form that has five inputs so that the user can upload five images. The user must at least select one image, and it must be in the first input for the form to be submitted. The form will correctly send all the information to the MySQL table, with the exception of the images themselves. For example, I sent an image, and the image column shows [BLOB - 14 B] when I consider that it should be at least 300 KB. My theory is that images are compressed in some other format when they are sent to a MySQL table.

Here is my full PHP page:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

  <html>
  <head><title>File Upload To Database</title></head>
  <body>
  <h2>Please Choose a File and click Submit</h2>
  <form enctype="multipart/form-data" action="<?php echo htmlentities($_SERVER['PHP_SELF']);?>" method="post">
  <input type="hidden" name="MAX_FILE_SIZE" value="99999999" />
  <div><input name="userfile[]" type="file" /></div>
    <div><input name="userfile[]" type="file" /></div>
      <div><input name="userfile[]" type="file" /></div>
        <div><input name="userfile[]" type="file" /></div>
          <div><input name="userfile[]" type="file" /></div>
  <div><input type="submit" value="Submit" /></div>
  </form>

</body></html>

<?php
/*** check if a file was submitted ***/
if(!isset($_FILES['userfile']))
    {
    echo '<p>Please upload a display picture.</p>';
    }
else
    {
    try    {
        upload();
        /*** give praise and thanks to the php gods ***/
        echo '<p>Thank you for submitting</p>';
        }
    catch(Exception $e)
        {
        echo '<h4>'.$e->getMessage().'</h4>';
        }
    }

/*
 * Check the file is of an allowed type
 * Check if the uploaded file is no bigger thant the maximum allowed size
 * connect to the database
 * Insert the data
 */

/**
 *
 * the upload function
 * 
 * @access public
 *
 * @return void
 *
 */
function upload(){

$maxsize = 99999999;
$columnNames = '';
$columnValues = '';
$paramsToBeBound = array();

echo '<pre>' . print_r($_FILES, TRUE) . '</pre>';

/*** check if a file was uploaded ***/
for($i = 0; ($i < count($_FILES['userfile']['tmp_name']) && $i < 5); $i++) {
    if($_FILES['userfile']['tmp_name'][$i] != '') { // check if file has been set to upload
        if($_FILES['userfile']['error'][$i] == 0 && is_uploaded_file($_FILES['userfile']['tmp_name'][$i]) && getimagesize($_FILES['userfile']['tmp_name'][$i]) != false) {
            /***  get the image info. ***/
            $size = getimagesize($_FILES['userfile']['tmp_name'][$i]);
            /*** assign our variables ***/
            $type = $size['mime'];
            $imgfp = fopen($_FILES['userfile']['tmp_name'][$i], 'rb');
            $size = $size[3];
            $name = $_FILES['userfile']['name'][$i];


             /***  check the file is less than the maximum file size ***/
            if($_FILES['userfile']['size'][$i] < $maxsize)
                {
                    if($i > 0) {
                        $columnNames .= ', image_type' . $i . ', image' . $i . ', image_size' . $i . ', image_name' .$i;
                        $columnValues .= ', ?, ?, ?, ?';
                    } else {
                        $columnNames .= 'image_type, image, image_size, image_name';
                        $columnValues .= '?, ?, ?, ?';
                    }

                    $paramsToBeBound[] = $type;
                    $paramsToBeBound[] = $imgfp;
                    $paramsToBeBound[] = $size;
                    $paramsToBeBound[] = $name;
                } else
                    throw new Exception("File Size Error"); //throw an exception is image is not of type
            }
        else
            {
            // if the file is not less than the maximum allowed, print an error
            throw new Exception("Unsupported Image Format of image!");
            }
        }
    }
    if(count($paramsToBeBound) > 0) {
        $dbh = new PDO("mysql:host=dsa.com;dbname=s_gbm", 'kss', 'Kisr'); 

        $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

        $stmt = $dbh->prepare('INSERT INTO testblob (' . $columnNames . ') VALUES (' . $columnValues . ')');

        $i = 0;
        foreach($paramsToBeBound as &$param) {
            $i++;
            if($i == 2 || $i - floor($i / 4) == 2) {
                $stmt->bindParam($i, $param, PDO::PARAM_LOB);
            } else {
                $stmt->bindParam($i, $param);
            }
        }

        $stmt->execute();
    }
}


?>

Here is the code I used in PHP MyAdmin SQL to create the MySQL table:

CREATE TABLE testblob ( image_id tinyint(3) NOT NULL AUTO_INCREMENT, image_type varchar(25) NOT NULL, image longblob NOT NULL, image_size varchar(25) NOT NULL, image_name varchar(50) NOT NULL, image_type1 varchar(25) NOT NULL, image1 longblob NOT NULL, image_size1 varchar(25) NOT NULL, image_name1 varchar(50) NOT NULL, image_type2 varchar(25) NOT NULL, image2 longblob NOT NULL, image_size2 varchar(25) NOT NULL, image_name2 varchar(50) NOT NULL, image_type3 varchar(25) NOT NULL, image3 longblob NOT NULL, image_size3 varchar(25) NOT NULL, image_name3 varchar(50) NOT NULL, image_type4 varchar(25) NOT NULL, image4 longblob NOT NULL, image_size4 varchar(25) NOT NULL, image_name4 varchar(50) NOT NULL, image_ctgy varchar(25) NOT NULL, KEY image_id (image_id) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Thanks for any help. I appreciate all the help.

+3
2

-, MySQL, .

? ? . , ...

$imgfp = fopen($_FILES['userfile']['tmp_name'][$i], 'rb');
$imageData = fread($imgfp, filesize($_FILES['userfile']['tmp_name'][$i]));
$imageData = addslashes($imageData);
fclose($imgfp);
…
…
$paramsToBeBound[] = $imageData;
+3

- MySQL, , , , , MySQL, , . , (=

+2

More articles:


All Articles