Formhandler › Database

Database

These checks allow you to ensure that a database record exists or doesn't exist. This is useful for unique constraints like username or email address.

Version added

1.0.0

Example code

validators {
  1.class = Validator\DefaultValidator
  1.config {
    fieldConf {
      email.errorCheck {
        1 = required
        2 = email
        3 = isNotInDBTable
        3 {
          table = fe_users
          field = email
          showHidden = 1
        }
      }
    }
  }
}

isInDBTable

Checks if the value of a field is in a configured field in a configured table. Please be aware of the fact that MySQL searches are in most cases not case sensitive! (http://dev.mysql.com/doc/refman/5....

isNotInDBTable

Checks if the value of a field is not in a configured field in a configured table. Please be aware of the fact that MySQL searches are in most cases not case sensitive! (http://dev.mysql.com/doc/refma...