How to upload image in mysql?
Check out this article.
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.
I am not that much of an expert in PHP as it has been few months since I started playing with it. Currently I am working on creating a basic ...
I have a Table that displays titled and first name columns and delete link on the 3rd column.
Unfortunately for a reason i don't understand, records are not deleting when ...
Hello, I can't display images from database.
I have folder called "images" next to index.php where I keep images.
I suppose I have wrongly defined folder path with images or ...