I am trying to create an UPLOAD page to Update a Images and PDFs into a BLOB field in mySQL. The image keeps getting corrupted (it draws a portion of the image and the rest is GRAY) We tried it with Safari and Firefox with bad results.

Here is the form that is used to browse and select the file.

<!-- Upload Image dialog -->
<div id="uploadImage">
<div id="llback"></div>
<center><div id="uploadForm">
<div id="uploadTitle">Upload Thumbnail image</div>
<iframe name="saveImage"></iframe>
<b>Please select the thumbnail image, then press Upload.</b>
<div style="margin-top:14px;margin-bottom:14px;text-align:center;width: 100%"> <form target="saveImage" method="post" action="ajax/saveDialog.php" enctype="multipart/form-data"> Select Thumbnail: <input type="file" name="img" id="img" accept="image/ jpeg" /></div>
<input type="hidden" name="obj" value="uploadImage" />
<input type="hidden" name="id" value="<?php echo $Area_id ?>" />
<input type="button" value="Upload" onclick="saveDialog('uploadImage','img','jpg');"> <input type="button" value="Cancel" onclick="cancelDialog('uploadImage','img')">

Here is the QUERY to upload the image (saveDialog.php):

if($_POST['obj'] == "uploadImage") {
$file = $db->real_escape_string(file_get_contents($_FILES['img'] ['tmp_name']));
$db->query("UPDATE Areas SET Image = '$file'") or die("1".$db->error);

Has anyone else ever run into this type of UPDATE error with images and PDF? We really need to get this dealt with ASAP.


Don Wieland
D W   D a t a   C o n c e p t s
Direct Line - (949) 305-2771

Integrated data solutions to fit your business needs.

Need assistance in dialing in your FileMaker solution? Check out our Developer Support Plan at:

Appointment 1.0v9 - Powerful Appointment Scheduling for FileMaker Pro 9 or higher

For a quick overview -

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to