+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=11)
+--- Thread: How does is_unique[...] work? (/showthread.php?tid=71718)
How does is_unique[...] work? - Serializable - 09-16-2018
PHP Code:
$this->form_validation->set_rules('username', 'Username', required|is_unique[users.username]');
Could you explain how is_unique work? What is 'users'? The controller which contains the above code named Users, so is 'users' related to the controler name? Next, what is '.username' here? How does it work?
RE: How does is_unique[...] work? - Wouter60 - 09-16-2018
The answer to your question is in the documentation about the form_validation library:
is_unique[table.field] returns FALSE if the form element is not unique to the table and field name in the parameter. Note: This rule requires Query Builder to be enabled in order to work.
So users is the table, username is the field.
https://www.codeigniter.com/userguide3/libraries/form_validation.htm
RE: How does is_unique[...] work? - Serializable - 09-16-2018
How can I check is Query Builder enabled for my project?
RE: How does is_unique[...] work? - Wouter60 - 09-16-2018
It's enabled by default.
https://www.codeigniter.com/userguide3/database/configuration.html?highlight=query%20builder%20enabled
RE: How does is_unique[...] work? - Serializable - 09-16-2018
Wouter60, thanks