How to set mobile number unique at the time of customer registration in magento

Question

I have created a customer attribute mobile and include it with customer sign up form. Cutomer sign up is works also for mobile number and customer mobile number is save in database at the time of sign up.

But I want to set email and mobile both unique for customer sign up.

For this I have override createPostAction() function of customer/AccountController.php file.

What condition I have to put in this function to check unique email_id and mobile_number for customer?

Answer 1

First override Customer Resource model app\code\core\Mage\Customer\Model\Resource\Customer.php in local

After replace code from

protected function _beforeSave(Varien_Object $customer)
    {
        parent::_beforeSave($customer);

        if (!$customer->getEmail()) {
            throw Mage::exception('Mage_Customer', Mage::helper('customer')->__('Customer email is required'));
        }

        $adapter = $this->_getWriteAdapter();
        $bind    = array('email' => $customer->getEmail());

        $select = $adapter->select()
            ->from($this->getEntityTable(), array($this->getEntityIdField()))
            ->where('email = :email');
        if ($customer->getSharingConfig()->isWebsiteScope()) {
            $bind['website_id'] = (int)$customer->getWebsiteId();
            $select->where('website_id = :website_id');
        }
        if ($customer->getId()) {
            $bind['entity_id'] = (int)$customer->getId();
            $select->where('entity_id != :entity_id');
        }

        $result = $adapter->fetchOne($select, $bind);
        if ($result) {
            throw Mage::exception(
                'Mage_Customer', Mage::helper('customer')->__('This customer email already exists'),
                Mage_Customer_Model_Customer::EXCEPTION_EMAIL_EXISTS
            );
        }


        // set confirmation key logic
        if ($customer->getForceConfirmed()) {
            $customer->setConfirmation(null);
        } elseif (!$customer->getId() && $customer->isConfirmationRequired()) {
            $customer->setConfirmation($customer->getRandomConfirmationKey());
        }
        // remove customer confirmation key from database, if empty
        if (!$customer->getConfirmation()) {
            $customer->setConfirmation(null);
        }

        return $this;
    }

TO

protected function _beforeSave(Varien_Object $customer)
    {
        parent::_beforeSave($customer);

        if (!$customer->getEmail()) {
            throw Mage::exception('Mage_Customer', Mage::helper('customer')->__('Customer email is required'));
        }

        $adapter = $this->_getWriteAdapter();
        $bind    = array('email' => $customer->getEmail());

        $select = $adapter->select()
            ->from($this->getEntityTable(), array($this->getEntityIdField()))
            ->where('email = :email');
        if ($customer->getSharingConfig()->isWebsiteScope()) {
            $bind['website_id'] = (int)$customer->getWebsiteId();
            $select->where('website_id = :website_id');
        }
        if ($customer->getId()) {
            $bind['entity_id'] = (int)$customer->getId();
            $select->where('entity_id != :entity_id');
        }

        $result = $adapter->fetchOne($select, $bind);
        if ($result) {
            throw Mage::exception(
                'Mage_Customer', Mage::helper('customer')->__('This customer email already exists'),
                Mage_Customer_Model_Customer::EXCEPTION_EMAIL_EXISTS
            );
        }

        if($customer->getMobile()) {
            $bind2    = array('mobile' => $customer->getMobile());

            $select2 = $adapter->select()
                ->from($this->getEntityTable(), array($this->getEntityIdField()))
                ->where('mobile = :mobile');
            if ($customer->getSharingConfig()->isWebsiteScope()) {
                $bind2['website_id'] = (int)$customer->getWebsiteId();
                $select2->where('website_id = :website_id');
            }
            if ($customer->getId()) {
                $bind['entity_id'] = (int)$customer->getId();
                $select2 ->where('entity_id != :entity_id');
            }

            $result = $adapter->fetchOne($select2, $bind2);
            if ($result) {
                throw Mage::exception(
                    'Mage_Customer', Mage::helper('customer')->__('This customer mobile already exists'),
                    Mage_Customer_Model_Customer::EXCEPTION_EMAIL_EXISTS
                );
            }   
        }



        // set confirmation key logic
        if ($customer->getForceConfirmed()) {
            $customer->setConfirmation(null);
        } elseif (!$customer->getId() && $customer->isConfirmationRequired()) {
            $customer->setConfirmation($customer->getRandomConfirmationKey());
        }
        // remove customer confirmation key from database, if empty
        if (!$customer->getConfirmation()) {
            $customer->setConfirmation(null);
        }

        return $this;
    }

Answer 2

Goto -> phpmysql database
open -> eav_attribute
Find your attribute and Set "1" in "is_unique" field