Ponel

I've sent the data to your mail sir @barand

@Barand @All help me out This is my code $sql_mee ="SELECT yearid , semesterid , regno , subjectid , rank , total , grade , comment FROM ( SELECT yearid , semesterid , subjectid , @seq := CASE WHEN yss <> @prev THEN 1 ELSE @seq + 1 END as seq , @rank := CASE WHEN total = @prevtot THEN @rank ELSE @seq END as rank , @prevtot := total as total , @prev := yss as yss , regno , armsLevelId -- added FROM ( SELECT yearid , semesterid , subjectid , concat(yearid, armsLevelId, semesterid, subjectid) as yss , regno , total , armsLevelId -- added FROM subject_position ORDER BY yearid, armsLevelId, semesterid, subjectid, total DESC ) sorted JOIN (SELECT @prev := '', @seq := 0, @rank := 0, @prevtot := 0) as init ) ranked JOIN grade ON total BETWEEN grade.lomark AND grade.himark WHERE regNo='$_GET[name]' -- A and armsLevelId='$levelid' -- D and semesterid='$sem' -- E and yearid='$odun' -- D ORDER BY subjectid"; $query_mee = mysqli_query($con, $sql_mee); $data_sub_pos = array(); while($row_mee = mysqli_fetch_array($query_mee)){ $yearid_me = $row_mee["yearid"]; $semesterid_me = $row_mee["semesterid"]; $regNo_me = $row_mee["regNo"]; $subjectid_me = $row_mee["subjectid"]; $rank_me = $row_mee["rank"]; $total_me = $row_mee["total"]; $grade_me = $row_mee["grade"]; $data_sub_pos[] = $rank_me; } /*End of Subject Position Ranking*/ $sql = "select * from dummy where regid='$regno' and armsLevelId='$levelid' and yearid='$odun' and semesterid='$sem' group by subjectid"; $result = mysqli_query($con,$sql); while ($row_query=mysqli_fetch_array($result)){ $RegNo=$row_query["regid"]; $subject_id=$row_query["subjectid"]; $level_id=$row_query["armsLevelId"]; $semester=$row_query["semesterid"]; $session=$row_query["yearid"]; $fca=$row_query["firstCA"]; $sca=$row_query["secondCA"]; $exam=$row_query["exam"]; $total =$row_query["total"]; $grade =$row_query["grade"]; $comment =$row_query["comment"]; //subject $query_sub=mysqli_query($con,"select * from subject where id='".$subject_id."'"); while ($row_sub=mysqli_fetch_array($query_sub)){ $r_sub = $row_sub["subject_name"]; } //level $query_level=mysqli_query($con,"select * from armslevel where id='".$level_id."'"); while ($row_level=mysqli_fetch_array($query_level)){ $r_level = $row_level["Armslevel"]; } //semester $query_semester=mysqli_query($con,"select * from semester where id='".$semester."'"); while ($row_semester=mysqli_fetch_array($query_semester)){ $r_semester = $row_semester["term"]; } //session $query_year=mysqli_query($con,"select * from year where id='".$session."'"); while ($row_year=mysqli_fetch_array($query_year)){ $r_year = $row_year["session"]; } //student details $query_reg=mysqli_query($con,"select * from promotion where regNo='".$RegNo."'"); while ($row_reg=mysqli_fetch_array($query_reg)){ $reg_ID = $row_reg["id"]; $reg_title = $row_reg["title"]; $reg_Regno = $row_reg["regNo"]; $reg_firstName = $row_reg["firstname"]; $reg_middleName = $row_reg["middleName"]; $reg_lastName = $row_reg["lastName"]; $reg_gender = $row_reg["gender"]; $reg_houseID = $row_reg["houseid"]; $reg_profile_pic = $row_reg["passport"]; $reg_level_id=$row_reg["armslevelid"]; $reg_semester=$row_reg["semesterid"]; $reg_session=$row_reg["yearid"]; $reg_nationality=$row_reg["nationality"]; $reg_stateID=$row_reg["stateID"]; $reg_localgovtID=$row_reg["localgovtID"]; $reg_phone=$row_reg["phone"]; $reg_email=$row_reg["email"]; $reg_signup_date=$row_reg["signup_date"]; // $reg_status=$row_reg["status"]; //echo "select * from promotion where regNo='".$RegNo."' and armslevelid='$level_id' and arms='$arms' and yearid='$session'"; } for ($pos=0; $pos<count($data_sub_pos); $pos++) { if(!empty($data_sub_pos[$pos])){ $position = $data_sub_pos[$pos]; $position = $position; }else{ echo "Error Occured"; } } $outputdata .="<tr> <td>$sn</td> <td>$r_sub</td> <td>$fca</td> <td>$sca</td> <td>$exam</td> <td>$total</td> <td>$position</td> <td>$grade</td> <td>$comment</td> </tr>"; $sn++; } Note: the position column is populating the last data. the position column should populate 1st, 8th, 7th, 3rd the last data (3rd is populated). thanks for your help in advance.

Thanks it worked My Query $sql_referrals_bonus = mysqli_query($con, "select transaction_tbl.amount_deposited, transaction_tbl.userID trans_userID, referal_tbl.userID ref_userID, referal_tbl.referalID ref_referalID from transaction_tbl, referal_tbl where referal_tbl.referalID='$user[id]' and transaction_tbl.userID=referal_tbl.userID GROUP by transaction_tbl.userID"); $result_row_referral = mysqli_num_rows($sql_referrals_bonus); $row_fetch= mysqli_fetch_row($sql_referrals_bonus); if ($result_row_referral>0){ foreach($sql_referrals_bonus as $sub_referral){ $total_bonus += $sub_referral["amount_deposited"]; } $total_bonus = "$".(0.05 * $total_bonus); }else{ $total_bonus = "$"."0".".00"; }

Ok sir. I will check that out and post my output. Thanks 🙏🙏

Good day sirs, Please help me on the challenges I'm facing.. I have two tables "transaction_tbl" and "referal_tbl". What I wanted to do is to check the Transaction_tbl referal_tbl this my code select transaction_tbl.amount_deposited, transaction_tbl.userID trans_userID, referal_tbl.userID ref_userID, referal_tbl.referalID ref_referalID from transaction_tbl, referal_tbl where referal_tbl.referalID='1' and transaction_tbl.userID=referal_tbl.userID GROUP by transaction_tbl.userID My Output I wanted to sum amount_deposited column so i will get 1,240 and get the 5% of 1240 which is 62 My Query $sql_referrals_bonus = mysqli_query($con, "select transaction_tbl.amount_deposited, transaction_tbl.userID trans_userID, referal_tbl.userID ref_userID, referal_tbl.referalID ref_referalID from transaction_tbl, referal_tbl where referal_tbl.referalID='$user[id]' and transaction_tbl.userID=referal_tbl.userID GROUP by transaction_tbl.userID"); $result_row_referral = mysqli_num_rows($sql_referrals_bonus); $row_fetch= mysqli_fetch_row($sql_referrals_bonus); if ($result_row_referral>0){ foreach($sql_referrals_bonus as $sub_referral){ //$total_bonus += $row_fetch[0]; //$total_bonus = $row_fetch[0]; $total_bonus = $sub_referral["amount_deposited"]; $total_bonus = "$".(0.05 * $total_bonus); //$total_bonus = "$".number_format("$total_bonus", 0, '', ',').".00"; } }else{ $total_bonus = "$"."0".".00"; } so i got 30 instead of 62 Note the 30 is the 5% of 600. Please any help on this sirs?

PHP date and time function is not showing correct time on my local system I have the following php code date_default_timezone_set("Africa/Lagos"); $date = date('d-m-y h:i:s'); echo "Server Time ".$date ."<br>"; echo "The time is " . date("h:i:sa")."<br>"; $current_datetime = date("Y-m-d") . ' ' . date("H:i:s", STRTOTIME(date('h:i:sa'))); echo "Current time1: ".$current_datetime . "<br>"; Output Server Time 21-05-21 09:55:39 The time is 09:55:39am Current time1: 2021-05-21 09:55:39 Expected Output Server Time 21-05-21 10:55:39 The time is 10:55:39am Current time1: 2021-05-21 10:55:3 Any help would be appreciated.

Five 🌟 🌟 🌟 🌟 🌟 for Barand

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

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;">&#x20A6;'.$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;">&#x20A6;'.$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 &copy; 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;">&#x20A6;'.$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;">&#x20A6;'.$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 &copy; 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;">&#x20A6;'.$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;">&#x20A6;'.$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 &copy; 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;">&#x20A6;'.$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;">&#x20A6;'.$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 &copy; 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;">&#x20A6;'.$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;">&#x20A6;'.$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 &copy; 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;">&#x20A6;'.$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;">&#x20A6;'.$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 &copy; 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\">&times;</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;">&#x20A6;'.$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;">&#x20A6;'.$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 &copy; 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;">&#x20A6;'.$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;">&#x20A6;'.$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 &copy; 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

https://ravemodal-dev.herokuapp.com/hosted/redirect-payment?flwref=FLW-MOCK-ba043ffda2fad8a96ddd82b6c2a3dc5a&txref=996419 txref=996419 from the link is auto generated reference number

redirect is a page to redirect to after successful payment

Good afternoon everyone, Please I’m trying to integrate a rave pay payment gateway and i’m getting this below error on making payment Error: Cannot POST /hosted/redirect My redirect page code (redirect.php) <?php //session_start(); include 'includes/global/login_handler.php'; include 'includes/global/randStrGen.php'; if (isset($_GET['txref']) && isset($_SESSION["amount_to_pay"]) && isset($_SESSION["txtrefno"]) && isset($_SESSION["transact_no"]) && isset($_SESSION["buyer_email"]) && isset($_SESSION["buyer_name"]) && isset($_SESSION["seller_email"]) && isset($_SESSION["seller_name"])) { //my own variable declaration $buyer_t_pay_ =$_SESSION["amount_to_pay"]; $txtrefno =$_SESSION["txtrefno"]; $transact_no =$_SESSION['transact_no']; $buyer_email =$_SESSION['buyer_email']; $buyer_name =$_SESSION['buyer_name']; $seller_email =$_SESSION['seller_email']; $seller_name =$_SESSION['seller_name']; $category=$_SESSION['category']; $description=$_SESSION['description']; //end of my variable declaration $ref = $_GET['txref']; $amount = $_SESSION["amount_to_pay"]; //Correct Amount from Server $currency = "NGN"; //Correct Currency from Server $query = array( "SECKEY" => "2fsghddjk", "txref" => $ref ); $data_string = json_encode($query); $ch = curl_init('https://api.ravepay.co/flwv3-pug/getpaidx/api/v2/verify'); curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST"); curl_setopt($ch, CURLOPT_POSTFIELDS, $data_string); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: application/json')); $response = curl_exec($ch); $header_size = curl_getinfo($ch, CURLINFO_HEADER_SIZE); $header = substr($response, 0, $header_size); $body = substr($response, $header_size); curl_close($ch); $resp = json_decode($response, true); $paymentStatus = $resp['data']['status']; $chargeResponsecode = $resp['data']['chargecode']; $chargeAmount = $resp['data']['amount']; $chargeCurrency = $resp['data']['currency']; if (($chargeResponsecode == "00" || $chargeResponsecode == "0") && ($chargeAmount == $amount) && ($chargeCurrency == $currency)) { // transaction was successful... // please check other things like whether you already gave value for this ref // if the email matches the customer who owns the product etc //Give Value and return to Success page //header( "refresh:4;url=./success.php" ); $sql_payment ="insert into payment_history (transactID,amountPaid,transMode,refno) values('$transact_no','$buyer_t_pay_','1','$txtrefno')"; $payment_query = mysqli_query($con,$sql_payment); $payment_id = mysqli_insert_id($con); $sql_trans ="update trans_tbl set amt_pay='$buyer_t_pay_', payment_status='1', refno='$txtrefno' where transact_no='$transact_no'"; $transact_query = mysqli_query($con,$sql_trans); if ($transact_query && $payment_query){ $year = date('Y'); //send email to the buyer $to = $buyer_email; $from = "info@safetranzact.com"; $subject = "Payment Successful"; $message ='<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;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: 20px;font-weight: bold;color: #002b49;line-height: 20px;text-align:center;word-break: normal;font-family: Helvetica,Arial,sans-serif;margin-left: 10px;margin-right: 10px;">Your payment to the item with transaction No: '. $transact_no .' of '.$category. ' has been confirmed<br/></p><hr> <p style="font-size: 14px;font-weight: bold;color: #002b49;text-align:left;margin-left: 10px;margin-right: 10px;line-height: 12px;"> Dear ' . $buyer_name. ',</p><br> <p style="font-size: 14px;font-weight: normal;color: #002b49;text-align:left;margin-left: 10px;margin-right: 10px;line-height: 20px;">Thanks for choosing Safetranzact. Your payment of transaction No <b>'. $transact_no . ' </b> of category <b> '. $category . '</b> with description <b>'.$description.'</b> is being processed. <br> If you have any comments about this transaction, please reach out to us at info@safetranzact.com</p> </div> </div> <div class="footer-junk" style="background: none;padding: 20px;font-size: 12px;text-align: center;"> Copyright &copy; Safetranzact Limited '. $year .' All Rights Reserved </div> </div>'; $headers = "From:$from\n"; $headers.="MINE-version:1.0\n"; $headers.="content-type:text/html; charset=iso-8859-1\n"; $mailing = mail($to,$subject,$message,$headers); //send email to the seller $to = $sender_email; $from = "info@safetranzact.com"; $subject = "Payment Successful"; $message ='<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;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: 20px;font-weight: bold;color: #002b49;line-height: 20px;text-align:center;word-break: normal;font-family: Helvetica,Arial,sans-serif;margin-left: 10px;margin-right: 10px;">Your payment to the item with transaction No: '. $transact_no .' of '.$category. ' has been confirmed<br/></p><hr> <p style="font-size: 14px;font-weight: bold;color: #002b49;text-align:left;margin-left: 10px;margin-right: 10px;line-height: 12px;"> Dear ' . $sender_name. ',</p><br> <p style="font-size: 14px;font-weight: normal;color: #002b49;text-align:left;margin-left: 10px;margin-right: 10px;line-height: 20px;">Thanks for choosing Safetranzact. We got a payment of transaction No <b>'. $transact_no . ' </b> of category <b> '. $category . '</b> with description <b>'.$description.'</b> from buyer <b>('.$buyer_name.')</b> .<br> Please ship the item now and log in to your dashboard to upload the shippment proof. <br>If you have any comments about this transaction, please reach out to us at info@safetranzact.com</p> </div> </div> <div class="footer-junk" style="background: none;padding: 20px;font-size: 12px;text-align: center;"> Copyright &copy; Safetranzact Limited '. $year .' All Rights Reserved </div> </div>'; $headers = "From:$from\n"; $headers.="MINE-version:1.0\n"; $headers.="content-type:text/html; charset=iso-8859-1\n"; $mailing = mail($to,$subject,$message,$headers); header( "refresh:3;url=./success" ); }else{ } } else { //Dont Give Value and return to Failure page header( "refresh:3;url=./failure" ); } } else { die('No reference supplied'); } ?> Please any help on this

It worked. Thank you sir

Ok sir I willl check that out

yeah that's for overall position for class. I'm talking of the subject position in the column. With this SELECT yearid , semesterid , regno , subjectid , rank , total , grade , comment FROM ( SELECT yearid , semesterid , subjectid , @seq := CASE WHEN yss <> @prev THEN 1 ELSE @seq + 1 END as seq , @rank := CASE WHEN total = @prevtot THEN @rank ELSE @seq END as rank , @prevtot := total as total , @prev := yss as yss , regno , armsLevelId -- added , armsid -- added FROM ( SELECT yearid , semesterid , subjectid , concat(yearid, semesterid, subjectid) as yss , regno , total , armsLevelId -- added , armsid -- added FROM subject_position ORDER BY yearid, semesterid, subjectid, total DESC ) sorted JOIN (SELECT @prev := '', @seq := 0, @rank := 0, @prevtot := 0) as init ) ranked JOIN grade ON total BETWEEN grade.lomark AND grade.himark WHERE regNo='$_GET[name]' -- A and armsLevelId='$_SESSION[level_id]' -- D and armsId='$_SESSION[arms]' -- D and semesterid='$_SESSION[semester]' -- E and yearid='$_SESSION[session]' -- D ORDER BY subjectid