Welcome Guest, Not a member yet? Register   Sign In
Database Error
#1

Greetings All,
Am less than a month old in learning CI, I have a problem:
I'm using the form_validation library to validate form inputs.
Two of the fields (username and email fields) has to check in the DB that the user input is unique and doesn't already exist in the DB - I'm creating a user system using ion_auth. The code for the validation of the fields are as follows

PHP Code:
$this->form_validation->set_rules('name''Display Name''is_unique|isme_users.username|required');
        
$this->form_validation->set_rules('email''Email''valid_email|is_unique|isme_users.email|required'); 

I'm getting the error in the attached picture.

   

I'm running LAMPP on Ubuntu and my server parameters are as follows (from PHPMyAdmin)
  • Apache/2.4.29 (Unix) OpenSSL/1.0.2n PHP/7.2.0 mod_perl/2.0.8-dev Perl/v5.16.3

  • Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id: b396954eeb2d1d9ed7902b8bae237b287f21ad9e $

  • PHP extension: mysqli[Image: dot.gif] curl[Image: dot.gif] mbstring[Image: dot.gif]

  • PHP version: 7.2.0
My knowledge of databases and SQL re li,ited and am still laerning them.
Help is needed and appreciated.
Reply


Messages In This Thread
Database Error - by enelson - 01-20-2018, 10:35 AM
RE: Database Error - by jreklund - 01-20-2018, 01:43 PM
RE: Database Error - by enelson - 01-21-2018, 11:23 AM
RE: Database Error - by jreklund - 01-21-2018, 02:23 PM
RE: Database Error - by enelson - 01-23-2018, 12:36 PM



Theme © iAndrew 2016 - Forum software by © MyBB