<<<<Restricted Area>>>>" . "
Sorry, you must Log In to view this Page

"); exit(); } $usrn = $_GET['usrn']; if($usrn == ""){ $usrn = $_POST['usrn']; } if($usrn == ""){ echo("

<<<<Restricted Area>>>>" . "
Problem with your username. Please Log In again.

"); exit(); } ?>
Return to Your Page Eco-$mart Products
  Product Shipping Updater
Copy and Paste from Master Excel File:  Eco-$mart_Product_Shipping.xls

go back and check."); exit(); } $result = array_diff_assoc($eccheck, $cols); if(!empty($result)){ echo("Error! Column Heading Name Mismatch. Are you updating with the proper file? Please go back and check."); exit(); } $dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1'); mysql_select_db('ecosmar_products', $dbcnx); $chk = mysql_query("SELECT item FROM ship"); if(!$chk){ echo("

Trouble checking for deletions.
".mysql_error()."

"); }else{ while($row = mysql_fetch_array($chk)){ if($row[0] != ""){ $allitems[] = $row[0]; } } } echo(""); echo(""); foreach($excol as $value){ $exrow = explode("\t", $value); if($exrow[0] != ""){ $initems[] = $exrow[0]; } $exrowcnt = count($exrow); if($exrowcnt == $firstcount){ $i = 0; while($i < $exrowcnt){ if($exrow[$i] != ""){ $shoit = addslashes($exrow[$i]); }else{ $shoit = ""; } $newit[] = $shoit; echo(""); $i = $i + 1; } if(!empty($newit)){ $newly = implode('|', $newit); echo(""); } echo(""); }else{ echo(""); $warn = "on"; } $newit = array(); }//foreach echo("
$shoit 
Problems with this row. Incorrect data type or field.
"); if(!empty($allitems)){ $result = array_diff($allitems, $initems); if(!empty($result)){ $del = "on"; } } ?>
Eco-$mart Products
©2008 - Data Base Interface - Custom Built at:  kwgrubbs.com
" . "
Inspection Complete. Cannot complete update. Incorrect or Mismatched Data. Please try again.
"); }elseif($del == "on"){ echo("
" . "
Delete these items?" . "
"); foreach($result as $value){ echo("$value 
"); }//4ea echo("

"); }else{ echo("
" . "" . "
Inspection Complete.
Update Data Base?
" . "
"); } ?>