How to upload image in mysql?

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.

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.