include("objects/login/info.php"); include("get_material_title.php"); include("objects/includes/special_shipping.php"); require_once('objects/includes/functions_inc.php'); session_start(); ?> $cart = $_SESSION['cart']; $action = $_GET['action']; switch ($action) { case 'add': if ($cart) { $cart .= ','.$_GET['id']; } else { $cart = $_GET['id']; } break; case 'delete': if ($cart) { $items = explode(',',$cart); $newcart = ''; foreach ($items as $item) { if ($_GET['id'] != $item) { if ($newcart != '') { $newcart .= ','.$item; } else { $newcart = $item; } } } $cart = $newcart; } break; case 'update': if ($cart) { $newcart = ''; foreach ($_POST as $key=>$value) { if (stristr($key,'qty')) { $id = str_replace('qty','',$key); $items = ($newcart != '') ? explode(',',$newcart) : explode(',',$cart); $newcart = ''; foreach ($items as $item) { if ($id != $item) { if ($newcart != '') { $newcart .= ','.$item; } else { $newcart = $item; } } } for ($i=1;$i<=$value;$i++) { if ($newcart != '') { $newcart .= ','.$id; } else { $newcart = $id; } } } } } $cart = $newcart; break; } $_SESSION['cart'] = $cart; ?>
mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query="SELECT * FROM contact_info"; $result=mysql_query($query); $query2="SELECT * FROM weekly_special"; $result2=mysql_query($query2); mysql_close(); $title=mysql_result($result,0,"boom_title"); $address1=mysql_result($result,0,"address1"); $address2=mysql_result($result,0,"address2"); $phone=mysql_result($result,0,"phone"); $fax=mysql_result($result,0,"fax"); /*SPECIAL VARIABLES*/ $special_type=mysql_result($result2,0,"type"); $special_id=mysql_result($result2,0,"sku1"); $special_title=mysql_result($result2,0,"title"); $special_description=mysql_result($result2,0,"description"); $special_price=mysql_result($result2,0,"price"); /******************/ /* PHP SPLIT FUNCTION FOR
![]() Unable to select database |