Eco-$mart Web Site Administration
Edit WEB FEED | [ HELP ] [ WEB FEEDS ] [ Your Page ] |
$ID = $_GET['ID']; if($ID==""){ $ID = $_POST['ID']; } $update = $_POST['update']; if($update == "yes"){ $Category=$_POST['Category']; $Product=$_POST['Product']; $Price=$_POST['Price']; $Unit=$_POST['Unit']; $Min=$_POST['Min']; $Image_Name=$_POST['Image_Name']; $Image_Qtys = $_POST[Image_Qtys]; $Image_Qty = array_sum($Image_Qtys) + 1; $Description = stripslashes($_POST['Description']); $Status = $_POST['Status']; mysql_select_db('ecosmar_website', $dbcnx); $uppit=mysql_query("UPDATE webfeed SET Category='$Category',Product='$Product',Price='$Price',Unit='$Unit',Min='$Min',Image_Name='$Image_Name',Image_Qty='$Image_Qty',Description='$Description',Status='$Status',dtnum='$dtnum' WHERE ID='$ID'"); if(!$uppit){ $airs[]="Could not update Web Feed. Error: ".mysql_error(); }//uppit error }//update is yes $units[]="EA"; $units[]="SYS"; $units[]="SF"; $units[]="LF"; mysql_select_db('ecosmar_website', $dbcnx); $getcat=mysql_query("SELECT Category FROM webfeed ORDER BY Category"); if(!$getcat){ $airs[]="Could not get Category list. Error: ".mysql_error(); }else{ while($row=mysql_fetch_array($getcat)){ $cats[]=$row[0]; }//while fetching $catscut=array_unique($cats); }//gotcats $getem = mysql_query("SELECT ID,Category,Product,Description,Price,Unit,Min,Image_Name,Image_Qty,Status,dtnum FROM webfeed WHERE ID='$ID'"); if(!$getem){ $airs[]="Could not get Product Information. Error: ".mysql_error(); }else{ $row=mysql_fetch_array($getem); $ID=$row['ID']; $Category=$row['Category']; $Product=$row['Product']; $Description=$row['Description']; $Price=$row['Price']; $Unit=$row['Unit']; $Min=$row['Min']; $Image_Name=$row['Image_Name']; $Image_Qty=$row['Image_Qty']*1; $Status=$row['Status']; if($Status=="show"){ $statopt1="show"; $statopt2="hide"; }else{ $statopt1="hide"; $statopt2="show"; } $dtnum=$row['dtnum']; $chunk_due = chunk_split($dtnum, 2, ':'); $chunk_arrd = explode(":", $chunk_due); $datem = $chunk_arrd[2].'/'.$chunk_arrd[3].'/'.$chunk_arrd[0].$chunk_arrd[1]; }//gotem ?> |