Uploading Images

obrienkev

Hi all,

What do I have to set a database table field to for storing images?

e.g. to LONGTEXT, etc.

nemonoman

Don't store image data in a table. Just store the file info in a table.

You will see code where people store image data in a database. This code will use the datatype LONGBLOB.

There are 2 ways to get smart about this: Listen to smart developers who have a clue -- or try the LONGBLOB method, go nuts trying to make it work, and realize it was all a bad, avoidable mistake.

obrienkev

OK. I put the image info into database table. Do I then upload the image to the server folder? How do I link the image with the table info?

Thanks,

Kevin.

Slyvampy

There are two ways in which to store this sort of information in the database depending on what the images are used for.

Ie. database storing brand logo's.
I would have a brand ID and have the php scan a directory for your images, have the images (say for example .jpg) in a folder assigned to the brand ID. if no image is found display image 0 (being an image not found image etc.)

Other way is to store the image filename in the database in a field and reference the image to the location in the php file.

Hope this helps.

example of folder

public_html/images/1.jpg

create a folder called images and upload them into there.

obrienkev

How do I reference the image to the location in the php file?

thanks.

lazzerous

This topic has been covered countless times in these forums - you really need to searche for your answers before posting.

obrienkev

Did that and this works...

		// Connect to database
		include('db_connect.php'); 

	// set variable for link
$id    = $_GET['id2'];
	//$value = NOW();
	//echo '<br />'.$value.'<br /><br />';

	// perform query
$query   = "SELECT name, type, size FROM simple_tbl ".
					 	 "WHERE id = '$id'";
	$result  = mysql_query($query) or die(mysql_error());
list($name, $type, $size) = mysql_fetch_array($result);

	$num_results = mysql_num_rows($result);

	if ($num_results > 0)
	{
	 	 while($file = mysql_fetch_array($result)) 
		 {
		     // filepath
		     $uploaddir = 'admin/uploads/images/';
				 $uploadfile = $uploaddir . basename($file['name']);
				 echo 'Filename ('.$uploadfile.') '.$file['name'].'....<br />';
		 }

I have now run into a problem where these images need to be archived. Hence my need to store in database table.

Is there any way around this? I have a date field in the table that records when image uploaded.
The image will always have the same name so it overwrites the original in the server folder always.

Any ideas??

thanks.