Uploading and displaying pictures with PHP and MySQL

Hello people,

I am trying to learn how to upload and display pictures using PHP and MySQL, as always I tried to learn by reading but now some issues have come across and I need to ask for guidance, it looks like I can upload the image as there is one row in the database with the image's name and other attributes, here is my code for uploading the image:

<?php
if(isset($_POST['upload']) && $_FILES['userfile']['size'] > 0)
{
$fileName = $_FILES['userfile']['name'];
$tmpName = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];

$fp = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);

if(!get_magic_quotes_gpc())
{
$fileName = addslashes($fileName);
}
include 'connect.php';

$query = "INSERT INTO upload (name, size, type, content ) ".
"VALUES ('$fileName', '$fileSize', '$fileType', '$content')";

mysql_query($query) or die('Error, query failed');
//include 'library/closedb.php';

echo "<br>File $fileName uploaded<br>";
}
?>

<html>
<head>
</head>
<body>
<form method="post" enctype="multipart/form-data">
<input type="hidden" name="MAX_FILE_SIZE" value="2000000">
<input name="userfile" type="file" id="userfile">
<input name="upload" type="submit" class="box" id="upload" value=" Upload ">
</form>
</body>
</html>

This kinda seems to work fine as (then again) the image appears on the database as seen from phpmyadmin.

This is my first question: Where was the image uploaded to? Because I can't seem to find it when I browse my server for that file name.

These are the codes for displaying the image (this is not working at all):

<html>
<head>
</head>
<body>
Picture:<br>
<img src=picscript.php?imname=moss.jpg />
</body>
</html>

picscript.php:

<?php
mysql_connect("localhost","user","pass");
mysql_select_db("people");
$image = stripslashes($_REQUEST[imname]);
$rs = mysql_query("select * from upload where filename=\"".
addslashes($image).".jpg\"");
$row = mysql_fetch_assoc($rs);
$imagebytes = $row[imgdata];
header("Content-type: image/jpeg");
print $imagebytes;
?>

Could anybody help me out a little please? Thanks

Uploading and displaying pictures with PHP and MySQL

Sub_Seven

Readie

Sub_Seven

rocknbil

Readie

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week