Ponel Posted January 28, 2021 Share Posted January 28, 2021 (edited) Good morning, I'm writing a php script on a transaction creation/initiation. Only a registered user can initiate a transaction but if the second party to the transaction is not a registered user, the system will send a mail to the user informing him/her to accept and create an account. The whole idea is i have four conditional statement and each condition needs to send mail to the transaction initiator and the second party. so i am sending 8 mails but 2 at a time if and only if the condition is met. below is my code if ($mode==1){ //echo "Mode 1: ".$mode; $mode2 = 2; $sql = "SELECT * FROM reg WHERE email='$email'"; $query = mysqli_query($con,$sql); $rowreg = mysqli_fetch_row($query); $dbid = $rowreg[0]; $dbemail = $rowreg[1]; if (mysqli_num_rows($query)>0){ /* Create a new PHPMailer object. Passing TRUE to the constructor enables exceptions. */ $mail = new PHPMailer(TRUE); /* Open the try/catch block. */ try { /* Set the mail sender. */ $mail->setFrom('no-reply@me.com', 'Mecom'); /* Add a recipient. */ $mail->addAddress("$email", "$full_name"); /* Set the subject. */ $mail->Subject = 'Transaction Created Successfully'; $mail->isHTML(TRUE); /* Set the mail message body. */ $mail->Body = '<div class="email-background" style="background: #eee;padding: 10px;"> <a href=""><center><img src="" style="padding-top:30px;padding-bottom:30px;max-width:100px;height:100px;margin: 0 auto;"></center><a> <div class="email-container" style="max-width: 500px;background: white;font-family: san-serif;margin: 0 auto;overflow: hidden;border-radius: 5px;text-align: center;"> <p style="margin: 20px;font-size: 12px;font-weight: 300;color: #666;line-height: 1.5;text-align:left"> Dear <b>' . $full_name . '</b>;<br/>We believe there is an agreement between you and <b>'. $fullname .' </b>for a transaction. Please see the details of the transaction below</p> <div class="table table-responsive" style="margin-left: 10px;margin-right: 10px;"> <table class="table table-striped table-bordered" style="max-width: 100%;background-color: transparent;border-collapse: collapse;border-spacing: 0;display: table;width: 100%;margin-bottom: 20px;border: 1px solid #ddd;"> <tbody style="display: table-row-group;vertical-align: middle;border-color: inherit;"> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="2" width="100%" style="text-align: center;background: #00bf6f;color: white;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;font-size:20px">Transaction Details <b>'.$transact_no.'</b></td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Title</td> <td colspan="" width="80%" style="text-align: right;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$db_cat_category.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Description</td> <td colspan="" width="80%" style="text-align: right;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$description.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Link</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$tran_link.'</td> </tr> '.$customerMail.' <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Item Worth/Price</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">₦'.$price_format.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Charges bearer</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$charges.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Total Charges</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">₦'.$chrg.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Who pay the charges?</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$chrgs.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Buyer Pays</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$buyer_t_pay.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Seller Receives</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$seller_t_receives.'</td> </tr> </tbody> </table> </div> </div> <div class="footer-junk" style="background: none;padding: 20px;font-size: 12px;text-align: center;"> Copyright © Mecom'. $year .' All Rights Reserved </div> </div>'; /* Finally send the mail. */ //$mail->send(); if (!$mail->send()){ /* PHPMailer error. */ echo $mail->ErrorInfo; }else{ $output ="<div class=\"alert alert-success\">Transaction has been created successfully</div>"; } catch (Exception $e) { /* PHPMailer exception. */ echo $e->errorMessage(); } catch (\Exception $e) { /* PHP exception (note the backslash to select the global namespace Exception class). */ echo $e->getMessage(); } // //End of First User //Second User // $fullname = $user["firstname"] . " " . $user["lastname"]; $full_name = $fname . " ". $lname; /* Create a new PHPMailer object. Passing TRUE to the constructor enables exceptions. */ $mail = new PHPMailer(TRUE); /* Open the try/catch block. */ try { /* Set the mail sender. */ $mail->setFrom('no-reply@me.com', 'Mecom'); /* Add a recipient. */ $mail->addAddress("$dbemail", "$fullname"); /* Set the subject. */ $mail->Subject = 'Transaction Created Successfully'; $mail->isHTML(TRUE); /* Set the mail message body. */ $mail->Body = '<div class="email-background" style="background: #eee;padding: 10px;"> <a href=""><center><img src="" style="padding-top:30px;padding-bottom:30px;max-width:100px;height:100px;margin: 0 auto;"></center><a> <div class="email-container" style="max-width: 500px;background: white;font-family: san-serif;margin: 0 auto;overflow: hidden;border-radius: 5px;text-align: center;"> <p style="margin: 20px;font-size: 12px;font-weight: 300;color: #666;line-height: 1.5;text-align:left"> Dear ' . $fullname . ',<br/>You just initiated a transaction with title <b>'. $cat_category .'</b> and description <b> '. $description .' </b>to <b>'. $full_name .' </b>. Below is the details of the transaction</p> <div class="table table-responsive" style="margin-left: 10px;margin-right: 10px;"> <table class="table table-striped table-bordered" style="max-width: 100%;background-color: transparent;border-collapse: collapse;border-spacing: 0;display: table;width: 100%;margin-bottom: 20px;border: 1px solid #ddd;"> <tbody style="display: table-row-group;vertical-align: middle;border-color: inherit;"> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="2" width="100%" style="text-align: center;background: #00bf6f;color: white;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;font-size:20px">Transaction Details <b>'.$transact_no.'</b></td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Title</td> <td colspan="" width="80%" style="text-align: right;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$db_cat_category.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Description</td> <td colspan="" width="80%" style="text-align: right;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$description.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Link</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$tran_link.'</td> </tr> '.$customerMail.' <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Item Worth/Price</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">₦'.$price_format.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Charges bearer</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$charges.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Total Charges</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">₦'.$chrg.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Who pay the charges?</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$chrgs.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Buyer Pays</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$buyer_t_pay.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Seller Receives</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$seller_t_receives.'</td> </tr> </tbody> </table> </div> </div> <div class="footer-junk" style="background: none;padding: 20px;font-size: 12px;text-align: center;"> Copyright © Mecom'. $year .' All Rights Reserved </div> </div>'; /* Finally send the mail. */ //$mail->send(); if (!$mail->send()){ /* PHPMailer error. */ echo $mail->ErrorInfo; }else{ // $output ="<div class=\"alert alert-success\">Transaction has been created successfully</div>"; echo "<script> window.onload = function() { sweetAlert({ title: 'Congratulations', text: 'Your transaction has been created successfully', type: 'success', confirmButtonColor: '#B6EA36' }, function () { window.location.href = './'; }); }; </script>"; } } catch (Exception $e) { /* PHPMailer exception. */ echo $e->errorMessage(); } catch (\Exception $e) { /* PHP exception (note the backslash to select the global namespace Exception class). */ echo $e->getMessage(); } // //End of Second User }else{ //if the second user that is not the initiator is not a registered user //Add user info into the database table for the main site table //include ('includes/randStrGen.php'); $reg_no = randStrGen(4); $check_ID_query = mysqli_query($con, "SELECT regNo FROM reg WHERE regNo='$reg_no'"); $i = 0; //if username exists add number to username while(mysqli_num_rows($check_ID_query) != 0) { $i++; //Add 1 to i $reg_no = $reg_no + $i; $check_ID_query = mysqli_query($con, "SELECT regNo FROM reg WHERE regNo='$reg_no'"); } /* echo "First Name ". $fname . "<br>"; echo "Last Name ". $lname . "<br>"; echo "Address ". $address . "<br>"; echo "Phone Number ". $phonenumber . "<br>"; echo "Registration Number ". $reg_gen . "<br>"; exit();*/ $sql_reg = "INSERT INTO reg(email,password,firstname,lastname,marital_status,phone_number,IDmeans,passportID,lastlogin,regNo,address,bank_acct_number,bank_acct_name,bank_name,real_pass,activation,regDate) VALUES('$email','0','$fname','$lname','0','$phonenumber','0','0',now(),'$reg_no','$address','0','0','0','0','0',now())"; $query_reg = mysqli_query($con,$sql_reg); $regid = mysqli_insert_id($con); $sql_reg_verify = "INSERT INTO account_verify(token_email,refno) VALUES('$email','$reg_no')"; $query_reg_verify = mysqli_query($con,$sql_reg_verify); //$regid = mysqli_insert_id($link); $sql_description = "INSERT INTO description(item_description,transactID) VALUES('$description','$transact_no')"; $query_description = mysqli_query($con,$sql_description); $descid = mysqli_insert_id($con); //$r_tran= $_SESSION['transID'] .$descid ; $sql = "INSERT INTO trans_tbl(transact_no,transact_date,agreement_status,mode_transactID,transact_catID,regID,descID,amount,shipcost,status,transaction_period,inspection_length,charges,amt_pay,comp_charges,transaction_link,payment_status,shipment_status,confirm_shipment,address,refno) VALUES('$transact_no',now(),'1','$mode','$cat','$user[id]','$descid','$price','0','0','0','0','$charges','0','$chrg','0','0','0','0','$address','0'), ('$transact_no',now(),'1','$mode2','$cat','$regid','$descid','$price','0','0','0','0','$charges','0','$chrg','0','0','0','0','$address','0')"; $query = mysqli_query($con,$sql); /* Sending mail to new user to update his/her password */ $encode_email = base64_encode(base64_encode($email)); $encode_reg = base64_encode(base64_encode($reg_no)); //$encode_transactiinID = base64_encode(base64_encode($_SESSION['transID'])); //$encode_parnterID = base64_encode(base64_encode($_SESSION['id'])); //$encode_modeID = base64_encode(base64_encode($mode)); $link_url="<a href=\"https://www.safetranzact.com/verify-account?token=$encode_reg\" style=\"text-decoration: none;display: inline-block;background: #00bf6f;color: white;padding: 10px 20px;border-radius: 5px;\">Review and Sign up</a>"; $year = date('Y'); //send email to the receiver //First user for non register // $full_name = $fname . " " . $lname; $fullname = $user["firstname"] . " ". $user["lastname"]; /* Create a new PHPMailer object. Passing TRUE to the constructor enables exceptions. */ $mail = new PHPMailer(TRUE); /* Open the try/catch block. */ try { /* Set the mail sender. */ $mail->setFrom('no-reply@me.com', 'Mecom'); /* Add a recipient. */ $mail->addAddress("$email", "$full_name"); /* Set the subject. */ $mail->Subject = 'Account/Transaction Verification'; $mail->isHTML(TRUE); /* Set the mail message body. */ $mail->Body = '<div class="email-background" style="background: #eee;padding: 10px;"> <a href=""><center><img src="" style="padding-top:30px;padding-bottom:30px;max-width:100px;height:100px;margin: 0 auto;"></center><a> <div class="email-container" style="max-width: 500px;background: white;font-family: san-serif;margin: 0 auto;overflow: hidden;border-radius: 5px;text-align: center;"> <p style="margin: 20px;font-size: 12px;font-weight: 300;color: #666;line-height: 1.5;text-align:left"> Dear ' . $full_name. ',<br/>We believe there is an agreement between you and <b>'. $fullname .' </b> for a transaction. And we noticed that you have not yet signed up; Please Sign up and see the details of the transaction below</p> <div class="table table-responsive" style="margin-left: 10px;margin-right: 10px;"> <table class="table table-striped table-bordered" style="max-width: 100%;background-color: transparent;border-collapse: collapse;border-spacing: 0;display: table;width: 100%;margin-bottom: 20px;border: 1px solid #ddd;"> <tbody style="display: table-row-group;vertical-align: middle;border-color: inherit;"> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="2" width="100%" style="text-align: center;background: #00bf6f;color: white;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;font-size:20px">Transaction Details <b>'.$transact_no.'</b></td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Title</td> <td colspan="" width="80%" style="text-align: right;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$db_cat_category.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Description</td> <td colspan="" width="80%" style="text-align: right;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$description.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Link</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$tran_link.'</td> </tr> '.$customerMail.' <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Item Worth/Price</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">₦'.$price_format.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Charges bearer</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$charges.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Total Charges</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">₦'.$chrg.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Who pay the charges?</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$chrgs.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Buyer Pays</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$buyer_t_pay.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Seller Receives</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$seller_t_receives.'</td> </tr> </tbody> <tfoot> <tr> <td colspan="2">'.$link_url.'</td> </tr> </tfoot> </table> </div> </div> <div class="footer-junk" style="background: none;padding: 20px;font-size: 12px;text-align: center;"> Copyright © Mecom'. $year .' All Rights Reserved </div> </div>'; /* Finally send the mail. */ //$mail->send(); if (!$mail->send()){ /* PHPMailer error. */ echo $mail->ErrorInfo; }else{ $output ="<div class=\"alert alert-success\">Transaction has been created successfully</div>"; } } catch (Exception $e) { /* PHPMailer exception. */ echo $e->errorMessage(); } catch (\Exception $e) { /* PHP exception (note the backslash to select the global namespace Exception class). */ echo $e->getMessage(); } // // //End of First user for non register //Second user for register // $full_name = $fname . " " . $lname; $fullname = $user["firstname"] . " ". $user["lastname"]; $year = date('Y'); /* Create a new PHPMailer object. Passing TRUE to the constructor enables exceptions. */ $mail = new PHPMailer(TRUE); /* Open the try/catch block. */ try { /* Set the mail sender. */ $mail->setFrom('no-reply@me.com', 'Mecom'); /* Add a recipient. */ $mail->addAddress("$dbemail", "$fullname"); /* Set the subject. */ $mail->Subject = 'Transaction Created Successfully'; $mail->isHTML(TRUE); /* Set the mail message body. */ $mail->Body = '<div class="email-background" style="background: #eee;padding: 10px;"> <a href=""><center><img src="" style="padding-top:30px;padding-bottom:30px;max-width:100px;height:100px;margin: 0 auto;"></center><a> <div class="email-container" style="max-width: 500px;background: white;font-family: san-serif;margin: 0 auto;overflow: hidden;border-radius: 5px;text-align: center;"> <p style="margin: 20px;font-size: 12px;font-weight: 300;color: #666;line-height: 1.5;text-align:left"> Dear ' . $fullname . ',<br/>You just initiated a transaction with title <b>'. $cat_category .'</b> and description <b>'. $description .' </b> to <b>'. $full_name .' </b> Below is the details of the transaction</p> <div class="table table-responsive" style="margin-left: 10px;margin-right: 10px;"> <table class="table table-striped table-bordered" style="max-width: 100%;background-color: transparent;border-collapse: collapse;border-spacing: 0;display: table;width: 100%;margin-bottom: 20px;border: 1px solid #ddd;"> <tbody style="display: table-row-group;vertical-align: middle;border-color: inherit;"> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="2" width="100%" style="text-align: center;background: #00bf6f;color: white;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;font-size:20px">Transaction Details <b>'.$transact_no.'</b></td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Title</td> <td colspan="" width="80%" style="text-align: right;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$db_cat_category.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Description</td> <td colspan="" width="80%" style="text-align: right;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$description.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Link</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$tran_link.'</td> </tr> '.$customerMail.' <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Item Worth/Price</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">₦'.$price_format.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Charges bearer</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$charges.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Total Charges</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">₦'.$chrg.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Who pay the charges?</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$chrgs.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Buyer Pays</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$buyer_t_pay.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Seller Receives</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$seller_t_receives.'</td> </tr> </tbody> </table> </div> </div> <div class="footer-junk" style="background: none;padding: 20px;font-size: 12px;text-align: center;"> Copyright © Mecom'. $year .' All Rights Reserved </div> </div>'; /* Finally send the mail. */ //$mail->send(); if (!$mail->send()){ /* PHPMailer error. */ echo $mail->ErrorInfo; }else{ echo "<script> window.onload = function() { sweetAlert({ title: 'Congratulations', text: 'Your transaction has been created successfully', type: 'success', confirmButtonColor: '#B6EA36' }, function () { window.location.href = './'; }); }; </script>"; } } catch (Exception $e) { /* PHPMailer exception. */ echo $e->errorMessage(); } catch (\Exception $e) { /* PHP exception (note the backslash to select the global namespace Exception class). */ echo $e->getMessage(); } //$mail4->ClearAllRecipients(); // //End of Second user for register } }else{ ///////////////////////Second condition with //echo "Mode 2: ".$mode; $mode2 = 1; $sql = "SELECT * FROM reg WHERE email='$email' LIMIT 1"; $query = mysqli_query($con,$sql); $rowreg = mysqli_fetch_row($query); $dbid = $rowreg[0]; $dbemail = $rowreg[1]; if (mysqli_num_rows($query)>0){ //Add user info into the database table for the main site table $sql_description = "INSERT INTO description(item_description,transactID) VALUES('$description','$transact_no')"; $query_description = mysqli_query($con,$sql_description); $desc_id = mysqli_insert_id($con); //$r_tran= $_SESSION['transID'] .$descid ; $sql = "INSERT INTO trans_tbl(transact_no,transact_date,agreement_status,mode_transactID,transact_catID,regID,descID,amount,shipcost,status,transaction_period,inspection_length,charges,amt_pay,comp_charges,transaction_link,payment_status,shipment_status,confirm_shipment,address,refno) VALUES('$transact_no',now(),'1','$mode','$cat','$user[id]','$desc_id','$price','0','0','0','0','$charges','0','$chrg','$tran_link','0','0','0','$address','0'), ('$transact_no',now(),'1','$mode2','$cat','$dbid','$desc_id','$price','0','0','0','0','$charges','0','$chrg','$tran_link','0','0','0','$address','0')"; $query = mysqli_query($con,$sql); //First user to received email // $full_name = $fname . " ". $lname; $fullname = $user["firstname"] . " ". $user["lastname"]; $year = date('Y'); /* Create a new PHPMailer object. Passing TRUE to the constructor enables exceptions. */ $mail = new PHPMailer(TRUE); /* Open the try/catch block. */ try { /* Set the mail sender. */ $mail->setFrom('no-reply@me.com', 'Mecom'); /* Add a recipient. */ $mail->addAddress("$email", "$full_name"); /* Set the subject. */ $mail->Subject = 'Transaction Created Successfully'; $mail->isHTML(TRUE); /* Set the mail message body. */ $mail->Body = '<div class="email-background" style="background: #eee;padding: 10px;"> <a href="https://www.safetranzact.com"><center><img src="https://www.safetranzact.com/assets/images/fav.png" style="padding-top:30px;padding-bottom:30px;max-width:100px;height:100px;margin: 0 auto;"></center><a> <div class="email-container" style="max-width: 500px;background: white;font-family: san-serif;margin: 0 auto;overflow: hidden;border-radius: 5px;text-align: center;"> <p style="margin: 20px;font-size: 12px;font-weight: 300;color: #666;line-height: 1.5;text-align:left"> Dear <b>' . $full_name . '</b>,<br/>We believe there is an agreement between you and <b> '. $fullname .' </b>for a transaction. Please see the details of the transaction below</p> <div class="table table-responsive" style="margin-left: 10px;margin-right: 10px;"> <table class="table table-striped table-bordered" style="max-width: 100%;background-color: transparent;border-collapse: collapse;border-spacing: 0;display: table;width: 100%;margin-bottom: 20px;border: 1px solid #ddd;"> <tbody style="display: table-row-group;vertical-align: middle;border-color: inherit;"> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="2" width="100%" style="text-align: center;background: #00bf6f;color: white;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;font-size:20px">Transaction Details <b>'.$transact_no.'</b></td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Title</td> <td colspan="" width="80%" style="text-align: right;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$db_cat_category.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Description</td> <td colspan="" width="80%" style="text-align: right;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$description.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Link</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$tran_link.'</td> </tr> '.$customerMail.' <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Item Worth/Price</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">₦'.$price_format.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Charges bearer</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$charges.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Total Charges</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">₦'.$chrg.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Who pay the charges?</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$chrgs.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Buyer Pays</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$buyer_t_pay.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Seller Receives</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$seller_t_receives.'</td> </tr> </tbody> </table> </div> </div> <div class="footer-junk" style="background: none;padding: 20px;font-size: 12px;text-align: center;"> Copyright © Safetranzact '. $year .' All Rights Reserved </div> </div>'; /* Finally send the mail. */ //$mail->send(); if (!$mail->send()){ /* PHPMailer error. */ echo $mail->ErrorInfo; }else{ $output ="<div class=\"alert alert-success\">Transaction has been created successfully</div>"; } //$mail->ClearAllRecipients(); } catch (Exception $e) { /* PHPMailer exception. */ echo $e->errorMessage(); } catch (\Exception $e) { /* PHP exception (note the backslash to select the global namespace Exception class). */ echo $e->getMessage(); } //$mail->ClearAllRecipients(); // //End of First user to received email //Second user to received email // $fullname = $user["firstname"] . " " . $user["lastname"]; $full_name = $fname . " " . $lname; $year = date('Y'); /* Create a new PHPMailer object. Passing TRUE to the constructor enables exceptions. */ $mail = new PHPMailer(TRUE); /* Open the try/catch block. */ try { /* Set the mail sender. */ $mail->setFrom('no-reply@safetranzact.com', 'Safetranzact'); /* Add a recipient. */ $mail->addAddress("$dbemail", "$fullname"); /* Set the subject. */ $mail->Subject = 'Transaction Created Successfully'; $mail->isHTML(TRUE); /* Set the mail message body. */ $mail->Body = '<div class="email-background" style="background: #eee;padding: 10px;"> <a href=""><center><img src="" style="padding-top:30px;padding-bottom:30px;max-width:100px;height:100px;margin: 0 auto;"></center><a> <div class="email-container" style="max-width: 500px;background: white;font-family: san-serif;margin: 0 auto;overflow: hidden;border-radius: 5px;text-align: center;"> <p style="margin: 20px;font-size: 12px;font-weight: 300;color: #666;line-height: 1.5;text-align:left"> Dear ' . $fullname . ',<br/>You just initiated a transaction with title <b>'. $cat_category .'</b> and description <b>'. $description .' to <b>'. $full_name .' </b>Below is the details of the transaction</p> <div class="table table-responsive" style="margin-left: 10px;margin-right: 10px;"> <table class="table table-striped table-bordered" style="max-width: 100%;background-color: transparent;border-collapse: collapse;border-spacing: 0;display: table;width: 100%;margin-bottom: 20px;border: 1px solid #ddd;"> <tbody style="display: table-row-group;vertical-align: middle;border-color: inherit;"> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="2" width="100%" style="text-align: center;background: #00bf6f;color: white;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;font-size:20px">Transaction Details <b>'.$transact_no.'</b></td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Title</td> <td colspan="" width="80%" style="text-align: right;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$db_cat_category.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Description</td> <td colspan="" width="80%" style="text-align: right;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$description.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Link</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$tran_link.'</td> </tr> '.$customerMail.' <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Item Worth/Price</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">₦'.$price_format.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Charges bearer</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$charges.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Total Charges</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">₦'.$chrg.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Who pay the charges?</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$chrgs.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Buyer Pays</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$buyer_t_pay.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Seller Receives</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$seller_t_receives.'</td> </tr> </tbody> </table> </div> </div> <div class="footer-junk" style="background: none;padding: 20px;font-size: 12px;text-align: center;"> Copyright © Safetranzact '. $year .' All Rights Reserved </div> </div>'; /* Finally send the mail. */ //$mail->send(); if (!$mail->send()){ /* PHPMailer error. */ echo $mail->ErrorInfo; }else{ echo "<script> window.onload = function() { sweetAlert({ title: 'Congratulations', text: 'Your transaction has been created successfully', type: 'success', confirmButtonColor: '#B6EA36' }, function () { window.location.href = './'; }); }; </script>"; } } catch (Exception $e) { /* PHPMailer exception. */ echo $e->errorMessage(); } catch (\Exception $e) { /* PHP exception (note the backslash to select the global namespace Exception class). */ echo $e->getMessage(); } //$mail->ClearAllRecipients(); // //End of Second user to received email }else{ //Add user info into the database table for the main site table //include ('includes/randStrGen.php'); $reg_no = randStrGen(4); $check_ID_query = mysqli_query($con, "SELECT regNo FROM reg WHERE regNo='$reg_no'"); $i = 0; //if username exists add number to username while(mysqli_num_rows($check_ID_query) != 0) { $i++; //Add 1 to i $reg_no = $reg_no + $i; $check_ID_query = mysqli_query($con, "SELECT regNo FROM reg WHERE regNo='$reg_no'"); } /* echo "First Name ". $fname . "<br>"; echo "Last Name ". $lname . "<br>"; echo "Address ". $address . "<br>"; echo "Phone Number ". $phonenumber . "<br>"; echo "Registration Number ". $reg_gen . "<br>"; exit();*/ $sql_reg = "INSERT INTO reg(email,password,firstname,lastname,marital_status,phone_number,IDmeans,passportID,lastlogin,regNo,address,bank_acct_number,bank_acct_name,bank_name,real_pass,activation,regDate) VALUES('$email','0','$fname','$lname','0','$phonenumber','0','0',now(),'$reg_no','$address','0','0','0','0','0',now())"; $query_reg = mysqli_query($con,$sql_reg); $regid = mysqli_insert_id($con); $sql_reg_verify = "INSERT INTO account_verify(token_email,refno) VALUES('$email','$reg_no')"; $query_reg_verify = mysqli_query($con,$sql_reg_verify); //$regid = mysqli_insert_id($link); $sql_description = "INSERT INTO description(item_description,transactID) VALUES('$description','$transact_no')"; $query_description = mysqli_query($con,$sql_description); $descid = mysqli_insert_id($con); //$r_tran= $_SESSION['transID'] .$descid ; $sql = "INSERT INTO trans_tbl(transact_no,transact_date,agreement_status,mode_transactID,transact_catID,regID,descID,amount,shipcost,status,transaction_period,inspection_length,charges,amt_pay,comp_charges,transaction_link,payment_status,shipment_status,confirm_shipment,address,refno) VALUES('$transact_no',now(),'1','$mode','$cat','$user[id]','$descid','$price','0','0','0','0','$charges','0','$chrg','0','0','0','0','$address','0'), ('$transact_no',now(),'1','$mode2','$cat','$regid','$descid','$price','0','0','0','0','$charges','0','$chrg','0','0','0','0','$address','0')"; $query = mysqli_query($con,$sql); /* Sending mail to new user to update his/her password */ $encode_email = base64_encode(base64_encode($email)); $encode_reg = base64_encode(base64_encode($reg_no)); //$encode_transactiinID = base64_encode(base64_encode($_SESSION['transID'])); //$encode_parnterID = base64_encode(base64_encode($_SESSION['id'])); //$encode_modeID = base64_encode(base64_encode($mode)); $link_url="<a href=\"https://www.safetranzact.com/verify-account?token=$encode_reg\" style=\"text-decoration: none;display: inline-block;background: #00bf6f;color: white;padding: 10px 20px;border-radius: 5px;\">Review and Sign up</a>"; // echo "<br><div class=\"alert alert-info alert-dismissible\" role=\"alert\"><button type=\"button\" class=\"close\" data-dismiss=\"alert\" aria-label=\"Close\"><span aria-hidden=\"true\">×</span></button><strong>Please check your email to reset your password</strong><br>Congratulations! $email <br>A request has been successful to reset your account password check your mail to reset your password.<br><br>if you are using offline mode, click on the below link to continue<br> //$link_url = "<a href=\"http://localhost/parcel%20tracking/one-pages/accounting/verify-account?token=$encode_email\" target=\"_blank\">Review and Sign up</a>"; //$link_url = "http://localhost/parcel%20tracking/one-pages/accounting/verify-account?token=$encode_email"; //First user non register $full_name = $fname . " " . $lname; $fullname = $user["firstname"] . " ". $user["lastname"]; /* Create a new PHPMailer object. Passing TRUE to the constructor enables exceptions. */ $mail = new PHPMailer(TRUE); /* Open the try/catch block. */ try { /* Set the mail sender. */ $mail->setFrom('no-reply@me.com', 'Mecom'); /* Add a recipient. */ $mail->addAddress("$email", "$full_name"); /* Set the subject. */ $mail->Subject = 'Account/Transaction Verification'; $mail->isHTML(TRUE); /* Set the mail message body. */ $mail->Body = '<div class="email-background" style="background: #eee;padding: 10px;"> <a href="https://www.safetranzact.com"><center><img src="https://www.safetranzact.com/assets/images/fav.png" style="padding-top:30px;padding-bottom:30px;max-width:100px;height:100px;margin: 0 auto;"></center><a> <div class="email-container" style="max-width: 500px;background: white;font-family: san-serif;margin: 0 auto;overflow: hidden;border-radius: 5px;text-align: center;"> <p style="margin: 20px;font-size: 12px;font-weight: 300;color: #666;line-height: 1.5;text-align:left"> Dear <b>' . $full_name. ',</b><br/>We believe there is an agreement between you and <b>'. $fullname .'</b> for a transaction. And we noticed that you have not yet signed up; Please Sign up and see the details of the transaction below</p> <div class="table table-responsive" style="margin-left: 10px;margin-right: 10px;"> <table class="table table-striped table-bordered" style="max-width: 100%;background-color: transparent;border-collapse: collapse;border-spacing: 0;display: table;width: 100%;margin-bottom: 20px;border: 1px solid #ddd;"> <tbody style="display: table-row-group;vertical-align: middle;border-color: inherit;"> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="2" width="100%" style="text-align: center;background: #00bf6f;color: white;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;font-size:20px">Transaction Details <b>'.$transact_no.'</b></td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Title</td> <td colspan="" width="80%" style="text-align: right;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$db_cat_category.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Description</td> <td colspan="" width="80%" style="text-align: right;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$description.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Link</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$tran_link.'</td> </tr> '.$customerMail.' <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Item Worth/Price</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">₦'.$price_format.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Charges bearer</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$charges.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Total Charges</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">₦'.$chrg.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Who pay the charges?</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$chrgs.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Buyer Pays</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$buyer_t_pay.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Seller Receives</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$seller_t_receives.'</td> </tr> </tbody> <tfoot> <tr> <td colspan="2">'.$link_url.'</td> </tr> </tfoot> </table> </div> </div> <div class="footer-junk" style="background: none;padding: 20px;font-size: 12px;text-align: center;"> Copyright © Safetranzact '. $year .' All Rights Reserved </div> </div>'; /* Finally send the mail. */ //$mail->send(); if (!$mail->send()){ /* PHPMailer error. */ echo $mail->ErrorInfo; }else{ $output ="<div class=\"alert alert-success\">Transaction has been created successfully</div>"; } } catch (Exception $e) { /* PHPMailer exception. */ echo $e->errorMessage(); } catch (\Exception $e) { /* PHP exception (note the backslash to select the global namespace Exception class). */ echo $e->getMessage(); } //End of first user non register //Second user register // $fullname = $user["firstname"] . " " . $user["lastname"]; $full_name = $fname . " " . $lname; $year = date('Y'); /* Create a new PHPMailer object. Passing TRUE to the constructor enables exceptions. */ $mail = new PHPMailer(TRUE); /* Open the try/catch block. */ try { /* Set the mail sender. */ $mail->setFrom('no-reply@me.com', 'Mecom'); /* Add a recipient. */ $mail->addAddress("$dbemail", "$fullname"); /* Set the subject. */ $mail->Subject = 'Transaction Created Successfully'; $mail->isHTML(TRUE); /* Set the mail message body. */ $mail->Body = '<div class="email-background" style="background: #eee;padding: 10px;"> <a href=""><center><img src="" style="padding-top:30px;padding-bottom:30px;max-width:100px;height:100px;margin: 0 auto;"></center><a> <div class="email-container" style="max-width: 500px;background: white;font-family: san-serif;margin: 0 auto;overflow: hidden;border-radius: 5px;text-align: center;"> <p style="margin: 20px;font-size: 12px;font-weight: 300;color: #666;line-height: 1.5;text-align:left"> Dear ' . $fullname . ',<br/>You just initiated a transaction with title <b>'. $cat_category .'</b> and description <b>'. $description .' to <b>'. $full_name .'</b> Below is the details of the transaction</p> <div class="table table-responsive" style="margin-left: 10px;margin-right: 10px;"> <table class="table table-striped table-bordered" style="max-width: 100%;background-color: transparent;border-collapse: collapse;border-spacing: 0;display: table;width: 100%;margin-bottom: 20px;border: 1px solid #ddd;"> <tbody style="display: table-row-group;vertical-align: middle;border-color: inherit;"> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="2" width="100%" style="text-align: center;background: #00bf6f;color: white;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;font-size:20px">Transaction Details <b>'.$transact_no.'</b></td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Title</td> <td colspan="" width="80%" style="text-align: right;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$db_cat_category.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Description</td> <td colspan="" width="80%" style="text-align: right;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$description.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Link</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$tran_link.'</td> </tr> '.$customerMail.' <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Item Worth/Price</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">₦'.$price_format.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Charges bearer</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$charges.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Total Charges</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">₦'.$chrg.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Who pay the charges?</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$chrgs.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Buyer Pays</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$buyer_t_pay.'</td> </tr> <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Seller Receives</td> <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$seller_t_receives.'</td> </tr> </tbody> </table> </div> </div> <div class="footer-junk" style="background: none;padding: 20px;font-size: 12px;text-align: center;"> Copyright © Mecom'. $year .' All Rights Reserved </div> </div>'; /* Finally send the mail. */ //$mail->send(); if (!$mail->send()){ /* PHPMailer error. */ echo $mail->ErrorInfo; }else{ echo "<script> window.onload = function() { sweetAlert({ title: 'Congratulations', text: 'Your transaction has been created successfully', type: 'success', confirmButtonColor: '#B6EA36' }, function () { window.location.href = './'; }); }; </script>"; } } catch (Exception $e) { /* PHPMailer exception. */ echo $e->errorMessage(); } catch (\Exception $e) { /* PHP exception (note the backslash to select the global namespace Exception class). */ echo $e->getMessage(); } // //End of second user register } } With this the second party got the two mail Edited January 28, 2021 by requinix please use the Code <> button when posting code Quote Link to comment https://forums.phpfreaks.com/topic/312061-how-to-send-multiples-email-to-user-on-a-transaction-initiation/ Share on other sites More sharing options...
requinix Posted January 28, 2021 Share Posted January 28, 2021 What's your question? If there's a way to not have to copy and paste so much code? Quote Link to comment https://forums.phpfreaks.com/topic/312061-how-to-send-multiples-email-to-user-on-a-transaction-initiation/#findComment-1584064 Share on other sites More sharing options...
Ponel Posted January 29, 2021 Author Share Posted January 29, 2021 (edited) Thank you sir, I'm trying sending multiples email to user using phpmailer first condition////////////////////////////////////******************************************* //First User email $mail = new PHPMailer(TRUE); try { $mail->setFrom('no-reply@me.com', 'Mecom'); $mail->addAddress("$email_firstuser", "$full_name"); $mail->Subject = 'Transaction Created Successfully'; $mail->isHTML(TRUE); $mail->Body = 'Message to first User'; if (!$mail->send()){ echo $mail->ErrorInfo; }else{ echo "sent"; } } catch (Exception $e) { echo $e->errorMessage(); } catch (\Exception $e) { echo $e->getMessage(); } // //End of First User //Second user mail $mail = new PHPMailer(TRUE); try { $mail->setFrom('no-reply@me.com', 'Mecom'); $mail->addAddress("$email_seconduser", "$full_name"); $mail->Subject = 'Transaction Created Successfully'; $mail->isHTML(TRUE); $mail->Body = 'Message to Second User'; if (!$mail->send()){ echo $mail->ErrorInfo; }else{ echo "sent"; } } catch (Exception $e) { echo $e->errorMessage(); } catch (\Exception $e) { echo $e->getMessage(); } // //End of second user mail End of first condition////////////////////////////////////******************************************* Note: I have like four kind of conditions for this Thanks Edited January 29, 2021 by Ponel Quote Link to comment https://forums.phpfreaks.com/topic/312061-how-to-send-multiples-email-to-user-on-a-transaction-initiation/#findComment-1584099 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.