Form Fill Script PHP

Adding / editing / deleting products

Managing products is even easier than managing categories, because it does not require making products hierarchical tree structure.

All products are plainly saved into separate PRODUCT table.

At-first, we have to develop a form for managing product details.

This form should allow managing product name, descriptions, images, etc.

This is how the form looks in Shop-Script FREE and its HTML code (products.php):

<form enctype="multipart/form-data" action="products.php" method="POST">

<table width="100%" border="0" cellpadding="3" cellspacing="0">

<tr>

<td align="right">Parent:</td>

<td>

<select name="categoryID">

<option value="0">Root</option>

<option value="4">Sample category 1</option>

<option value="20">  Child category 1</option>

<option value="76">  Child category 2</option>

< all categories are shown in this select box >

</select>

</td>

</tr>

<tr>

<td align="right">Product name</td>

<td><input type="text" name="name" value=""></td>

</tr>

<tr>

<td align="right">Product code</td>

<td><input type="text" name="product_code" value=""></td>

</tr>

<tr>

<td align="right">Price, USD<br>(number only):</td>

<td><input type="text" name="price" value=0></td>

</tr>

<tr>

<td align="right">List price, USD<br>(number only):</td>

<td><input type="text" name="list_price" value=0></td>

</tr>

<tr>

<td align="right">In stock:</td>

<td><input type="checkbox" name="in_stock" checked></td>

</tr>

<tr>

<td align="right">Picture</td>

<td><input type="file" name="picture"></td>

<tr><td></td><td>

(picture not uploaded)</td>

</tr>

<tr>

<td align="right">Thumbnail</td>

<td><input type="file" name="thumbnail"></td>

<tr><td></td><td>

(picture not uploaded)</td>

</tr>

<tr>

<td align="right">Enlarged picture</td>

<td valign="top"><input type="file" name="big_picture"></td>

<tr><td></td><td valign="top">

(picture not uploaded)</td>

</tr>

<tr>

<td align="right">Description<br>(HTML):</td>

<td><textarea name="description" rows="15" cols="40"></textarea></td>

</tr>

<tr>

<td align="right">Brief description<br>(HTML):</td>

<td><textarea name="brief_description" rows="7" cols="40"></textarea></td>

</tr>

</table>

<p><center>

<input type="submit" value="Save">

<input type="hidden" name="save_product" value="0">

<input type="button" value="Cancel" onClick="window.close();">

</center></p>

</form>

Adding product

Administrator is prompted to fill in the form presented above.

Clicking "Save" button will execute following SQL query to save product into the database (products.php):

INSERT INTO `PRODUCT` (categoryID, name, description, customers_rating, Price, in_stock, customer_votes, items_sold, enabled, brief_description, list_price, product_code) VALUES ('".$_POST["categoryID"]."','".$_POST["name"]."','".$_POST["description"]."', 0, '".$_POST["price"]."', ".$instock.", 0, 0, 1, '".$_POST["brief_description"]."', '".$_POST["list_price"]."', '".$_POST["product_code"]."');

Editing product details

Here administrator is prompted to fill in the same form as when adding a product.

The only difference is that in this case we pass productID along with the form to indicate that clicking "Save" button should update existing product details, but not add a new one (products.php):

<?php 

    if (!isset($_POST["price"]) || !$_POST["price"] || $_POST["price"] < 0) 

        $_POST["price"] = 0; //price can not be negative 

    if (!isset($_POST["name"]) || trim($_POST["name"])=="") $_POST["name"] = "not defined"; 

    $instock = (isset($_POST["in_stock"])) ? 1 : 0; 

    if ($_POST["save_product"]) { //if $_POST["save_product"] != 0 then update item 

        //delete old product photos if they're being replaced 

        $q = db_query("SELECT picture, big_picture, thumbnail FROM ".PRODUCTS_TABLE." WHERE productID='".$_POST["save_product"]."'") or die (db_error()); 

        $row = db_fetch_row($q); 

        //generating query 

        $s = "UPDATE ".PRODUCTS_TABLE." SET categoryID='".$_POST["categoryID"]."', name='".$_POST["name"]."', Price='".$_POST["price"]."', description='".$_POST["description"]."', in_stock=".$instock.", customers_rating='".$_POST["rating"]."', brief_description='".$_POST["brief_description"]."', list_price='".$_POST["list_price"]."', product_code='".$_POST["product_code"]."'";

        $s1 = ""; 

        //old pictures? 

        if (isset($_FILES["picture"]) && $_FILES["picture"]["name"]) 

        { 

            //delete old picture 

            if ($row[0] && file_exists("./products_pictures/".$row[0])) 

                unlink("./products_pictures/".$row[0]); 

        } 

        if (isset($_FILES["big_picture"]) && $_FILES["big_picture"]["name"]) 

        { 

            //delete old picture 

            if ($row[1] && file_exists("./products_pictures/".$row[1])) 

                unlink("./products_pictures/".$row[1]); 

        } 

        if (isset($_FILES["thumbnail"]) && $_FILES["thumbnail"]["name"]) 

        { 

            //delete old picture 

            if ($row[2] && file_exists("./products_pictures/".$row[2])) 

                unlink("./products_pictures/".$row[2]); 

        } 

    } 

?>

Deleting product

When clicking "Delete" button for a certain product it is simply deleted from the database using following SQL query:

DELETE FROM `PRODUCT` WHERE productID=`$productID_to_delete`;