Forums

Does anyone know how to read one matched record using Chronoforms5 using the DB Read function?

It's clear to me how to extract the whole table for the fields specifed into a data model, but not how to extract one record where - say - email=test@test.com

Works fine - mnay thanks ...

Hello GreyHead,

If no match is found in the db, I would like to display a message such as, "No record was found". What would I need to add or do to accomplish this?

Thanks.

I use this php in an Event Switcher module - the DB Read selects the (one) matching record as GreyHead showed us above - by searching the Joomla users table for a match on the e-mail address from the form. If a match is found then - together with other fields - 'id' is read from the users table (or DB). If this field is set, then a record has been found. If not, then there was no match:

<?php
if (isset($form->data['Data']['id'])) {
     return success;
}
else {
     return fail;
}
?>

If you want the form to be resubmitted when no record is found, then you could use the Event Loop module in the On Fail branch...