Forum of IToris

[IToris team]

E.g. our HTML field for email has "email" name attribute.

Please add the following code to PHP editor:

Code: Select all

$email = @$form->data['email']; //getting email from POST 
if ($email !="") { 
      $database=& JFactory::getDBO(); // getting DB object 
      $dbname = $form->formXMLStruct['database']['name']; // getting the name of associated DB table 
      // settin DB request 
      $database->setQuery('select `id` from '.$dbname.' where `email`='.$database->Quote($email)); 
      $rid = intval($database->loadResult()); // get record ID if it exists 
      if ($rid > 0 && $rid != $form->db_id) { 
           $form->page = 0; // return to 1st form page 
           $form->error = "The email already exists"; 
      } 
} 

The code should be entered before $form->renderForm();

[Mahsa Hatefi]

Hi there
Does this code work in SF ? if so , i put it in a form with "email" name element but it didn't work .
Would you please help with this point ?

[IToris team]

Hello Mahsa Hatefi,

This solution works for SFG only. Please modify this solution for SF or post a new ticket on our online Help Desk. SmartFormer is absolutely free now and we do not provide free support for this extension.

IToris Team