check if e-mail exists in database and if so return system message

Li

Liesbeth 11 Mar, 2018

Hi,

I need som help with this,

I created a form which you can find here. Form fields are added to database and all works fine.

Now the idea is that people can sent a form just 1 time per e-mailaddres, Therefore I want the form to check on submission wether an e-mailaddress already exists in the database or not. If so, a system-message like : 'e-mail already exists' has to be returned.
If the e-mail does not exists formsubmission can be completed .

This is what I have tried:

- adding a db read action on submit , but I am not sure what to fill in there. (model name, php code in where conditions, etc)
- I added a message action and evend loader in the found field of db read action
- I added emailaction, database save action, redirect etc in the not found field of db read action.
Now the message 'e-mail already exests' is always returned (wether it already exists in database or not) and fields are not saved to database.

Would be great to get some help on how to get achieve this.

Kind regards,
Liesbeth

Gr

GreyHead 12 Mar, 2018

Hi Liesbeth,

Please see page 20 of the CFv6 manual for the DB Read settings.

While you can use the Found and Not Found of the DB Read action boxes you might get better control using an Event Switcher action after the DB Read.

Adding a Debugger action will help you see exactly what is happening - in this case I suspect that your DB Read settings are incorrect and no record is being found.

Bob

Li

Liesbeth 12 Mar, 2018

Thanks,

I added an Event Switcher after de DB Read and addeda debugger. (I read you manual this weekend, also about event switching)

I think indeed that de DB Read settings are incorrect. What do I need to fill in there to check if an email allready exests?

Here's the debug info:

Array
(
    [chronoform] => stimformulier
    [event] => submit
    [namme] => Liesbeth Hiddema
    [emailadres] => liesbethhiddema@hotmail.com
    [fideokar] => 1
    [weromwinne] => wyt ik niet
    [checkbox] => 1
    [g-recaptcha-response] => 03ANcjosp8MjO3QgDacPX2BOX7aEzalxLf73aDeStpYnK_RRhcK3PsPlBEdtqycRl7btVxgjFNoQ1QeGvZh8yue_IfM2w6QhWFzB9FgfsfbrjT6hBxpTJLoaLXXq586DiYl4oWQPbJqhZ2h_s5byOtvZcvy9uB5_6IvQou-d7tMXhVZVhNVOk2FugUxaWb67ICHimfO8QCmE9wMw-GDjY1h3XNMx-FafKqD32Ab5WYlK7Z-SJezsWT08URxqmh5Flvg_sw7mUSr6el4gJ2iUFXEAK9YoTVHU4CobVicWMP8wVlf3gokV2NsUOy-Esebd0zU4S1Km_9vDmRwtXqCx5gqilkan9mXpU7sivq9WAap9yvry2jnDYChJJi9dAZE2gDvGqDioc8XVWR96-23V89R585HucLSRiK7TIC6xLCDYmg6nl575uprpUJZyJdcJNLdPo_MsD547D5Z74lxQgB429RsqoAwS-Ipg
    [fersjtoere] => 
    [_ga] => GA1.2.1477110897.1515147185
    [intercom-id-tvfkokak] => 2be8c48b-a1e9-440e-8c4d-1566f028c1b2
    [__atuvc] => 13|3
    [_gid] => GA1.2.610775579.1520793107
    [48cc7a9adeeae7274f311b82a3444ae2] => irknlo2jo9vvl7u0ikb7f85ui2
    [b933176a7c79149ffad07412ce33ffdd] => savbe0ebdg86pq4ph70g27jek2
    [Itemid] => 126
    [option] => com_content
    [view] => article
    [id] => 9
    [stimformulier] => 
)

Gr

GreyHead 12 Mar, 2018

Hi liesbeth,

You only need the first query - SELECT COUNT but it needs to have a Condition added to check the value of the email address. Please check the manual for the way to do that.

Bob

Li

Liesbeth 12 Mar, 2018

Thank you, I slected 'first matching record' at data settings.

The field id of the emailadres is; emailadres and this is also the name of the column of the emailadresses in the database.
Based on the manuel I added this sentence in the field where conditions

emailadres:{data:emailadres}

is that the right way?

Gr

GreyHead 12 Mar, 2018

Hi Liesbeth,

That looks OK to me. I would probably check a record count but either will work.

Bob

Forums

check if e-mail exists in database and if so return system message