include_once("inc/templates.inc.php");
include_once("inc/dbconnect.inc.php");
session_start();
$handle=mysql_connect ($server, $user, $pw);
mysql_select_db ($db);
$template = new Template("templates","");
$template->set_file(array(
"main" => "page_frontend_cart.htm",
"header" => "header.html",
"footer" => "footer.html",
"leftmenu" => "left_panel.html"
));
/*********** GEN LEFT MENU ******************/
//declair variable;
$selectedMainID;
$selectedContentID;
$selectedMainName;
$selectedContentName;
$selectedInnerName;
$selectedPicID;
//$mainCurrentContent;
//$mainSubContent;
$currentContent;
$txtMenu="";
$txtBody="";
$hasPicture=1;
$sql = "select count(ID) as total from Main_Navigation";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$totalPage = $row['total'];
for($i=1;$i<=$totalPage;$i++){
if($i==1) $mainID=0;
$sql = "select Main_Navigation.ID,ContentID,Menu_Floral_Content,UCase(Navigation) as Navigation, content from Main_Navigation left join SiteContent on Main_Navigation.ContentID= SiteContent.ID where AfterPage=$mainID";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$mainID = $row['ID'];
$Navigation = $row['Navigation'];
$mainContentID = $row['ContentID'];
//set default page to home page.
$txtMenu .= "
";
}
/********** END GEN LEFT MENU******************/
//come from WEBSTORE link
$level1 = SelectBox("How would you like to shop?:", "lstShopBy","270");
$level2 = SelectBox("Please select a price range:", "lstPrice","300");
$level3 = SelectBox("Please select an Instance:", "lstCat","330");
$level4 = SelectBox("", "lstSubCat","360");
$level5 = SelectBox("", "lstInnerSubCat","390");
//Display Design Element
$designEleStr="";
for ($i = 1; $i<=5; $i++){
$sql = "select ID,description from DesignEle order by description";
$result = mysql_query($sql);
$designEleStr= $designEleStr." No Preference ";
while($row=mysql_fetch_array($result)){
if($row['description']==$design1){
$designEleStr = $designEleStr."".$row['description']." ";
}else{
$designEleStr = $designEleStr."".$row['description']." ";
}
}
$designEleStr = $designEleStr." ";
}
$template->set_var("DESIGNELE",$designEleStr);
$mon_list = array("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");
$mon ="MON ";
for($i = 1; $i<=12; $i++){
if($i==date("n")){
$mon = $mon."".$mon_list[$i-1]." ";
}
else{
$mon = $mon."".$mon_list[$i-1]." ";
}
}
$mon = $mon." ";
$day ="
DAY ";
for($i = 1; $i<=31; $i++){
if($i == date("j")){
$day = $day."$i ";
}
else{
$day = $day."$i ";
}
}
$day = $day." ";
$years ="
YEAR ";
for($i = 2004; $i<=2011; $i++){
if($i==date("Y")){
$years = $years."$i ";
}
else{
$years = $years."$i ";
}
}
$years = $years."
";
$qtyStr = "
QUANTITY:
1 ";
for($i=2; $i<=50; $i++){
$qtyStr=$qtyStr."$i ";
}
$qtyStr=$qtyStr."
";
$template -> set_var("MENU",$txtMenu);
$template->set_var("QTY",$qtyStr);
$template->set_var("LEVEL1",$level1);
$template->set_var("LEVEL2",$level2);
$template->set_var("LEVEL3",$level3);
$template->set_var("LEVEL4",$level4);
$template->set_var("LEVEL5",$level5);
$template->set_var("MON",$mon);
$template->set_var("DAY",$day);
$template->set_var("YEARS",$years);
$template->parse("HEADER","header");
$template->parse("LEFTMENU","leftmenu");
$template->parse("FOOTER","footer");
$template->parse("OUTPUT", "main");
$template->p("OUTPUT");
// create empty dropdown box.
function SelectBox( $label, $selectName,$topPosition){
$str = "
$label
------Loading Data----- ";
$str=$str."
";
return $str;
}
?>