Learn VBA & Macros in 1 Week!

PHP - Send Email With Fetched Data Information To Different User After Selecting Checkbox

Full Excel VBA Course - Beginner to Expert

Send Email With Fetched Data Information To Different User After Selecting Checkbox	View Content

Full Excel VBA Course - Beginner to Expert

Getting User Information Into Database And Send Activation Email Script Here!

Similar Tutorials

View Content

This script works well as far as getting the form information onto the database but for some reason the confirmation email is not being sent to the user.

Could someone take a quick look at my script? Please? I've attached the included files as well. I guess I just need another set of eyes to look over this script. It would be much appreciated

<?php
// Created BY Adam Khoury @ www.developphp.com

// let's initialize vars to be printed to page in the HTML section so our script does not return errors
// they must be initialized in some server environments
$errorMsg = "";
$firstname = "";
$lastname = "";
$country = "";
$state = "";
$city = "";
$zip = "";
$website = "";
$youtube = "";
$email1 = "";
$email2 = "";
$pass1 = "";
$pass2 = "";

// This code runs only if the form submit button is pressed
if (isset ($_POST['firstname'])){

   /* Example of cleaning variables in a loop
   $vars = "";
   foreach ($_POST as $key => $value) {
$value = stripslashes($value);
$vars .= "$key = $value<br />";
}
print "$vars";
exit();
   */
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$country = $_POST['country'];
$state = $_POST['state'];
$city = $_POST['city'];
$zip = $_POST['zip'];
$website = $_POST['website'];
$youtube = $_POST['youtube'];
$email1 = $_POST['email1'];
$email2 = $_POST['email2'];
$pass1 = $_POST['pass1'];
$pass2 = $_POST['pass2'];
$humancheck = $_POST['humancheck'];

$firstname = stripslashes($firstname);
$lastname = stripslashes($lastname);
$state = stripslashes($state);
$city = stripslashes($city);
$zip = stripslashes($zip);
$website = stripslashes($website);
$youtube = stripslashes($youtube);
$email1 = stripslashes($email1);
$pass1 = stripslashes($pass1);
$email2 = stripslashes($email2);
$pass2 = stripslashes($pass2);

$firstname = strip_tags($firstname);
    $lastname = strip_tags($lastname);
$state = strip_tags($state);
$city = strip_tags($city);
    $zip = strip_tags($zip);
$website = strip_tags($website);
$youtube = strip_tags($youtube);
$email1 = strip_tags($email1);
$pass1 = strip_tags($pass1);
$email2 = strip_tags($email2);
$pass2 = strip_tags($pass2);

// Connect to database
include_once "connect_to_mysql.php";
$emailCHecker = mysql_real_escape_string($email1);
    $emailCHecker = eregi_replace("`", "", $emailCHecker);
// Database duplicate e-mail check setup for use below in the error handling if else conditionals

mysql_select_db("perry100_users", $myConnection);

$sql_email_check = mysql_query("SELECT email FROM myMembers WHERE email='$emailCHecker'", $myConnection);
    $email_check = mysql_num_rows($sql_email_check);// or die(mysql_error());


// Error handling for missing data
if ((!$firstname) || (!$lastname) || (!$country) || (!$state) || (!$city) || (!$zip) || (!$email1) || (!$email2) || (!$pass1) || (!$pass2)) {

$errorMsg = 'ERROR: You did not submit the following required information:<br /><br />';

if(!$firstname){
$errorMsg .= ' * First Name<br />';
}
    if(!$lastname){
$errorMsg .= ' * Last Name<br />';
}
if(!$country){
$errorMsg .= ' * Country<br />';
}
    if(!$state){
$errorMsg .= ' * State or Provice<br />';
}
    if(!$city){
$errorMsg .= ' * City<br />';
}
    if(!$zip){
$errorMsg .= ' * Postal or Zip Code<br />';
}
    if(!$email1){
$errorMsg .= ' * Email Address<br />';
}
    if(!$email2){
$errorMsg .= ' * Confirm Email Address<br />';
}
    if(!$pass1){
$errorMsg .= ' * Login Password<br />';
}
    if(!$pass2){
$errorMsg .= ' * Confirm Login Password<br />';
}

} else if ($email1 != $email2) {
$errorMsg = 'ERROR: Your Email fields below do not match<br />';
} else if ($pass1 != $pass2) {
$errorMsg = 'ERROR: Your Password fields below do not match<br />';
} else if ($humancheck != "") {
$errorMsg = 'ERROR: The Human Check field must be cleared to be sure you are human<br />';
} else if ($email_check > 0){
$errorMsg = "<u>ERROR:</u><br />Your Email address is already in use inside our database. Please use another.<br />";

} else { // Error handling is ended, process the data and add member to database
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

    $firstname = mysql_real_escape_string($firstname);
    $lastname = mysql_real_escape_string($lastname);
$state = mysql_real_escape_string($state);
$city = mysql_real_escape_string($city);
    $zip = mysql_real_escape_string($zip);
$website = mysql_real_escape_string($website);
    $youtube = mysql_real_escape_string($youtube);
$email1 = mysql_real_escape_string($email1);
$pass1 = mysql_real_escape_string($pass1);

    $firstname = eregi_replace("`", "", $firstname);
    $lastname = eregi_replace("`", "", $lastname);
    $state = eregi_replace("`", "", $state);
    $city = eregi_replace("`", "", $city);
    $zip = eregi_replace("`", "", $zip);
    $website = eregi_replace("`", "", $website);
    $youtube = eregi_replace("`", "", $youtube);
    $email1 = eregi_replace("`", "", $email1);
    $pass1 = eregi_replace("`", "", $pass1);

$website = eregi_replace("http://", "", $website);
    $youtube = eregi_replace("http://www.youtube.com/user/", "", $youtube);

// Add MD5 Hash to the password variable
$db_password = md5($pass1);

// Add user info into the database table for the main site table(knirv.com)
$sql = mysql_query("INSERT INTO myMembers (firstname, lastname, country, state, city, zip, email, password, sign_up_date, website, youtube)
VALUES('$firstname','$lastname','$country','$state','$city','$zip','$email1','$db_password', now(),'$website','$youtube')")
or die (mysql_error());

$id = mysql_insert_id();

    // Create directory(folder) to hold each user's files(pics, MP3s, etc.)
mkdir("members/$id", 0755);

//!!!!!!!!!!!!!!!!!!!!!!!!! Email User the activation link !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
$myemail = "admin@knirv.com";
$emess = "First Name: $firstname\n";
$emess.= "Last Name: $lastname\n";
$emess.= "Email 1: $email1\n";
$emess.= "Email 2: $email2\n";
$emess.= "City: $city\nState: $state\nZip/Post Code:$zip\n";
$emess.= "Country: $scountry\n";
$emess.= "Phone number 1: $phone1\n";
$emess.= "Phone number 2: $phone2\n";
$emess.= "Phone number 3: $phone3\n";
$emess.= "Comments: $sendmail";
$ehead = "From: $myemail\r\n";
$subj = "Complete knirv.com registration!";
$mailsend=mail("$myemail","$subj","$emess","$ehead");
//Begin HTML Email Message
$message = "Hi $firstname,

Complete this step to activate your login identity at knirv.com.

Click the line below to activate when ready.

http://www.knirv.com/activation.php?id=$id&sequence=$db_password
If the URL above is not an active link, please copy and paste it into your browser address bar

Login after successful activation using your:
E-mail Address: $email
Password: $password

See you on the site!
admin@knirv.com";
//end of message
unset($_GET['do']);

header("Location: thank_you.php");
break;

}

$msgToUser = "<h2>One Last Step - Activate through Email</h2><h4>OK $firstname, one last step to verify your email identity:</h4><br />
In a moment you will be sent an Activation link to your email address.<br /><br />
<br />
<strong><font color=\"#990000\">VERY IMPORTANT:</font></strong>
If you check your email with your host providers default email application, there may be issues with seeing the email contents. If this happens to you and you cannot read the message to activate, download the file and open using a text editor. If you still cannot see the activation link, contact site admin and briefly discuss the issue.<br /><br />
";

include_once 'msgToUser.php';

exit();

} // Close else after duplication checks

else { // if the form is not posted with variables, place default empty variables

     $errorMsg = "Fields marked with an [ * ] are required";
$firstname = "";
     $lastname = "";
     $country = "";
     $state = "";
     $city = "";
     $zip = "";
     $website = "";
     $youtube = "";
     $email1 = "";
     $email2 = "";
     $pass1 = "";
     $pass2 = "";
}

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta name="Kinetic Network" content="Register to knirv.com" />
<meta name="Knirv Registration" content="register, www.knirv.com" />
<meta name="rating" content="General" />
<title>Register Your Account</title>
<link rel="icon" href="favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="favicon.ico" type="image/x-icon" />
<style type="text/css">

</style>
<link href="CSS/site_layout.css" rel="stylesheet" type="text/css" />
</head>

<body>
<?php include_once "header_template.php";
if ($message)
echo "<p>$message</p>";
?>
<table width="950" align="center">
<tr>
<td width="758">
<blockquote>
<h2><br />
Create Your Account Below </h2>
</blockquote>
<table width="600" align="center" cellpadding="5">
<form action="register.php" method="post" enctype="multipart/form-data">
<tr>
<td width="125" class="style7"><div align="center"><strong>Please Do First →</strong></div></td>
<td width="447" bgcolor="#FFFFFF">Add <a href="mailto:admin@yknirv.com"><u>admin@knirv.com</u></a> to your email white list or safe sender list now, or else you might not get the activation email that is necessary for logging in successfully. </td>
</tr>
<tr>
<td colspan="2"><font color="#FF0000"><?php print "$errorMsg"; ?></font></td>
</tr>
<tr>
<td align="right" class="alignRt">First Name:<span class="brightRed"> *</span></td>
<td><input name="firstname" type="text" class="formFields" id="firstname" value="<?php print "$firstname"; ?>" size="32" maxlength="20" /></td>
</tr>
<tr>
<td align="right" class="alignRt">Last Name:<span class="brightRed"> *</span></td>
<td><input name="lastname" type="text" class="formFields" id="lastname" value="<?php print "$lastname"; ?>" size="32" maxlength="20" /></td>
</tr>
<tr>
<td align="right" class="alignRt">Country:<span class="brightRed"> *</span></td>
<td>
<select name="country" class="formFields">
<option value="<?php print "$country"; ?>"><?php print "$country"; ?></option>
<option value="United States of America">United States of America</option>
<option value="Afghanistan">Afghanistan</option>
<option value="Albania">Albania</option>
<option value="Algeria">Algeria</option>
<option value="American Samoa">American Samoa</option>
<option value="Andorra">Andorra</option>
<option value="Angola">Angola</option>
<option value="Anguilla">Anguilla</option>
<option value="Antigua and Barbuda">Antigua and Barbuda</option>
<option value="Argentina">Argentina</option>
<option value="Armenia">Armenia</option>
<option value="Aruba">Aruba</option>
<option value="Australia">Australia</option>
<option value="Austria">Austria</option>
<option value="Azerbaijan">Azerbaijan</option>
<option value="Bahamas">Bahamas</option>
<option value="Bahrain">Bahrain</option>
<option value="Bangladesh">Bangladesh</option>
<option value="Barbados">Barbados</option>
<option value="Belarus">Belarus</option>
<option value="Belgium">Belgium</option>
<option value="Belize">Belize</option>
<option value="Benin">Benin</option>
<option value="Bermuda">Bermuda</option>
<option value="Bhutan">Bhutan</option>
<option value="Bolivia">Bolivia</option>
<option value="Bonaire">Bonaire</option>
<option value="Bosnia and Herzegovina">Bosnia and Herzegovina</option>
<option value="Botswana">Botswana</option>
<option value="Brazil">Brazil</option>
<option value="British Indian Ocean Ter">British Indian Ocean Ter</option>
<option value="Brunei">Brunei</option>
<option value="Bulgaria">Bulgaria</option>
<option value="Burkina Faso">Burkina Faso</option>
<option value="Burundi">Burundi</option>
<option value="Cambodia">Cambodia</option>
<option value="Cameroon">Cameroon</option>
<option value="Canada">Canada</option>
<option value="Canary Islands">Canary Islands</option>
<option value="Cape Verde">Cape Verde</option>
<option value="Cayman Islands">Cayman Islands</option>
<option value="Central African Republic">Central African Republic</option>
<option value="Chad">Chad</option>
<option value="Channel Islands">Channel Islands</option>
<option value="Chile">Chile</option>
<option value="China">China</option>
<option value="Christmas Island">Christmas Island</option>
<option value="Cocos Island">Cocos Island</option>
<option value="Columbia">Columbia</option>
<option value="Comoros">Comoros</option>
<option value="Congo">Congo</option>
<option value="Cook Islands">Cook Islands</option>
<option value="Costa Rica">Costa Rica</option>
<option value="Cote D'Ivoire">Cote D'Ivoire</option>
<option value="Croatia">Croatia</option>
<option value="Cuba">Cuba</option>
<option value="Curacao">Curacao</option>
<option value="Cyprus">Cyprus</option>
<option value="Czech Republic">Czech Republic</option>
<option value="Denmark">Denmark</option>
<option value="Djibouti">Djibouti</option>
<option value="Dominica">Dominica</option>
<option value="Dominican Republic">Dominican Republic</option>
<option value="East Timor">East Timor</option>
<option value="Ecuador">Ecuador</option>
<option value="Egypt">Egypt</option>
<option value="El Salvador">El Salvador</option>
<option value="Equatorial Guinea">Equatorial Guinea</option>
<option value="Eritrea">Eritrea</option>
<option value="Estonia">Estonia</option>
<option value="Ethiopia">Ethiopia</option>
<option value="Falkland Islands">Falkland Islands</option>
<option value="Faroe Islands">Faroe Islands</option>
<option value="Fiji">Fiji</option>
<option value="Finland">Finland</option>
<option value="France">France</option>
<option value="French Guiana">French Guiana</option>
<option value="French Polynesia">French Polynesia</option>
<option value="French Southern Ter">French Southern Ter</option>
<option value="Gabon">Gabon</option>
<option value="Gambia">Gambia</option>
<option value="Georgia">Georgia</option>
<option value="Germany">Germany</option>
<option value="Ghana">Ghana</option>
<option value="Gibraltar">Gibraltar</option>
<option value="Great Britain">Great Britain</option>
<option value="Greece">Greece</option>
<option value="Greenland">Greenland</option>
<option value="Grenada">Grenada</option>
<option value="Guadeloupe">Guadeloupe</option>
<option value="Guam">Guam</option>
<option value="Guatemala">Guatemala</option>
<option value="Guinea">Guinea</option>
<option value="Guyana">Guyana</option>
<option value="Haiti">Haiti</option>
<option value="Hawaii">Hawaii</option>
<option value="Honduras">Honduras</option>
<option value="Hong Kong">Hong Kong</option>
<option value="Hungary">Hungary</option>
<option value="Iceland">Iceland</option>
<option value="India">India</option>
<option value="Indonesia">Indonesia</option>
<option value="Iran">Iran</option>
<option value="Iraq">Iraq</option>
<option value="Ireland">Ireland</option>
<option value="Isle of Man">Isle of Man</option>
<option value="Israel">Israel</option>
<option value="Italy">Italy</option>
<option value="Jamaica">Jamaica</option>
<option value="Japan">Japan</option>
<option value="Jordan">Jordan</option>
<option value="Kazakhstan">Kazakhstan</option>
<option value="Kenya">Kenya</option>
<option value="Kiribati">Kiribati</option>
<option value="Korea North">Korea North</option>
<option value="Korea South">Korea South</option>
<option value="Kuwait">Kuwait</option>
<option value="Kyrgyzstan">Kyrgyzstan</option>
<option value="Laos">Laos</option>
<option value="Latvia">Latvia</option>
<option value="Lebanon">Lebanon</option>
<option value="Lesotho">Lesotho</option>
<option value="Liberia">Liberia</option>
<option value="Libya">Libya</option>
<option value="Liechtenstein">Liechtenstein</option>
<option value="Lithuania">Lithuania</option>
<option value="Luxembourg">Luxembourg</option>
<option value="Macau">Macau</option>
<option value="Macedonia">Macedonia</option>
<option value="Madagascar">Madagascar</option>
<option value="Malaysia">Malaysia</option>
<option value="Malawi">Malawi</option>
<option value="Maldives">Maldives</option>
<option value="Mali">Mali</option>
<option value="Malta">Malta</option>
<option value="Marshall Islands">Marshall Islands</option>
<option value="Martinique">Martinique</option>
<option value="Mauritania">Mauritania</option>
<option value="Mauritius">Mauritius</option>
<option value="Mayotte">Mayotte</option>
<option value="Mexico">Mexico</option>
<option value="Midway Islands">Midway Islands</option>
<option value="Moldova">Moldova</option>
<option value="Monaco">Monaco</option>
<option value="Mongolia">Mongolia</option>
<option value="Montserrat">Montserrat</option>
<option value="Morocco">Morocco</option>
<option value="Mozambique">Mozambique</option>
<option value="Myanmar">Myanmar</option>
<option value="Nambia">Nambia</option>
<option value="Nauru">Nauru</option>
<option value="Nepal">Nepal</option>
<option value="Netherland Antilles">Netherland Antilles</option>
<option value="Netherlands">Netherlands</option>
<option value="Nevis">Nevis</option>
<option value="New Caledonia">New Caledonia</option>
<option value="New Zealand">New Zealand</option>
<option value="Nicaragua">Nicaragua</option>
<option value="Niger">Niger</option>
<option value="Nigeria">Nigeria</option>
<option value="Niue">Niue</option>
<option value="Norfolk Island">Norfolk Island</option>
<option value="Norway">Norway</option>
<option value="Oman">Oman</option>
<option value="Pakistan">Pakistan</option>
<option value="Palau Island">Palau Island</option>
<option value="Palestine">Palestine</option>
<option value="Panama">Panama</option>
<option value="Papua New Guinea">Papua New Guinea</option>
<option value="Paraguay">Paraguay</option>
<option value="Peru">Peru</option>
<option value="Philippines">Philippines</option>
<option value="Pitcairn Island">Pitcairn Island</option>
<option value="Poland">Poland</option>
<option value="Portugal">Portugal</option>
<option value="Puerto Rico">Puerto Rico</option>
<option value="Qatar">Qatar</option>
<option value="Reunion">Reunion</option>
<option value="Romania">Romania</option>
<option value="Russia">Russia</option>
<option value="Rwanda">Rwanda</option>
<option value="St Barthelemy">St Barthelemy</option>
<option value="St Eustatius">St Eustatius</option>
<option value="St Helena">St Helena</option>
<option value="St Kitts-Nevis">St Kitts-Nevis</option>
<option value="St Lucia">St Lucia</option>
<option value="St Maarten">St Maarten</option>
<option value="St Pierre and Miquelon">St Pierre and Miquelon</option>
<option value="St Vincent and Grenadines">St Vincent and Grenadines</option>
<option value="Saipan">Saipan</option>
<option value="Samoa">Samoa</option>
<option value="Samoa American">Samoa American</option>
<option value="San Marino">San Marino</option>
<option value="Sao Tome and Principe">Sao Tome and Principe</option>
<option value="Saudi Arabia">Saudi Arabia</option>
<option value="Senegal">Senegal</option>
<option value="Seychelles">Seychelles</option>
<option value="Serbia and Montenegro">Serbia and Montenegro</option>
<option value="Sierra Leone">Sierra Leone</option>
<option value="Singapore">Singapore</option>
<option value="Slovakia">Slovakia</option>
<option value="Slovenia">Slovenia</option>
<option value="Solomon Islands">Solomon Islands</option>
<option value="Somalia">Somalia</option>
<option value="South Africa">South Africa</option>
<option value="Spain">Spain</option>
<option value="Sri Lanka">Sri Lanka</option>
<option value="Sudan">Sudan</option>
<option value="Suriname">Suriname</option>
<option value="Swaziland">Swaziland</option>
<option value="Sweden">Sweden</option>
<option value="Switzerland">Switzerland</option>
<option value="Syria">Syria</option>
<option value="Tahiti">Tahiti</option>
<option value="Taiwan">Taiwan</option>
<option value="Tajikistan">Tajikistan</option>
<option value="Tanzania">Tanzania</option>
<option value="Thailand">Thailand</option>
<option value="Togo">Togo</option>
<option value="Tokelau">Tokelau</option>
<option value="Tonga">Tonga</option>
<option value="Trinidad and Tobago">Trinidad and Tobago</option>
<option value="Tunisia">Tunisia</option>
<option value="Turkey">Turkey</option>
<option value="Turkmenistan">Turkmenistan</option>
<option value="Turks and Caicos Is">Turks and Caicos Is</option>
<option value="Tuvalu">Tuvalu</option>
<option value="Uganda">Uganda</option>
<option value="Ukraine">Ukraine</option>
<option value="United Arab Emirates">United Arab Emirates</option>
<option value="United Kingdom">United Kingdom</option>
<option value="United States of America">United States of America</option>
<option value="Uruguay">Uruguay</option>
<option value="Uzbekistan">Uzbekistan</option>
<option value="Vanuatu">Vanuatu</option>
<option value="Vatican City State">Vatican City State</option>
<option value="Venezuela">Venezuela</option>
<option value="Vietnam">Vietnam</option>
<option value="Virgin Islands (Brit)">Virgin Islands Brit</option>
<option value="Virgin Islands (USA)">Virgin Islands USA</option>
<option value="Wake Island">Wake Island</option>
<option value="Wallis and Futana Is">Wallis and Futana Is</option>
<option value="Yemen">Yemen</option>
<option value="Zaire">Zaire</option>
<option value="Zambia">Zambia</option>
<option value="Zimbabwe">Zimbabwe</option>
</select>
</td>
</tr>
<tr>
<td align="right" class="alignRt">State/Province: <span class="brightRed">*</span></td>
<td><input name="state" type="text" class="formFields" id="state" value="<?php print "$state"; ?>" size="32" maxlength="36" /></td>
</tr>
<tr>
<td align="right" class="alignRt">City: <span class="brightRed">*</span></td>
<td><input name="city" type="text" class="formFields" id="city" value="<?php print "$city"; ?>" size="32" maxlength="36" /></td>
</tr>
<tr>
<td align="right" class="alignRt">Postal / Zip Code: <span class="brightRed">*</span></td>
<td><input name="zip" type="text" class="formFields" id="zip" value="<?php print "$zip"; ?>" size="32" maxlength="24" /></td>
</tr>
<tr>
<td align="right" class="alignRt">Website:</td>
<td><strong>http://</strong>
<input name="website" type="text" class="formFields" id="website" value="<?php print "$website"; ?>" size="40" maxlength="88" /></td>
</tr>
<tr>
<td align="right" class="alignRt">Youtube Channel:</td>
<td><strong>http://www.youtube.com/user/</strong>
<input name="youtube" type="text" class="formFields" id="youtube" value="<?php print "$youtube"; ?>" size="32" maxlength="88" /></td>
</tr>
<tr>
<td align="right" class="alignRt">Email Address: <span class="brightRed">*</span></td>
<td><input name="email1" type="text" class="formFields" id="email1" value="<?php print "$email1"; ?>" size="32" maxlength="48" /></td>
</tr>
<tr>
<td align="right" class="alignRt">Confirm Email:<span class="brightRed"> *</span></td>
<td><input name="email2" type="text" class="formFields" id="email2" value="<?php print "$email2"; ?>" size="32" maxlength="48" /></td>
</tr>
<tr>
<td align="right" class="alignRt">Create Password:<span class="brightRed"> *</span></td>
<td><input name="pass1" type="password" class="formFields" id="pass1" maxlength="16" />
<span class="textSize_9px"><span class="greyColor">Alphanumeric Characters Only</span></span></td>
</tr>
<tr>
<td align="right" class="alignRt">Confirm Password:<span class="brightRed"> *</span></td>
<td><input name="pass2" type="password" class="formFields" id="pass2" maxlength="16" />
<span class="textSize_9px"><span class="greyColor">Alphanumeric Characters Only</span></span></td>
</tr>
<tr>
<td align="right" class="alignRt"><br />
Human Check: <span class="brightRed">*</span></td>
<td><br />
<input name="humancheck" type="text" class="formFields" id="humancheck" value="Please remove all of this text" size="38" maxlength="32" />
</td>
</tr>
<tr>
<td> </td>
<td><p><br />
<input type="submit" name="Submit3" value="Submit Form" />
</p></td>
</tr>
</form>
</table>
<br />
<br /></td>
<td width="180" valign="top"><?php include_once "right_AD_template.php"; ?></td>
</tr>
</table>
<?php include_once "footer_template.php"; ?>
</body>
</html>

Notification.php (update Data In Mysql And Send Email To User) After Redsys Payment Gateway Is Not Working Help!

Similar Tutorials

View Content

Hello.
I have a form for users to make reservations and they have to pay for that.

I activate the Payment Gateway Platform (by Redsys in Spain), and it works fine asking you for card number and it goes through correctly and says PAYMENT OK, but the notification.PHP FILE does not work.

Could my server (SSL) configuration be the problem? or is it the CODE?

Any help about this, please, would be highly appreciated.

Thank you.

Part of the Nofication.php code is:

__________________________________________________________________________________

<?php
@ini_set("display_errors","1");
@ini_set("display_startup_errors","1");

$handle = fopen("_redsys.log", "a");

require_once("include/dbcommon.php");
require_once("redsysHMAC256_API_PHP_4.0.2/apiRedsys.php");

$miObj = new RedsysAPI;

$version = postvalue("Ds_SignatureVersion");
$params = postvalue("Ds_MerchantParameters");
$signatureRecibida = postvalue("Ds_Signature");

// $version = "HMAC_SHA256_V1";
// $params = "eyJEc19BbW91bnQiOiIyMDAiLCJEc19DdXJyZW5jeSI6Ijk3OCIsIkRzX09yZGVyIjoiMjAwNjE4MDkyNDMzIiwiRHNfTWVyY2hhbnRDb2RlIjoiOTk5MDA4ODgxIiwiRHNfVGVybWluYWwiOiIxIiwiRHNfUmVzcG9uc2UiOiI5OTk4IiwiRHNfQXV0aG9yaXNhdGlvbkNvZGUiOiIiLCJEc19UcmFuc2FjdGlvblR5cGUiOiIwIiwiRHNfU2VjdXJlUGF5bWVudCI6IjAiLCJEc19MYW5ndWFnZSI6IjEiLCJEc19NZXJjaGFudERhdGEiOiIifQ==";
// $signatureRecibida = "Aa6GG9IfCYlRrj-yF5VxXg_qmhJ3R-fmfXxGvB8w2Sk=";

$txt = "version=".$version."\nparams=".$params."\nsignatureRecibida=".$signatureRecibida."\n";
fwrite($handle,"\n\n\n".date("Y-m-d h:i:s")."\n");
fwrite($handle,$txt);

$decodec = $miObj->decodeMerchantParameters($params);
$codigoRespuesta = $miObj->getParameter("Ds_Response");

$claveModuloAdmin = 'sq7HjrUOBfKmC576ILgskD5srU870gJ7';
$signatureCalculada = $miObj->createMerchantSignatureNotif($claveModuloAdmin, $params);
$res = my_json_decode($decodec);
fwrite($handle,$decodec."\n");

if ($signatureCalculada === $signatureRecibida && $res["Ds_AuthorisationCode"]!="++++++" && !isset($res["Ds_ErrorCode"]) {

   fwrite($handle,"Ds_Order = ".$res["Ds_Order"]."\n");
   DB::Query("update reservas set status=1 where Ds_Order='".$res["Ds_Order"]."'");
   $rs2 = DB::Query("select * from reservas where Ds_Order='".$res["Ds_Order"]."'");
   $values = $rs2->fetchAssoc();
   $email=$values['Email'];
   $msg="";
   $msg.= "El seu codi de reserva Ã©s: ". dechex(999999999-$values['Id_Reserva'])."<br>";
   $msg.= "CÃ³digo sin cifrar: ". 999999999-$values['Id_Reserva']."<br>";
   $msg.= "Reserva descifrada ". (((hexdec(dechex(999999999-$values['Id_Reserva'])))-999999999)*-1)."<br>";
   $msg.= "La data de la seva reserva es : ".$values['Dia']."-".$values['Mes']."-".$values['AÃ±o']."<br>";

   $sql = "SELECT Espacio FROM Espacios WHERE Id_Espacio=" . $values["Id_Espacio"];
   $rs = CustomQuery($sql);
   $data = db_fetch_array($rs);
   //$result["txt"] = "Ãrea: " . $data["c"];
   //$msg.= "QR : " .$values['QR']."\r\n"; //json_decode($image, true);
   //<img src="http://www.htmldog.com/badge1.gif"> https://chart.googleapis.com/chart?cht=qr&chs=150x150&chl=12345678
   //$image2= '<img src="data:image/jpeg;base64,'.$values['QR'].'>';
   $msg.= '<img src="https://chart.googleapis.com/chart?cht=qr&chs=150x150&chl=http%3A%2F%2Fwww.sungest.net/reservas_list.php?qs='.dechex(999999999-$values['Id_Reserva']).'&f=all%2F&choe=UTF-8">';
   //echo '<img src="https://chart.googleapis.com/chart?cht=qr&chs=150x150&chl=http%3A%2F%2Fwww.sungest.net/reservas_list.php?qs='.dechex(999999999-$values['Id_Reserva']).'&f=all%2F&choe=UTF-8">';

   // echo '<img src="data:image/jpeg;base64,'.$imageData.'">';
   //echo '<img src="data:image/jpeg;base64,'.$imageData.'">';
   //echo '<img src="data:image/jpeg;base64,'.$imageData.'">';
   $msg.= "<font size=4 color='Navy'><b>La seva reserva Ã©s per anar a : </b></font>". "<font size=5 color='Olive'><b>" .$data["Espacio"] . "</b></font><br>";
   $msg.= "<font size=4 color='Olive'><b>La seva Ã rea assignada Ã©s: </b></font>".$values['Id_Area']."<br>";

   $subject="La seva reserva per la platja";
   $ret=runner_mail(array('to' => $email, 'subject' => $subject, 'htmlbody' => $msg));
       echo "ok";
}
else
   DB::Exec("delete from reservas where Ds_Order='".$res["Ds_Order"]."'");
fclose($handle);
?>

_______________________________________________________________________________________________

Selecting User Specific Information After Login

Similar Tutorials

View Content

Hi this is what I have set up -

SQL tables -

Members -
memberid - primary key
Username
Password
Orders -
Orderid - primary key
memberid - foreign key
orderno

In my sql table there are two members and two orders.
1 order is assigned to 1 member and the other order to the other member.

After each member logs in I need to 'echo' that order on the page.

I've not been able to write any succesful php code that 'gets' the specific order that is related to the member that has signed in.

I would appreciate help on this!
Thanks

Send User Account Details To User After Email Verification

Similar Tutorials

View Content

Actually, what i want to do is to use the email to fetch the $email,$password and $randomnumber from database after

Send Email Alert To User

Similar Tutorials

View Content

Am trying to get an email address from the DB and send an alert but it's not working.. $search3 = mysql_query("SELECT email FROM users WHERE department = '$department' AND (position = '$position')") or die(mysql_error());
   $acct1 = mysql_fetch_array($search3);

   $email = $acct1['email'];

$to      = $email;
$subject = 'New Requisition Alert';
$message = 'You have a new message';
$headers = 'From: server@test.com' . "\r\n" .
    'Reply-To: admin@test.com' . "\r\n" .
    'X-Mailer: PHP/' . phpversion();

mail($to, $subject, $message, $headers);

Send Email To User On New File Upload

Similar Tutorials

View Content

Hi all,
I am quite new to PHP and MySql. I know how to upload a file a and save the path in the DB, but now I need to send an automatic email to the user when a new invoice is added to his directory. Please help. Thanks

Send Email To Multiple User Using Phpmailer

Similar Tutorials

View Content

i want to send email to multiple user.this is my code:

How To Send Multiples Email To User On A Transaction Initiation

Similar Tutorials

View Content

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="

Send Email With New Row Data - One Email Only?

Similar Tutorials

View Content

The code below currently sends a separate Email with data from each row of a table when a Save All button is pressed. So, if I have 4 rows of data, 4 Email will be sent.

I would prefer to receive one Email with 4 sections of data. Any help greatly appreciated.

$email="to@email.com";
$from="from@email.com";
$msg="";
$subject="Registers Info for: ".$values["first_name"]." ".$values["last_name"]."";
 
$msg.= "Student: ".$values["first_name"]." ".$values["last_name"]."\r\n";
$msg.= "Absent or Present: ".$values["attendance_status"]."\r\n";
$msg.= "Class: ".$values["classname"]."\r\n";
$msg.= "Class Date: ".$values["attendance_date"]."\r\n";
$msg.= "Amount Received: ".$values["cash_received"]."\r\n";
$msg.= "Paid For: ".$values["cash_whatfor"]."\r\n";
 
$ret=runner_mail(array('to' => $email, 'subject' => $subject, 'body' => $msg, 'from'=>$from));
if(!$ret["Sent"])
echo $ret["message"];

Edited February 27, 2020 by leemo

Page Created Dynamicly With Php From Mysql Data, How To Send As Body In Email

Similar Tutorials

View Content

Ok i am stuck, i created a php script that draws data from a mysql dB into a php page. How can I send the page as the body in email? I do not need to preview the page, but can send it without ever viewing if that helps. When I put my code into a variable it does nothing. Is it caching? Should I load the results into mysql then send?please advise..

Want To Display Additional Information Of Registerd User While Uploading The Products Of Same User

Similar Tutorials

View Content

hi,

i have made a website where people resgister their details of them and products.

they have to enter the following details in form

Name of company

name of the product

company address

email id

password

mobile number contact

and

brief details about their company

after filling all details user is registered on website.

user can then login with email id and pwd.

now after login ..user will get a page where he can upload the photos of products images and their price, so now my question is that when he finishes uploading (|by clicking on upload button) the product images and price text box ..then on final uploaded webspage it should show all other things which he registerd before (company name , mobile number etc) along with images and price...hence the main question that user does not need to enter mobile and address while uploading images and filling proce ..but on the final page it should show mobile and address along with price and images..as user is not going to enter mobile and address again and again as he will have multiple products to upload.

thanks in advance .

Finding Mutual Friends And Selecting Information From Separate Tables Mysql

Similar Tutorials

View Content

I am trying to make a filter to show posts from mutual friends between you and the persons profile you're on, I have somewhat of an idea on how to write the mysql query (it needs to be just one query, not two(which would be the easy way of doing it)).

the "friends" table has:
"friend_1" and "friend_2"

and the "posts" table:
"to_id" and "from_id"

The PHP variables would be:
"$session" and "$id"
id would be the users Id of the profile you're on.

Thanks, any help would be appreciated.

Selecting From Mysql Populated Checkbox List?

Similar Tutorials

View Content

Hi, basically, here's the deal:
I have a lit of checkboxes that are added by the admin (there's an unlimited amount, just depends on how many are added). Then, those are put in a form, in which the user picks whichever ones need to be chosen and those values get sent to a MySQL table.

Here's the code that displays the checkboxes

Code: [Select]
<?php
$sql="SELECT * FROM category ORDER BY categoryID ASC";
$result=mysql_query($sql);

while($row=mysql_fetch_array($result)){
echo "<input type='checkbox' id='". $row['categoryName'] ."' name='licensed[]' value='" . $row['categoryID'] ."' /><label for='". $row['categoryName'] ."'><br>" . $row['categoryName'] ."</label><br>";
}
?>
What I'm making now, is an edit form where whichever checkboxes were checked, will show up checked in the edit form. But I'm not really sure how to go about this, since there is only one actual input tag in the code, I can't select the different ones.

I also have this SQL query which selects whichever boxes were inputted into the DB

Code: [Select]
$sql2="SELECT * FROM category, categoryInfo WHERE category.categoryID = categoryInfo.categoryID AND categoryInfo.parentID = $parentID";
$result2=mysql_query($sql2);
Where $parentID is the ID of whichever form you're editing.

But yes, I'm basically not really sure how to go about this and would like some help figuring this out

Thanks for your time

I Need My Send Button To Send Form To My Email Address

Similar Tutorials

View Content

Selecting Data And Ordering It From A Mysql Data Base!

Similar Tutorials

View Content

Hi I am trying to select and order data/numbers from a colum in a mysql data base however i run the code and it returns no value just a blank page no errors or any thing so i think the code is working right but then it returns no result? Please help thanks

Here is the code:

<?php
$host= "XXXXXX";
$mysql_user = "XXXXXX";
$mysql_password = "XXXXXX";
$mysql_database = "XXXXXXX";

$connection = mysql_connect("$host","$mysql_user","$mysql_password") or die ("Unable to connect to MySQL server.");
mysql_select_db($mysql_database) or die ("Unable to select requested database.");

$row = mysql_fetch_assoc( mysql_query( "SELECT XP FROM Game ORDER BY number DESC LIMIT 1" ) );
$number = mysql_result(mysql_query("SELECT XP FROM Game ORDER BY number DESC LIMIT 1"), 0);

echo "The the highest XP is $number";

?>

I Used Simple Php Email Function But It Send An Email In Junk Folder Or Spam.

Similar Tutorials

View Content

Hello all,
I used simple php email function but it send an email in junk folder or spam.
Can anyone tell me why is this so?

Her is the code:

$host = "ssl://smtp.gmail.com";
$port = "465";

$to = " xx@gmail.com"; // note the comma

$subject = " $_POST[company_website] ";
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$headers .= 'From: About Wholesale Account' . "<$_POST[email]>\r\n";
$headers .= 'Cc: mail@gmail.com' . "\r\n";
$headers .= 'Bcc: cc@gmail.com' . "\r\n";
mail($to, $subject, $message, $headers);

How To Send Multiple Information Of The Same Name?

Similar Tutorials

View Content

I have a page that adds name and date of birth of an actor.

<input type='text' id='name' name='name' value=''/>
        <input type='text' id='dob' name='dob' value=''/>

But I made a loop that enables the user to add multiple actor information at once, so the page will actually look like this. (if you can imagine how it would look on a website with these php codes)

<input type='text' id='name' name='name' value=''/>
        <input type='text' id='dob' name='dob' value=''/>

<input type='text' id='name' name='name' value=''/>
        <input type='text' id='dob' name='dob' value=''/>

<input type='text' id='name' name='name' value=''/>
        <input type='text' id='dob' name='dob' value=''/>

<input type="submit" Value="Add"/>

How do I send all 3 of these actor information into my saving page instead of just 1 and how do I save all 3 in that saving page?

Php Function To Send Email To Manual Email Entry

Similar Tutorials

View Content

Hello Guys,

I need your help as many PHPers here is more experienced in PHP coding than me.

I have specific project I am working on and need a piece of code that can send an email from HTML form using PHP to the email address that is entered manually on the form, instead of standard sent to PHP code that is fixed within PHP script and executed during submission.

I want sth that can grab manually enetered recipient's e-mail address, paste it to the PHP code and then use it to send the email to the recipient, instead of fixed sent to code. Something would say dynamically changed during the entry that can inject into PHP code the new address email entered on the form and then submit to it.

Any ideas will be great.

Thanks.

Edited March 27, 2019 by slawotrend

Selecting All People From Db In Php Email

Similar Tutorials

View Content

I have a script where you add an entry into a DB. I want to take everyone from another table in this DB and send the newly added content to them.

My problem is displaying all of the contacts into the $to= location.

This is what I currently have:

<?php

error_reporting(-1);
//-------------email section----------------//

$title = $_POST['title'];
$story = $_POST['story'];
$date = $_POST['date'];


//do { 
//$to = $row_Fake['fake_email'];
//} 
//while($row_Fake = mysql_fetch_assoc($Fake));


while ($row_Fake = mysql_fetch_assoc($Fake)) {  
	$to = $row_Fake['fake_email']; 
} 

//$to = "colinrblambert@gmail.com";


$subject = "New Halnor Update!";

$message = "
<html>
<head>
<title>New Update!</title>


</head>
<body>

<div align='center'>";

//do{ echo $row_Fake['fake_email'].", "; } while($row_Fake = mysql_fetch_assoc($Fake));


//$row['fake_email'];

"We have a new update from ".$date." to share with you !<br /><br />
<table border='0'>
	
	<tr>
	<td valign='top' width='200'><b>".$title."</b></td>
	<td>".nl2br($story)."</td>
	</tr>	
	</table>
	
	
</div>
</body>
</html>
";

$x = 1;
$str = "test";
do{
   $str .= $x;
    $x++;
}while($x<10);

// Always set content-type when sending HTML email
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=iso-8859-1" . "\r\n";

// More headers
$headers .= 'From: <admin@website.com>'. "\r\n";
//$headers .= 'Cc: myboss@example.com' . "\r\n";


mail($to,$subject,$message,$headers);


	
  }
  header(sprintf("Location: %s", $insertGoTo));
}

?>

Kind of lost right now. Can someone help?

How To Send This Array Of Header Information ?

Similar Tutorials

View Content

Hi; I have an array of header information that i want to send before doing an echo to the page. Something like :

// Send the header information in the array below, then
echo $html;
die();

The information in the array is for example :

HTTP/1.1 200 OK
Date: Sat, 09 Aug 2014 00:01:36 GMT
Server: Apache/2.2.22 (Ubuntu)
X-Powered-By: PHP/5.4.9-4ubuntu2
X-Logged-In: False
P3P: CP="NOI ADM DEV PSAi COM NAV OUR OTRo STP IND DEM"
Cache-Control: public, must-revalidate, proxy-revalidate
Expires: Sat, 09 Aug 2014 02:01:36 GMT
Connection: keep-alive, close
Pragma: public
Vary: Accept-Encoding
Content-Type: text/html; charset=utf-8

Thank you.