Hello,
First I would like to say thank you all for your help in the past. I am stumped again.
I am creating an e-commerce system and I want to be able to upload images to the server and assign them to products. For the product ID, I have an auto increment value for the primary key to avoid duplicate item numbers. Since I do not want to pass all of my record values to my image upload program (when I write it), I assume to just submit the product to the database first and then bring the user to an image upload screen. Now these images are going to be associated with the product ID, but when I submit the new product, I don't know what that product ID is going to be. Is there a way to obtain this value for the new database record and then pass it to an image upload program.
Also, what would be the best way to write an image upload program, I want the maximum to be 5 images per product. Attached is the code I have written so far before product submission. I hope someone can shed some light on this for me.
-
$catid = $_GET[catid];
-
$itemno = $_GET[itemno];
-
-
echo "<form action='submititem.php' method='post' enctype='multipart/formdata'>
-
<table align='center' border='1'>";
-
if($itemno > 0)
-
{
-
//Get product information
-
echo "<tr><td align='center' colspan='3' bgcolor='#C0C0C0'><b>Edit Item</b></td></tr>";
-
$buildsql = "SELECT * FROM products WHERE itemno=" . $itemno;
-
$result = mysql_query($buildsql);
-
$rowset = mysql_fetch_array($result);
-
//Get all variables from the record
-
$itemno = $rowset['itemno'];
-
$title = $rowset['title'];
-
if($catid == '')
-
{
-
$catid = $rowset['catid'];
-
}
-
$list = $rowset['list'];
-
$price = $rowset['price'];
-
$taxable = $rowset['taxable'];
-
$shipping = $rowset['shipping'];
-
$intshipping = $rowset['intshipping'];
-
$calculator = $rowset['calculator'];
-
$description = $rowset['description'];
-
echo "<tr><td><b>Item Number: </b>" . $itemno . "</td>";
-
}
-
else
-
{
-
echo "<tr><td align='center' colspan='3' bgcolor='#C0C0C0'><b>New Item</b></td></tr>
-
<tr><td align='center' bgcolor='#FF0000'><b>New Item</b></td>";
-
}
-
//Get item selected catagory
-
$catsql = "SELECT * FROM catagories WHERE catid=" . $catid;
-
$catres = mysql_query($catsql);
-
$catrow = mysql_fetch_array($catres);
-
$parent = $catrow['parent'];
-
$catdesc = $catrow['description'];
-
while($parent <> 0)
-
{
-
$catsql = "SELECT * FROM catagories WHERE catid=" . $parent;
-
$catres = mysql_query($catsql);
-
$catrow = mysql_fetch_array($catres);
-
$parent = $catrow['parent'];
-
$catdesc = $catrow['description'] . " / " . $catdesc;
-
}
-
echo "<td colspan='2'><b>Catagory: " . $catdesc . "</b><input type='hidden' value=" . $catid . " name='catid' />";
-
if($itemno > 0)
-
{
-
echo "<a href=catagory.php?itemno=" . $itemno . ">[edit]</a>";
-
}
-
echo "</td></tr>";
-
echo "<tr><td colspan='3' align='center'><b>Title:</b><input type='text' size='50' value='" . $title . "' name='title' />";
-
echo "</td></tr><tr><td><b>List Price:</b> $<input type='text' size='5' name='list' value='" . $list . "' /></td>";
-
echo "<td colspan='2'><b>Our Price:</b> $<input type='text' size='5' name='price' value='" . $price . "' />";
-
echo " <input type='checkbox' name='taxable' checked>Taxable?</td></tr>";
-
echo "<tr><td><b>Shipping:</b> $<input type='text' name='shipping' size='5' value='" . $shipping . "' /></td>";
-
echo "<td><b>International Shipping:</b> $<input type='text' name='intshipping' size='5' value='" . $intshipping . "' /></td>";
-
echo "<td><input type='checkbox' name='shipcalc'>Use Calculator</td></tr>";
-
echo "<tr><td colspan='3'><b>Description:</b><br><center><textarea rows='10' cols='65' name='description'>" .
-
$description . "</textarea></center>";
-
//Item submission routine
-
If($itemno <> 0)
-
{
-
echo "<a href='imgupload.php?itemno=" . $itemno . "' target='upload'>Upload Product Images</a>";
-
}
-
echo "<p align='right'><input type='submit' value='Submit' /></p></td></tr></table></form>";
-
