I have a very old script that still works on the server.... however, i need now to add phpmailer functionality to it....
What I want is for the phpmailer $to =; and $name = ; variables to be pulled from the dreamweaver recordset... code is below... I will appreciate all the help I can get....
<?php
//Connection statement
require_once('../Connections/synergy.php');
//Aditional Functions
require_once('../includes/functions.inc.php');
// *** Restrict Access To Page: Grant or deny access to this page
$KT_authorizedUsers=" ";
$KT_authFailedURL="Error.php";
$KT_grantAccess=0;
@Session_start();
if (isset($HTTP_SESSION_VARS["KT_Username"])) {
if (true || !(isset($HTTP_SESSION_VARS["KT_userAuth"])) || $HTTP_SESSION_VARS["KT_userAuth"]=="" || KT_strpos($KT_authorizedUsers, $HTTP_SESSION_VARS["KT_userAuth"])) {
$KT_grantAccess = 1;
}
}
if (!$KT_grantAccess) {
$KT_qsChar = "?";
if (strpos($KT_authFailedURL, "?")) $KT_qsChar = "&";
$KT_referrer = $HTTP_SERVER_VARS["REQUEST_URI"];
$KT_authFailedURL = $KT_authFailedURL . $KT_qsChar . "accessdenied=" . urlencode($KT_referrer);
KT_redir($KT_authFailedURL);
}
// *** Logout the current user. false
$KT_Logout = $HTTP_SERVER_VARS["PHP_SELF"] . "?KT_Logoutnow=1";
if ((isset($HTTP_GET_VARS['KT_Logoutnow']) ? $HTTP_GET_VARS['KT_Logoutnow'] : null)=="1") {
@Session_start();
KT_session_unregister("KT_Username");
KT_session_unregister("KT_UserAuthorization");
$KT_logoutRedirectPage = "Login.php";
// redirect with URL parameters (remove the "KT_Logoutnow" query param).
if ($KT_logoutRedirectPage == "") $KT_logoutRedirectPage = $HTTP_SERVER_VARS["PHP_SELF"];
if (!strpos($KT_logoutRedirectPage, "?") && $HTTP_SERVER_VARS['QUERY_STRING'] != "") {
$KT_newQS = "?";
reset ($HTTP_GET_VARS);
while (list ($key, $val) = each ($HTTP_GET_VARS)) {
if($key != "KT_Logoutnow"){
if (strlen($KT_newQS) > 1) $KT_newQS .= "&";
$KT_newQS .= $key . "=" . urlencode($val);
}
}
if (strlen($KT_newQS) > 1) $KT_logoutRedirectPage .= $KT_newQS;
}
KT_redir($KT_logoutRedirectPage);
}
// begin Recordset
$colname__executelasttt = '-1';
if (isset($HTTP_SESSION_VARS['KT_Username'])) {
$colname__executelasttt = $HTTP_SESSION_VARS['KT_Username'];
}
$query_executelasttt = sprintf("SELECT * FROM mymymy WHERE username = '%s'", $colname__executelasttt);
$executelasttt = $synergy->SelectLimit($query_executelasttt) or die($synergy->ErrorMsg());
$totalRows_executelasttt = $executelasttt->RecordCount();
// end Recordset
// begin Recordset
$colname__tttransssfas = '-1';
if (isset($HTTP_SESSION_VARS['KT_Username'])) {
$colname__tttransssfas = $HTTP_SESSION_VARS['KT_Username'];
}
$query_tttransssfas = sprintf("SELECT * FROM transporter WHERE username = '%s' ORDER BY TIN DESC LIMIT 1", $colname__tttransssfas);
$tttransssfas = $synergy->SelectLimit($query_tttransssfas) or die($synergy->ErrorMsg());
$totalRows_tttransssfas = $tttransssfas->RecordCount();
// end Recordset
// begin Recordset
$colname__Recordset1 = '-1';
if (isset($HTTP_SESSION_VARS['KT_Username'])) {
$colname__Recordset1 = $HTTP_SESSION_VARS['KT_Username'];
}
$query_Recordset1 = "SELECT * FROM transporter WHERE username = '$colname__tttransssfas' ORDER BY TIN DESC LIMIT 1";
$Recordset1 = $synergy->SelectLimit($query_Recordset1) or die($synergy->ErrorMsg());
$totalRows_Recordset1 = $Recordset1->RecordCount();
// end Recordset
require("../PHPMailert/class.phpmailer.php");
$to =;
$name = ;
$msg = "Dear $name, your order has been executed successfully. Best Regards.\n$text";
$mailer = new PHPMailer();
$mailer->IsSMTP();
$mailer->Host = 'ssl://smtp.gmail.com:465';
$mailer->SMTPAuth = TRUE;
$mailer->Username = 'myemail@gmail.com'; // Sender's gmail address
$mailer->Password = 'mypass'; // Sender's gmail password
$mailer->From = "myemail@mydomain.com"; // Sender's email address
$mailer->FromName = "MyName"; // senders name
$mailer->Body = "$msg";
$mailer->Subject = "$subject";
$mailer->AddAddress("$to"); // Recipient
if(!$mailer->Send())
{
echo 'Email sent to:' . $to . '<br/ >';
echo "Mailer Error: " . $mailer->ErrorInfo;
}
else
{
echo 'Email sent to:' . $to . '<br/ >';
}
// Then close your while loop here
//PHP ADODB document - made with PHAkt 2.8.2?>
1
Reply
AdChoices