0) { $Updatecart = "UPDATE shop_user SET `email`='$email',`phone`='$phone',`state`='$state',`country`='$country',`postcode`='$pin',`city`='$city',`address`='$address',`name`='$name' WHERE `user_id`='$sessionid_free' "; } $objcorderid = mysql_query("SELECT * from tbl_confirmorder "); $nosnewcid=mysql_num_rows($objcorderid); $Fetcorderid = mysql_fetch_array($objcorderid); if($nosnewcid=='0') { $maxcorderid='1'; $maxcorderid1=HC.$maxcorderid; } else { $objmaxcorder = mysql_query("SELECT max(orid)+1 as newordid from tbl_confirmorder "); $Fetmaxcorder = mysql_fetch_array($objmaxcorder); $maxcorderid=$Fetmaxcorder['newordid']; $maxcorderid1=HC.$maxcorderid; } if($numrows>0) { $date = date_default_timezone_set('Asia/Kolkata'); $dt2=date('Y-m-d H:i:s' ); $Insert_memberord = "INSERT INTO tbl_confirmorder (`userid`,`intsessionid`,`orderid`,`refid`,`varstatus`,`order_tc_id`,`orderstatus`,`res_id`,`type`,`order_date_time`) VALUES ('$sessionid_free','$browsessionid','$maxcorderid','$maxcorderid1','0','$ORDER_ID','0','','','$dt2')"; $inexeord=mysql_query($Insert_memberord); $attachmentfileid = mysql_insert_id(); $sessionid_free= addslashes($_POST['sessionid_free']); $objRe = mysql_query("SELECT * from shop_cart where session_id='$browsessionid'"); while($Fetchneword = mysql_fetch_array($objRe)) { $productid= $Fetchneword['productid']; $qty= $Fetchneword['qty']; $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`) VALUES ('$sessionid_free','','$productid','$qty' ,'$price' ,'$totprice','$dt2','','$browsessionid','','$attachmentfileid')"; $inexe=mysql_query($Insert_member); } $Delete_Question = "DELETE FROM shop_cart 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_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']; $Msg1.='

New Order Recived-Order Details.

Order Details
Order ID:'.$new_order_id.' Date Added:'.$orderdate.' Payment Method: Onlinepayment	Name: '.$_SESSION['username1'].' Email: '.$Fetcorderid_n_user['phone'].' Address: '.$Fetcorderid_n_user['address'].'

';?> '; } ?>

Product	Quantity	Price	Total
'.$Fetproduct['name'].'	1	RS.'.$Fetproduct['price'].'	RS. '.$Fetproduct['price'].'
Sub Total:			RS. '.$subtotal.'
Total:			RS. '.$full_total_cm_ar.'

'; $Msg1; $job_name14357="New Order Received"; $Subjectnew = "$job_name14357-$order_id"; $useremail="sacpara21@gmail.com"; $headers1 = "From: dranbuganapathi.com\r\n"."Content-Type: text/html; charset=iso-8859-1\r\n"; //$headers = "From: dranbuganapathi@gmail.com\r\n"."Content-Type: text/html; charset=iso-8859-1\r\n"; @mail($useremail,$Subjectnew,$Msg1,$headers1); @mail($new_user_name,$Subjectnew,$Msg1,$headers1); } //$Recart = mysql_query($Updatecart); ?> Merchant Check Out Page

Please do not refresh this page...