TOPIC:

Hi,

I'd like my form to search for duplicates, when submited, in my db called jos6d_videogames from the field "Title".

Thanks for your help,

Elisabeth

Hi,

I created an example form for you.
Please download, unzip and install the file attached in BF => Configuration => Package Installer.
Then head to Manage Forms and try out the form

The important parts are located here:

- the title field, must have the name "title" (the label doesn't matter)

- the custom validation in the title field's custom validation code (triggers an ajax call)

- the DB check in form => advanced => more options => form pieces => before form (checks the existence of the title for the ajax call)

Hope this helps!




Regards,
Markus

Hi,

First I want to thank you for your fast replies and assistance.

I tried to do the following in ''before form'':

if( JRequest::getVar('bf_title', null) !== null ){
while (@ob_get_level() > 0) {
@ob_end_clean();
}
$db = JFactory::getDBO();
$db->setQuery("Select s.id From #__facileforms_records As r, #__facileforms_subrecords As s Where s.record = r.id And r.form = ".$this->form." And s.`name` = 'title' And s.`value` = " . $db->Quote(JRequest::getVar('bf_title', null)));
if(trim($db->loadResult())){
echo 0;
} else {
echo 1;
}
exit;

And then in the validation form:

function ff_title_validation(element, message)
{
if(element.value.trim() == '') return 'Please enter a title';
var myreturn = '';
JQuery.ajaxSetup({async:false});
JQuery.post('index.php', { option: 'com_breezingforms', ff_form: ff_processor.form, Itemid: 0, format: 'html', title: element.value }, function(data){ if( data != '1' ){ message == '' ? myreturn = 'Title exists already!' : myreturn = message; } } );
return myreturn;
}

I'm not a coding expert, but please tell me which parts of these codes I must replace. For now, with these configurations, the form just freezes when I press submit.

Thank you again,

Elisabeth

Hi,

do you mean it freezes without changing anything in the form I sent you or did you do some custom setup already?

If yes, then tell me please what you changed and/or export your form and attach it with your next reply (in that case, please select only your form, nothing else in the package creator).

Regards,
Markus