Menu
I have written a script that accepts uploaded images from a user . I can echo back out all the text fields from the data base but cannot figure outn how to 1.display the binary data as a thumbnail
2. when you click on the thumbnail the full image will be shown
I would be happy to get as far as no. 1 at this stage as i have spent way too much time stuck on this
THIS THE CODE SO FAR
<?php
$dbcnx = @mysql_connect(‘localhost’, ‘root’, ‘password’);
if (!$dbcnx) {
exit(‘<p>Unable to connect to the ‘ .
‘database server at this time.</p>’);
}
if (!@mysql_select_db(‘diseart’)) {
exit(‘<p>Unable to locate the ecommerce ‘ .
‘database at this time.</p>’);
}
if (isset($_GET[‘action’])) {
$action = $
} else {
$action = ”;
}
if (($action == ‘view’ or $action == ‘dnld’) and isset($_GET[‘id’])) {
$id = $
// User is retrieving a file
$sql = “SELECT filename, mimetype, filedata
FROM filestore WHERE id = ‘$id'”;
$result = @mysql_query($sql);
if (!$result) {
exit(‘Database error: ‘ . mysql_error());
}
$file = mysql_fetch_array($result);
if (!$file) {
exit(‘File with given ID not found in database!’);
}
$filename = $file[‘filename’];
$mimetype = $file[‘mimetype’];
$filedata = $file[‘filedata’];
$disposition = ‘inline’;
if ($action == ‘dnld’) {
$disposition = ‘attachment’;
if (strpos($_SERVER[‘HTTP_USER_AGENT’], ‘MSIE 5’) or
strpos($
$mimetype = ‘application/x-download’;
}
}
header(“content-disposition: $disposition; filename=$filename”);
header(“content-type: $mimetype”);
header(‘content-length: ‘ . strlen($filedata));
echo($filedata);
exit();
} elseif ($action == ‘del’ and isset($_GET[‘id’])) {
$id = $
// User is deleting a file
$sql = “DELETE FROM filestore WHERE id = ‘$id'”;
$ok = @mysql_query($sql);
if (!$ok) {
exit(‘Database error: ‘ . mysql_error());
}
header(‘location: ‘ . $_SERVER[‘PHP_SELF’]);
exit();
} elseif (isset($_FILES[‘upload’])) {
// Bail out if the file isn’t really an upload.
if (!is_uploaded_file($_FILES[‘upload’][‘tmp_name’])) {
exit(‘There was no file uploaded!’);
}
$uploadfile = $
$uploadname = $_FILES[‘upload’][‘name’];
$uploadtype = $
$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);
// $thumbdata = create_thumb($filedata);
// Create the SQL query.
$sql = “INSERT INTO filestore SET
filename = ‘$uploadname’,
mimetype = ‘$uploadtype’,
description = ‘$uploaddesc’,
filedata = ‘$filedata'”;
// Perform the insert.
$ok = @mysql_query($sql);
if (!$ok) {
exit(‘Database error storing file: ‘ . mysql_error());
}
header(‘location: ‘ . $_SERVER[‘PHP_SELF’]);
exit();
}
// Default page view: lists stored files
$sql = ‘SELECT id, filename, mimetype, description FROM filestore’;
$filelist = @mysql_query($sql);
if (!$filelist) {
exit(‘Database error: ‘ . mysql_error());
}
?>
<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Strict//EN”
“
<html xmlns=”
<head>
<title>PHP/MySQL File Repository</title>
<meta http-equiv=”content-type”
content=”text/html; charset=iso-8859-1″ />
</head>
<body>
<h1>PHP/An Diseart</h1>
<form action=”<?php echo $_SERVER[‘PHP_SELF’]; ?>”
method=”post” enctype=”multipart/form-data”>
<p><label>Upload File:<br />
<input type=”file” name=”upload” /></label></p>
<p><label>File Description:<br />
<input type=”text” name=”desc” maxlength=”255″ /></label></p>
<p><input type=”submit” value=”Upload” /></p>
</form>
<p>The following files are stored in the database:</p>
<table>
<tr>
<th>Filename</th>
<th>Type</th>
<th>Description</th>
</tr>
<?php
if (mysql_num_rows($filelist) > 0) {
while ($f = mysql_fetch_array($filelist)) {
?>
<tr valign=”top”>
<td>
<a href=”<?php echo $_SERVER[‘PHP_SELF’]; ?>?action=view&id=<?php echo $f[‘id’]; ?>”>
<?php echo $f[‘filename’]; ?> </a>
// <?php
// $bytes = $f[‘filedata’];
// <img src=?gim=1 width=144>
// print “i am here!”.$bytes;
// ?> a
</td>
<td><?php echo $f[‘description’]; ?></td>
<td>
[<a href=”<?php echo $
>Download</a> |
<a href=”<?php echo $_SERVER[‘PHP_SELF’]; ?>?action=del&id=<?php echo $f[‘id’]; ?>”
onclick=”return confirm(‘Delete this file?’);”
>Delete</a>]
</td>
</tr>
<?php
}
} else {
?>
<tr><td colspan=”3″>No Files!</td></tr>
<?php
}
?>
</table>
</body>
</html>