check if a record is in db - php

Question

Well i have a problem. I should check if an email is in my database. I'm using CI (CodeIgniter)

MODEL:

   function getUsersPoints($email)
{
$query = $this->db->query("SELECT * FROM `points` WHERE `p_email` = '$email'");
return $query->result();
}

CONTROLLER: it comes a function that inserts all the data in table customers, and then i should check if the email is in the second table points, and if not, i should add it. so, what i have done:

$this->model->insert_customer($firstname, $lastname, $email, $telephone, $street, $house);
$getUserPoints = $this->model->getUsersPoints($email);

if(count($getUserPoints) == 0)
    echo "ADD in table points";
else
    echo "DO SOMETHING ELSE";

Can someone tell me what i'm doing wrong?

I think that problem, maybe, lies here: stackoverflow.com/questions/1314745/… Try to return result_array() — sinisake
– sinisake, Commented Feb 6, 2014 at 23:35

Danny Chernyavsky · Accepted Answer · 2014-02-06 23:44:48Z

1

ActiveRecord's result() returns object, but you want to count() it, so you need to use ->result_array():

function getUsersPoints($email) {
    $query = $this->db->query("SELECT * FROM `points` WHERE `p_email` = '$email'");
    return $query->result_array();
}

You can also use ->count_all_results() in model, it will return just count. But I think, in such case you should use another ActiveRecords methods enstead of query.

answered Feb 6, 2014 at 23:44

Danny Chernyavsky

4792 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Fabiano · Accepted Answer · 2014-02-06 23:48:59Z

0

function getUserPoints($email){
return $this->db->where('email', $email)->count_all_results('points');
}

answered Feb 6, 2014 at 23:48

Fabiano

9326 silver badges19 bronze badges

Comments

Reena Shirale · Accepted Answer · 2014-02-07 04:55:13Z

0

$data = array(  `p_email` => $email);
$query = $this->db->get_where('points',$data);
if($query->num_rows() == 0)
{
   //Write your code
}
else
{
   //your code
}

answered Feb 7, 2014 at 4:55

Reena Shirale

2,0621 gold badge18 silver badges15 bronze badges

Collectives™ on Stack Overflow

check if a record is in db - php

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related