0)
{
$date = date_default_timezone_set('Asia/Kolkata');
$dt2=date('Y-m-d H:i:s' );
$offer=addslashes($_POST['offer']);
$Insert_memberord = "INSERT INTO tbl_confirmorder (`userid`,`intsessionid`,`orderid`,`refid`,`orderstatus`,`res_id`,`varstatus`,`order_date_time`,`order_tc_id`,`company_name`,`offer`) VALUES ('$sessionid_free','$browsessionid','$maxcorderid','$orderid_new_s','0','$ses_us','$payment_mode','$dt2','$checkboxValue_2','$company_name','$offer')";
$inexeord=mysql_query($Insert_memberord);
$attachmentfileid = mysql_insert_id();
//$sessionid_free= addslashes($_POST['sessionid_free']);
$Updatecart = mysql_query("UPDATE tbl_confirmorder SET `orderid`='$attachmentfileid' where orid='$attachmentfileid' ");
$objRe = mysql_query("SELECT * from shop_cart_admin_demo where session_id='$browsessionid'");
$numrows_ma = mysql_num_rows($objRe);
while($Fetchneword = mysql_fetch_array($objRe))
{
$del_country=$Fetchneword['del_country'];
$del_city=$Fetchneword['del_city'];
$del_state=$Fetchneword['del_state'];
$del_address=$Fetchneword['del_address'];
$del_inp=$Fetchneword['del_inp'];
"UPDATE tbl_confirmorder SET `contry`='$del_country',`city`='$del_city',`state`='$del_state',`address`='$del_address',`pin`='$del_inp' where orid='$attachmentfileid' ";
$Updatecart = mysql_query("UPDATE tbl_confirmorder SET `contry`='$country',`city`='$city',`state`='$state',`address`='$address',`pin`='$pin' where orid='$attachmentfileid' ");
$productid= $Fetchneword['productid'];
$qty= $Fetchneword['qty'];
$freeqty= $Fetchneword['qty_free'];
$price= $Fetchneword['price'];
$totprice= $Fetchneword['totprice'];
$date = date_default_timezone_set('Asia/Kolkata');
$dt2=date('Y-m-d H:i:s' );
$Insert_member = "INSERT INTO tbl_order(`user_id`,`res_id`,`productid`,`qty`,`price`,`totprice`,`orderdate`,`type`,`session_id`,`ordertime`,`orderid`,`freeqty`) VALUES ('$sessionid_free','0','$productid','$qty','$price' ,'$totprice','$dt2','','$browsessionid','','$attachmentfileid','$freeqty')";
$inexe=mysql_query($Insert_member);
}
$Delete_Question = "DELETE FROM shop_cart_admin_demo WHERE `session_id`='$browsessionid'";
$Result_Question = mysql_query($Delete_Question);
"SELECT * from shop_user where user_id='$sessionid_free_123' ";
$objcorderid_n_user = mysql_query("SELECT * from shop_user where user_id='$sessionid_free_123' ");
$nosnewcid_n_user=mysql_num_rows($objcorderid_n_user);
$Fetcorderid_n_user = mysql_fetch_array($objcorderid_n_user);
$new_status=$Fetcorderid_n_user['new_status'];
$new_user_name=$Fetcorderid_n_user['email'];
$objcorderid = mysql_query("SELECT * from tbl_confirmorder where orid='$attachmentfileid' ");
$nosnewcid=mysql_num_rows($objcorderid);
$Fetcorderid = mysql_fetch_array($objcorderid);
$new_order_id=$Fetcorderid['orderid'];
$new_order_id=$Fetcorderid['orderid'];
$userid_new_userid=$Fetcorderid['userid'];
$orderdate=$Fetcorderid['order_date_time'];
$order_id=$Fetcorderid['refid'];
$contry=$Fetcorderid['contry'];
if($contry=="India")
{
$sym="Rs";
}
else
{
$sym="$";
}
$city=$Fetchneword['city'];
$state=$Fetcorderid['state'];
$address=$Fetchneword['address'];
$pin=$Fetchneword['pin'];
?>
mail
query($objconfirmorder);
$nss_con=mysql_num_rows($objconfirmorder);
$manssss='0';
$rows_order = mysql_fetch_array($objconfirmorder);
$orderid=$rows_order['orderid'];
$res_id =$rows_order['res_id'];
$type =$rows_order['type'];
$datenew=$rows_order['deliverydate'];
$userid =$rows_order['userid'];
$orderstatus=$rows_order['orderstatus'];
$state=$rows_order['state'];
$contry=$rows_order['contry'];
if($contry=="India")
{
$ss="Payumoney";
}
else
{
$ss="Paypal";
}
$courier_no=$rows_order['courier_no'];
"SELECT * from `shop_user` where user_id='$userid' ";
$Query = mysql_query("SELECT * from `shop_user` where user_id='$userid' ");
//$name=$DB->query($Query);
$no=mysql_num_rows($Query);
$row = mysql_fetch_array($Query);
$new_status=$row['new_status'];
?>
mail
0)
{}
}
header("location:order_confirm_admin.php?id=".$attachmentfileid);
exit();
}
?>