Code for populate_suppliers.php
<? include('mysql_connect.php') ?>
<?php
if($_POST['submit_supply']){
//do stuff
}
?>
<form action="<?=$_SERVER['PHP_SELF']?>" method="post">
# of Suppliers<input type="text" name="no_of_suppliers">
<input type="submit" name="submit" value="Submit">
</form>
<?php
if($_POST['submit'])
{
echo "<form action=\"".$_SERVER['PHP_SELF']."\" method=post><table><tr>";
for($i=0; $i<$_POST['no_of_suppliers'];$i++)
{
$var="supplier".$i;
echo "<td><select name=\"".$var."\">"; //form name will be supplier1 supplier2 etc..
$sql="SELECT * FROM suppliers";
$result=mysql_query($sql);
while($row=mysql_fetch_assoc($result))
{
echo "<option value=\"".$row['supplierName']."\" >".$row['supplierName']."</option>";
}
echo "</select></td>";
}
echo "</tr></table><input type=submit name=submit_supply value=Submit></form>";
}
?>
Code for add.php
<div id="breadCrumbBlock"><a name="top" id="top"></a>Home >> products >> Add </div>
<div class="contentBlock">
Here you can add the details of your products.
</div>
<?php
if(isset($_POST['Submit'])){//START IS SUBMITTED
//Form POST variables
$productSubcategory = clean($_POST['productSubcategory']);
$productName = clean($_POST['productName']);
$productNumber = clean($_POST['productNumber']);
$vendorCode = clean($_POST['vendorCode']);
$vendorName = clean($_POST['vendorName']);
$productPrice = clean($_POST['productPrice']);
$productOverview = clean($_POST['productOverview']);
$productManLink = clean($_POST['productManLink']);
$productBroLink = clean($_POST['productBroLink']);
$productSupplier = clean($_POST['productSupplier']);
$productSupplier1 = clean($_POST['productSupplier1']);
$productSupplier2 = clean($_POST['productSupplier2']);
$productSupplier3 = clean($_POST['productSupplier3']);
$ex_subcategory = $productSubcategory;
//Form FILES variables
$filename = $_FILES['productImage']['name'];
$filetype = $_FILES['productImage']['type'];
$filesize = $_FILES['productImage']['size'];
$error_code = $_FILES['productImage']['error'];
//Check if file submitted, if no file then substitute no_image.jpg file
if($error_code == "4"){//START CHECK IF FILE UPLOADED
$productImage = $no_image;
} else {//ELSE CHECK IF FILE UPLOADED
$random = rand(0, 1000);
$productImage = $random."_".$vendorCode.".jpg";
}//END CHECK IF FILE UPLOADED
//Check input
include('../includes/checkinput.php');
$check[] = checkInput('required','alphaNumeric',$productSubcategory,'Subcategory');
$check[] = checkInput('','price',$productPrice,'product price');
$check[] = checkInput('','file',$filetype,'image');
//Get number of values in the returned $check array
$checkArray = array_count_values($check);
//If returned $check array is not empty list errors
if(!empty($checkArray)) {//START ERRORS EXIST
?>
<div class="contentBlock">
<strong>The following errors occurred -</strong>
<ul id="errorList">
<?php
//If present print each error message in the $check array
foreach($check as $result) {//START LIST ERRORS
if(!empty($result)) {//START DISPLAY RESULT
echo "<li>".$result."</li>";
}//END DISPLAY RESULT
}//END LIST ERRORS
?>
</ul>
<p>Please try again.</p>
</div>
<?php
$fill = TRUE;
include('add_form.php');
?>
<?php
} else {//ELSE ERRORS EXIST
//Check if item number already exists
$query=mysql_query("SELECT * FROM products WHERE productNumber='$productNumber' LIMIT 1") or die (mysql_error());
if(mysql_num_rows($query) > 0) {//START CHECK ITEM NAME EXISTS
?>
<div class="contentBlock">
<p>The product number "<?php echo $productNumber; ?>" <a href="products.php?product=<?php echo $productNumber; ?>" target="_self">already exists</a>, please choose a unique number.</p>
</div>
<?php
$fill = TRUE;
include('add_form.php');
?>
<?php
} else {//ELSE CHECK ITEM NAME EXISTS
if(!move_uploaded_file($_FILES['productImage']['tmp_name'],$product_image_dir . $productImage) && $error_code != '4'){//START CHECK IMAGE UPLOAD
?>
<div class="contentBlock">
<p>Your image did not upload correctly, please try again <?php echo $error_code;?></p>
</div>
<?php
} else {//ELSE CHECK IMAGE UPLOAD
//Get category from subcategory
$query=mysql_query("SELECT category FROM subcategories WHERE subcategoryId='$productSubcategory' LIMIT 1") or die (mysql_error());
$data=mysql_fetch_assoc($query);
$productCategory = $data['category'];
//$query=mysql_query ("SELECT VendorName FROM vendors WHERE VendorID = VendorID") or die (mysql_error());
$query=mysql_query("INSERT INTO products SET productNumber='$productNumber', productCategory='$productCategory', productSubcategory='$productSubcategory', productName='$productName', productOverview='$productOverview', vendorCode='$vendorCode', vendorName='$vendorName', productManLink='$productManLink', productBroLink='$productBroLink', productPrice='$productPrice', productImage='$productImage',modified = NOW()") or die (mysql_error());
if(!$query) {//START CHECK ADD TO SUBCATEGORY QUERY
?>
<div class="contentBlock">
<p>There was an error adding the product into the database, please try again.</p>
</div>
<?php
$fill = TRUE;
include('add_form.php');
?>
<?php
} else {//ELSE CHECK ADD TO SUBCATEGORY QUERY
?>
<div class="contentBlock">
<p>The product was added successfully. You can add another product below.</p>
</div>
<?php
$query=mysql_query("SELECT * FROM products WHERE productNumber='$productNumber' LIMIT 1") or die (mysql_error());
while($data=mysql_fetch_assoc($query)){//START DISPLAY DATA
$productId =$data['productId'];
$productCategory =$data['productCategory'];
$productSubcategory =$data['productSubcategory'];
$productName =$data['productName'];
$productNumber =$data['productNumber'];
$vendorCode =$data['vendorCode'];
$vendorName =$data['vendorName'];
$productSpecs =$data['productSpecs'];
$productOverview =$data['productOverview'];
$productManLink = $data['productManLink'];
$productBroLink = $data['productBroLink'];
$productPrice =$data['productPrice'];
$productImage =$data['productImage'];
?>
<?php
include('product_details.php');
?>
<?php
}
?>
<div class="contentBlock">
<p>Add another product.</p>
</div>
<?php
include('add_form.php');
?>
<?php
}//END CHECK ADD TO SUBCATEGORY QUERY
}//END CHECK IMAGE UPLOAD
}//END CHECK ITEM NAME EXISTS
}//END ERRORS EXIST
} else {//ELSE IS SUBMITTED
//check if get
if(isset($_GET['subcatId'])){//START IS GET
$ex_subcatId = $_GET['subcatId'];
$query=mysql_query("SELECT * FROM subcategories WHERE subcategoryId='$ex_subcatId' LIMIT 1") or die (mysql_error());
$data=mysql_fetch_assoc($query);
$ex_subcategory=$data['subcategory'];
if(mysql_num_rows($query) < 1) {//START CHECK EXISTS
//If not submitted or get, display add form
?>
<div class="contentBlock">
<p>The subcategory "<?php echo $ex_subcategory; ?>" does not exist, you must <a href="../items/subcategories.php?do=add" target="_self">create the subcategory</a> before adding products to it.</p>
</div>
<?php
unset($ex_subcatId);
include('add_form.php');
?>
<?php
} else {//ELSE CHECK EXISTS
//Display add form
?>
<div class="contentBlock">
<p>Add a new product to the subcategory "<?php echo $ex_subcategory; ?>".</p>
</div>
<?php
include('add_form.php');
?>
<?php
}//END CHECK EXISTS
} else {//ELSE IS GET
//If not submitted or get, display add form
?>
<div class="contentBlock">
<p>Type in the details for the new product.</p>
</div>
<?php
include('add_form.php');
?>
<?php
}//END IS GET
}//END IS SUBMITTED
?>
