dtujfmfs06058 2015-11-12 03:28
浏览 133
已采纳

PHP,MYSQL,FOREACH检查值是否相同[重复]

This question already has an answer here:

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..

</div>
  • 写回答

2条回答 默认 最新

  • douwu7563 2015-11-12 03:30
    关注

    An easier way to do this would be to use array_unique(). If the resulting array has only one element they are all the same.

    $sample_array = array('Joe','Joe','Joe','Joe');
    if (count(array_unique($sample_array)) === 1) {
      echo 'all the same';
    }
    else {
      echo 'not all the same';
    }
    

    Output

    all the same
    

    Demo

    $arrays = [
        ['Joe','Joe','Joe','Joe'],
        ['Joe','Joe','Joe','John']
    ];
    foreach ($arrays as $array) {
      if (count(array_unique($array)) === 1) {
        echo 'all the same';
      }
      else {
        echo 'not all the same';
      }
      echo "
    ";
    }
    

    Output

    all the same
    not all the same
    

    Demo

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥20 基于MSP430f5529的MPU6050驱动,求出欧拉角
  • ¥20 Java-Oj-桌布的计算
  • ¥15 powerbuilder中的datawindow数据整合到新的DataWindow
  • ¥20 有人知道这种图怎么画吗?
  • ¥15 pyqt6如何引用qrc文件加载里面的的资源
  • ¥15 安卓JNI项目使用lua上的问题
  • ¥20 RL+GNN解决人员排班问题时梯度消失
  • ¥60 要数控稳压电源测试数据
  • ¥15 能帮我写下这个编程吗
  • ¥15 ikuai客户端l2tp协议链接报终止15信号和无法将p.p.p6转换为我的l2tp线路