Upload image in mysql

[web3]

How to upload image in mysql?

[Atli]

Hey.

Check out this article.

[Phil++]

The way I'd do it, allow someone to upload to a directory "Images/" and then put the link into a PHP script.. For example:

$query = "INSERT INTO images (user, link) VALUES ('Phil++', 'http://www.yoursite.com/images/image-name.png')";

And then to display the image would be:

$query = "SELECT user, link FROM images WHERE user='Phil++'";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
    echo "<img src="' .$row['link']. '">';
}

That's how I'd do it.

[Atli]

The way I'd do it, allow someone to upload to a directory "Images/" and then put the link into a PHP script..

That is the standard (and recommended) method, but the way he asked the question made it seem like he wanted the images "in" the database.

But I wouldn't do that without a good reason. Doing it like you showed is by far easier, and usually less demanding on the server.