PHP，MYSQL，FOREACH检查是否有相同的值

Question

Example:

Mysql - table_data

  dataid   dataname    datastatus
    1        joel          1
    1        joelle        2
    1        joe           3
    1        joela         4
    1        joella        5

PHP

 $names = array('joel','joelle','joe','joela');
 foreach($names as $name)
 {
    $qcheck = $this->db->query("SELECT * FROM table_data WHERE dataname=".$name."");
     //Do checking here
 }

How can I know if joel, joelle,joe and joela datastatus are all same and not same?

How can I know the output of that example.. the output should be false because all of the status are not same, and In case all of the status are the same how can I know that?

Hope someone could help me thanks in advance..

Answer 1

Try this optimized logic:

$namesStr = implode(',', $names);
$qcheck = $this->db->query("SELECT COUNT(DISTINCT datastatus) AS dataCount FROM table_data WHERE dataname IN($namesStr)");
$allSame = FALSE;
if ($qcheck->num_rows() >  0) {
    if ($qcheck->row()->dataCount == 1) {
        $allSame = TRUE;
    }
}