connect()) { $email = $_POST['email']; $email = mysqli_real_escape_string($mysql->mysqli, $email); $email = strtolower($email); $email = trim($email); $query = "SELECT * from $dbfile where $dbfile.Email='$email'"; if ($debug) echo "$query
"; $mysql->query($query); $result = $mysql->queryresult2array(); if ($debug) print_r($result); if (count($result)>0) { $resultmessage = "$email is opted out"; if ($mysql->internalIP()) { $date = new DateTime($result[0]['Date']); $resultmessage .= " on " . $date->format('M, j, Y'); } } else { $query = "INSERT INTO $dbfile (Email,Date) VALUES ('$email',NOW()) ON DUPLICATE KEY UPDATE Date=VALUES(Date)"; //echo "$query
"; if(!$mysql->query($query)) //Fails on dupes so not really an error error_log("unsubscribe failed " . $query); $resultmessage="$email has been added to our $dbname opt-out list."; } } } } } ?> Unsubscribe -- CompanionLink Software