help with picture upload

[laura_richer]

hi everyone,

Im pretty new to PHP coding and im having trouble writing the code to upload pictures to a mysql database.

the code i have so far is:

 

The upload form:

 

<p>Upload Image</p>

<form action="picupload.php" method="post" enctype="multipart/form-data">

<table>

<tr>

<td width="246">

<input type="hidden" name="MAX_FILE_SIZE" value="2000000">

<input name="picfile" type="file" id="picfile">

</td>

<td>

<input type="submit" name="submit" value="Submit" />

</td>

</tr>

</table>

</form>

 

Then the processing on the next page:

 

<?php

if(isset($_POST['upload']) && $_FILES['picfile']['size'] > 0)

{

$name = $_FILES['picfile']['name'];

$temp  = $_FILES['picfile']['tmp_name'];

$size = $_FILES['picfile']['size'];

$type = $_FILES['picfile']['type'];

 

echo $name;

echo $temp;

echo $size;

echo $type;

 

$fp      = fopen($temp, 'r');

$content = fread($fp, filesize($temp));

$content = addslashes($content);

fclose($fp);

}

 

 

$host="localhost";

$user="myusername";

$pass="mypassword";

mysql_connect($host,$user,$pass);

mysql_select_db($user);

 

$query= "insert into photo values (NOT NULL, '".$name."','".$type."','".$size."','".$content."')";

$result=mysql_query($query);

 

if(mysql_affected_rows()==1){

 

echo '<p>File '.$name.' uploaded</p>';

}else{

echo '<p>Error uplaoding</p>';

}

 

?>

 

It says the file has uploaded but in the mysql database the file size is 0 and the 'name' and 'type' column are empty and the content columm says BLOB-0B

 

thanks for the help in advance.

laura

[nafetski]

Here is the thing.

 

(People will disagree with me on this)

 

It's not a good idea to store your pictures in a MySQL database.  It's a good idea to store the file on the filesystem, and store the path and properties (width, height, size, etc) in your database...but I would almost NEVER recommend storing your image as binary data in the DB.

 

Come up with a directory structure that can handle a multitude of images, and a naming convention that won't cause collisions  (maybe username_time.jpg)