codeigniter从数据库查询不能按预期工作

Question

working with CI and it seems that something is pinched somewhere.

$this->db->where('email', $username);
$query = $this->db->get('users'); //to check if user already registered.
if($query->num_rows == 1)
{
    return false;
}else{
    $this->db->insert('users', array('email' => $username, 'password' => $password));
    return true;
}

but it takes the control to else every time.

here is print_r($query); dump

CI_DB_mysqli_result Object ( [conn_id] => mysqli Object ( [affected_rows] => 1 [client_info] => mysqlnd 5.0.8-dev - 20102224 - $Id: 731e5b87ba42146a687c29995d2dfd8b4e40b325 $ [client_version] => 50008 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [field_count] => 5 [host_info] => localhost via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.6.25 [server_version] => 50625 [stat] => Uptime: 167005 Threads: 1 Questions: 2022 Slow queries: 0 Opens: 76 Flush tables: 1 Open tables: 64 Queries per second avg: 0.012 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 192 [warning_count] => 0 ) [result_id] => mysqli_result Object ( [current_field] => 0 [field_count] => 5 [lengths] => [num_rows] => 1 [type] => 0 ) [result_array] => Array ( ) [result_object] => Array ( ) [custom_result_object] => Array ( ) [current_row] => 0 [num_rows] => [row_data] => )

and it shows an error A Database Error Occurred instead of returning false

Error Number: 1062

Duplicate entry '[e-mail]' for key 'email'

Answer 1

num_rows is method not properties. Try this

$this->db->where('email', $username);
$query = $this->db->get('users'); //to check if user already registered.
if($query->num_rows() == 1)
{
    //if found
}else{
    //if not found
}