Pommo_Helper::isDupe PHP Method

isDupe() public static method

returns an array of duplicate found emails. FALSE if no dupes were found.
public static isDupe ( &$in, $includeUnsubscribed = false )
    public static function isDupe(&$in, $includeUnsubscribed = false)
    {
        $dbo = Pommo::$_dbo;
        if (empty($in)) {
            return false;
        }
        $query = "\n            SELECT " . ($includeUnsubscribed ? 'DISTINCT ' : '') . "email\n            FROM " . $dbo->table['subscribers'] . "\n            WHERE email IN (%q)\n            AND status IN(" . ($includeUnsubscribed ? '0,' : '') . "1,2)";
        $query = $dbo->prepare($query, array($in));
        $o = $dbo->getAll($query, 'assoc', 'email');
        if (empty($o)) {
            $o = false;
        }
        return $o;
    }

Usage Example

Beispiel #1
0
$referer = !empty($_POST['bmReferer']) ? $_POST['bmReferer'] : Pommo::$_http . Pommo::$_baseUrl . 'subscribe.php';
// append stored input
$smarty->assign('referer', $referer . '?input=' . urlencode(serialize($_POST)));
/**********************************
	VALIDATE INPUT
 *********************************/
if (empty($_POST['pommo_signup'])) {
    Pommo::redirect('login.php');
}
$subscriber = array('email' => $_POST['Email'], 'registered' => time(), 'ip' => $_SERVER['REMOTE_ADDR'], 'status' => 1, 'data' => @$_POST['d']);
// ** check for correct email syntax
if (!Pommo_Helper::isEmail($subscriber['email'])) {
    $logger->addErr(Pommo::_T('Invalid Email Address'));
}
// ** check if email already exists in DB ("duplicates are bad..")
if (Pommo_Helper::isDupe($subscriber['email'])) {
    $logger->addErr(Pommo::_T('Email address already exists. Duplicates are not allowed.'));
    $smarty->assign('dupe', TRUE);
}
// check if errors exist with data, if so print results and die.
if ($logger->isErr() || !Pommo_Validate::subscriberData($subscriber['data'], array('active' => FALSE))) {
    $smarty->assign('back', TRUE);
    $smarty->display('user/process.tpl');
    Pommo::kill();
}
$comments = isset($_POST['comments']) ? substr($_POST['comments'], 0, 255) : false;
/**********************************
	ADD SUBSCRIBER
 *********************************/
$config = Pommo_Api::configGet(array('site_success', 'site_confirm', 'list_confirm', 'notices'));
$notices = unserialize($config['notices']);
All Usage Examples Of Pommo_Helper::isDupe