uploading picture to mysql database

[Anon]

I am currently trying upload a picture along with a title and some text for a companies staff to a mysql database.

for example John Doe, President

[picture] John Doe started at this company ...

so I have created my database:

CREATE TABLE team (
id INT(9)DEFAULT '0' NOT NULL AUTO_INCREMENT,
title varchar(255),
picture longblob,
description blob,
PRIMARY KEY(id),
UNIQUE KEY(id)

);

I have two pages for practical purposes I'll call them team1.php3 and team2.php3:

[team1.php3] - only pertinant code

<FORM ENCTYPE="multipart/form-data" ACTION="team2.php3" METHOD=POST>
<INPUT TYPE="text" name="title">
<INPUT TYPE="text" name="decription">
<INPUT TYPE="hidden" name="MAX_FILE_SIZE" value="1000">
Send this file:<INPUT NAME="picture" TYPE="file">
<INPUT TYPE="submit" VALUE="Send File">

</FORM>

[team2.php3] - only pertinant code

<?
$$title = $title;
$$picture = $picture;
$$description = $description;

$db = mysql_connect ("localhost", "user", "pass");
mysql_db_query("db_name", $db);

$sql="INSERT INTO team
(id,title,picture, description)
VALUES ('$id','$title','$picture','$description')";

$result= mysql_query($sql);

?>

---

So obviously it doesn't work or wouldn't of posted this topic. Please help, i don't how to show the picture either can I use an array just like I would with text.

Please help!!!!!!!!!

Thanks! 🙂

Adam

[Anon]

I don't think it's possible to physically put the picture in to the database, unless you break it down in to hex and all of that mess, which can get pretty ugly. What I would suggets, is using the file functions, and having every file that gets uploaded saved in to a "userUpload" directory, or maybe a "picture" directory, w/ the name of the file saved the same as the title. Then, inserting the path in to the database, and when you wish to call it just using a
<img src="<?php echo ($row["path_to_pic"]);?>">

Ya know? Except of course, before that path to pic you'd have to query the database and all of that mess, but I hope you get the idea.

[Anon]

storing an image in a DB is no problem

check this out, it'll give you a really good grounding

http://phpbuilder.com/columns/florian19991014.php3

the bit you need to get your head around is then showing the image back on the page

img src="some_php_script.php?id=n takes a bit of getting used to, but when you figure it out in your head it makes perfect sense the main thing is remebering to set the right headers, else you get a broken image

hth

Bealers