Uploading picture for products

[mdesouza]

Hi all

I am writing a small shopping cart as part of my php project, I want to build it from scratch.

The problem is that i want to store pictures for the products in the product table.

Can someone please let me know who this is done. i cant seem to find any code on the net that does it

I want to be able to store the picture of the product in the database i guess in a blob field !!

Any Help would be appreciated .

Thks

Mike

[drew010]

yes you are right, store the data in a blob field. once the file has been uploaded, get the contents of it like so,
$image = file_get_contents($_FILES['fieldname']['tmp_name']);
when you insert it into the database, you will need to run addslashes() as you insert. also, note the file type, jpg, gif etc...
you will need to write a separate little script for displaying the images. you could call it image.php and make it take an argument like id.
image.php?id=59
when called it will pull the data from the database where the product id or whatever is 59, basically, all you will have to do is this:
<?php
//query db for image data
header("Content-type: image/jpg");
echo $sqldata['imagefield'];
?>
and in your script anywhere you can use <img src="image.php?id=32"> and the image should display.

sorry my explanation isn't too detailed. if you cant figure it out let me know.

[mdesouza]

Hi drew

I will try and attempt bits at a time, first how to i upload the picture in my products table

i suppose i cant use an sql insert statement , i need some other type of functionality, or can i

can u explain the insert bit !!

here is my product table
CREATE TABLE products (
product_id int(4) DEFAULT '0' NOT NULL auto_increment,
category_id int(4) DEFAULT '1' NOT NULL,
product_name varchar(50) DEFAULT '' NOT NULL,
product_description varchar(240),
product_image blob,
PRIMARY KEY (product_id)

sorry for the trouble

Mike

[vronsky]

And if you load the image on the server and store only the path in database?
Will not be lighter?

<?
$imgdir="C:\FoxServ\www\land\land_img\strut"; //Path to upload directory, WITHOUT trailing slash!!
$siteurl="http://localhost/land"; // Url to your website
$imgurl="http://localhost/land/land_img/strut/"; //Url To Image Directory (MUST POINT TO SAME PATH AS $imgdir!!!)
$directory="land_img/strut/";
// The following does not need to be edited, but it can be if you would like to
// The defualt file size limit is 500 Kb
$meas="1000"; // 1000 means Kb, 10000 means Mb, 1 means bytes
$label="Kb"; // Use the above variable to determine this variable, the default is 500 Kb
$maxsize="500"; // Max size
?>

<table>      

<form ACTION="<?echo $PHP_SELF ; ?>" METHOD="POST"ENCTYPE="multipart/form-data">
<tbody><tr VALIGN="TOP"><td WIDTH="308" valign="middle">
<input TYPE="FILE" NAME="superdat" SIZE="30">
</td></tr></TBODY></table>
<input TYPE="SUBMIT" NAME="submit" VALUE="Carica Immagine">
</form>
</td></tr></table>
<?
$totsiz=$superdat_size/$meas;
if ($superdat_name != "") {
copy("$superdat", "$imgdir/$superdat_name") or 
die("ERRORE!!");
?>
<p align="center"><font face="Verdana">Immagine caricata:</font></p>
<p align=center><font face="Verdana"><img SRC="<? echo "$imgurl"; ?><? echo "$superdat_name"; ?>"  ALT="Uploaded Image" border=0></font></a></p>
<p align=center><font face="Verdana">Nome dell'immagine : <? echo "$superdat_name"; ?></font></p><P>

[drew010]

Originally posted by mdesouza

can u explain the insert bit !!

here is my product table
CREATE TABLE products (
product_id int(4) DEFAULT '0' NOT NULL auto_increment,
category_id int(4) DEFAULT '1' NOT NULL,
product_name varchar(50) DEFAULT '' NOT NULL,
product_description varchar(240),
product_image blob,
PRIMARY KEY (product_id)

unless you are going to restrict the user's to only uploading one type of image, you will need to store what type of image they uploaded so you know how to output it to the browser.

for the example we will use a field called product_imagetype and it will hold values like 'gif', 'jpg'...

once you get the image file contents into a variable thru file_get_contents, you could store it like this:

$query = "INSERT INTO products ('', '5', 'computer', 'p4 3.2ghz', '".addslashes("$imagedata")."'";

and when you pull it out for the image script you can do this:

$pid = $_GET['id'];
$query = "SELECT product_image, product_imagetype FROM products WHERE product_id = '$pid'";
$result = mysql_query($query);
$data = mysql_fetch_array($result);
$image = stripslashes($data[0]);
$type = $data[1];

switch($type) {
case "jpg":
header("Content-Type: image/jpg");
break;
case "gif":
header("Content-Type: image/gif");
break;
case "png":
header("Content-Type: image/png");
break;
//..other types here that you allow
}

[mdesouza]

Thks guys for all your help !

managed to get it working

Mike