echo $resmenu['name'];?>
x echo $productprice;?>.00 $qty;?>
?>
}
?>
echo sprintf('%0.2f', $totprice);?>
$totprice;?>
}
}
?>
Cart Total
$objqrynewsubee = "SELECT SUM(totprice) AS amtTotal FROM shop_cart_admin where session_id='$browsessionid'";
$objResultnewsubee = mysql_query($objqrynewsubee);
$Fetchnewww = mysql_fetch_array($objResultnewsubee);
$subtotal=$Fetchnewww['amtTotal'];
?>
echo $subtotal;?>
}
else
{
?>
$Query_jobmal = mysql_query("SELECT id from shop_cart_admin where session_id='$browsessionid' ");
$qty=mysql_num_rows($Query_jobmal);
$objqrynewsubee = "SELECT SUM(totprice) AS amtTotal FROM shop_cart_admin where session_id='$browsessionid'";
$objResultnewsubee = mysql_query($objqrynewsubee);
$Fetchnewww = mysql_fetch_array($objResultnewsubee);
$subtotal=$Fetchnewww['amtTotal'];
$dis_amount=0;
?>
Product1
Total
$objitem = mysql_query("SELECT * from shop_cart_admin where session_id='$browsessionid'");
$i=1;
$j=1;
$si=0;
$num_rows = mysql_num_rows($objitem);
$totprice1=0;
if($num_rows > 0)
{
while($Fetitem = mysql_fetch_array($objitem))
{
$menuid=$Fetitem['id'];
$menuid_d_s=$Fetitem['productid'];
$si=$si+1;
$qty=$Fetitem['qty'];
/*$qty_p="";
$qty_p .="qty_";
$qty_p .=$menuid_d_s;
$qty_p;
$par=$_REQUEST[$qty_p];
if($par=='')
{
$qty=1;
}
if($par=='')
{
$qty=$par;
}*/
$objmenu=mysql_query("SELECT * from shop_product where product_id='$menuid_d_s'");
$resmenu=mysql_fetch_array($objmenu);
$menuname=$resmenu['name'];
$productprice=$resmenu['price'];
$productprice_int=$resmenu['price'];
$totprice=($qty*$resmenu['price']);
$totprice_int=($qty*$resmenu['price']);
$new_price +=$totprice_int;
if($country=="India")
{
$Updatecart = mysql_query("UPDATE shop_cart_admin SET `price`='$productprice',`totprice`='$totprice' where id='$menuid' ");
}
else
{
$Updatecart = mysql_query("UPDATE shop_cart_admin SET `price`='$productprice_int',`totprice`='$totprice_int' where id='$menuid' ");
//$Updatecart = mysql_query("UPDATE tbl_confirmorder SET `contry`='$del_country',`city`='$del_city',`state`='$del_state',`address`='$del_address',`pin`='$del_inp' where orid='$attachmentfileid' ");
}
$vstatus=$resmenu['vstatus'];
$weight=$resmenu['stock_status_id'];
if($weight=='' || $weight==0)
{
$weight=100;
}
if($new_status==1)
{
if($vstatus==1)
{
$v_qty=($qty/2);
}
if($vstatus==6)
{
$v_qty=($qty/2);
}
if($vstatus==7)
{
$v_qty=($qty/2);
}
if($vstatus==2)
{
$v_qty=($qty/4);
}
$x = (int)$v_qty;
}
else
{
$x=0;
}
$x;
$new_qty=($weight*($qty+$x));
$new_kilo=($new_qty/1000);
$new_kilo_1 = explode('.',$new_kilo);
$new_kilo_2=$new_kilo_1[0]; // Before the Decimal point
$new_kilo_3 +=$new_kilo_2;
$totprice1 +=$totprice;
$tot_weight_2 +=$new_qty;
$Query_job_move_product = mysql_query("SELECT * from shop_product_image where product_id='$menuid_d_s' order by product_id asc ");
$row_job_move_product_id = mysql_fetch_array($Query_job_move_product);
?>