php如何计算统计一列的单双大小出现的次数？

Question

php如何计算统计一列的单双大小出现的次数？
如：

 <?php echo $q;?>
           <?php 
           $num=$q;
           $res=$num%2;
           if($res == 0){
               
               echo '双';
           }else{
               echo '单';
           }
           
           $res=$num>5;
           if($res == 0){
               echo '小';
           }else{
               echo '大';
           }?>   

所统计出现单双大小各多少次数？

完整代码如下：

<?php
//$js =  file_get_contents('http://kai.kai800.net/getbaseruishi10mshicailist?lotCode=10060');
//echo($js);
$servername = "localhost";
$username = "qxc";
$password = "123456";
$dbname = "qxc";
// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
} 
$sql = " 
SELECT * FROM jz_data where type='5' and (time) between UNIX_TIMESTAMP('14:05:00') and UNIX_TIMESTAMP('2021-12-06 14:10:00') order by number desc LIMIT 276";
$result = $conn->query($sql);
    $num =    $result->num_rows;
    $index = 1;
if ($result->num_rows > 0) {
    // 输出数据
    while($row = $result->fetch_assoc()) {
        $index++;
        $number=$row["number"];
           $data=$row["data"];       
       $arr=$row["data"]; 
       $q=$arr[0].$arr[1];
       $w=$arr[3].$arr[4];
       $e=$arr[6].$arr[7];
       $r=$arr[9].$arr[10];
       $t=$arr[12].$arr[13];
       $y=$arr[15].$arr[16];
       $u=$arr[18].$arr[19];
       $i=$arr[21].$arr[22];
       $o=$arr[24].$arr[25];
       $p=$arr[27].$arr[28];
       $time=date('Y-m-d H:i:s',$row["time"]);
       $serverTime=date('Y-m-d H:i:s');

?>
           <?php echo $q;?>
           <?php 
           $num=$q;
           $res=$num%2;
           if($res == 0){
               
               echo '双';
           }else{
               echo '单';
           }
           
           $res=$num>5;
           if($res == 0){
               echo '小';
           }else{
               echo '大';
           }?>,
           <?php echo $w;?>
           <?php 
           $num=$w;
           $res=$num%2;
           if($res == 0){
               echo '双';
           }else{
               echo '单';
           }
           $res=$num>5;
           if($res == 0){
               echo '小';
           }else{
               echo '大';
           }?>,
           <?php echo $e;?>
           <?php 
           $num=$e;
           $res=$num%2;
           if($res == 0){
               echo '双';
           }else{
               echo '单';
           }
           $res=$num>5;
           if($res == 0){
               echo '小';
           }else{
               echo '大';
           }?>,
           <?php echo $r;?>
           <?php 
           $num=$r;
           $res=$num%2;
           if($res == 0){
               echo '双';
           }else{
               echo '单';
           }
           $res=$num>5;
           if($res == 0){
               echo '小';
           }else{
               echo '大';
           }?>,
           <?php echo $t;?>
           <?php 
           $num=$t;
           $res=$num%2;
           if($res == 0){
               echo '双';
           }else{
               echo '单';
           }
           $res=$num>5;
           if($res == 0){
               echo '小';
           }else{
               echo '大';
           }?>,
           <?php echo $y;?>
           <?php 
           $num=$y;
           $res=$num%2;
           if($res == 0){
               echo '双';
           }else{
               echo '单';
           }
           $res=$num>5;
           if($res == 0){
               echo '小';
           }else{
               echo '大';
           }?>,
           <?php echo $u;?>
           <?php 
           $num=$u;
           $res=$num%2;
           if($res == 0){
               echo '双';
           }else{
               echo '单';
           }
           $res=$num>5;
           if($res == 0){
               echo '小';
           }else{
               echo '大';
           }?>,
           <?php echo $i;?>
           <?php 
           $num=$i;
           $res=$num%2;
           if($res == 0){
               echo '双';
           }else{
               echo '单';
           }
           $res=$num>5;
           if($res == 0){
               echo '小';
           }else{
               echo '大';
           }?>,
           <?php echo $o;?>
           <?php 
           $num=$o;
           $res=$num%2;
           if($res == 0){
               echo '双';
           }else{
               echo '单';
           }
           $res=$num>5;
           if($res == 0){
               echo '小';
           }else{
               echo '大';
           }?>,
           <?php echo $p;?>
           <?php 
           $num=$p;
           $res=$num%2;
           if($res == 0){
               echo '双';
           }else{
               echo '单';
           }
           $res=$num>5;
           if($res == 0){
               echo '小';
           }else{
               echo '大';
           }?>        
        <?php
       if($index<=$num){
           echo '';
       }
    }
} 
$conn->close();
?>

Answer 1

题主可以把需要计算数据放到数组中，然后foreach遍历下计算就好了。。后面那一大堆不用了
代码如下

<?php
//$js =  file_get_contents('http://kai.kai800.net/getbaseruishi10mshicailist?lotCode=10060');
//echo($js);
$servername = "localhost";
$username = "qxc";
$password = "123456";
$dbname = "qxc";
// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
} 
$sql = " SELECT * FROM jz_data where type='5' and (time) between UNIX_TIMESTAMP('14:05:00') and UNIX_TIMESTAMP('2021-12-06 14:10:00') order by number desc LIMIT 276";
$result = $conn->query($sql);
$num =    $result->num_rows;
$index = 1;

//=========

$dan=0;
$shuang=0;
$da=0;
$xiao=0;

//=========

if ($result->num_rows > 0) {
    // 输出数据
    while($row = $result->fetch_assoc()) {
       $index++;
       $number=$row["number"];
       $data=$row["data"];       
       $arr=$row["data"]; 
       $q=$arr[0].$arr[1];
       $w=$arr[3].$arr[4];
       $e=$arr[6].$arr[7];
       $r=$arr[9].$arr[10];
       $t=$arr[12].$arr[13];
       $y=$arr[15].$arr[16];
       $u=$arr[18].$arr[19];
       $i=$arr[21].$arr[22];
       $o=$arr[24].$arr[25];
       $p=$arr[27].$arr[28];
       $time=date('Y-m-d H:i:s',$row["time"]);
       $serverTime=date('Y-m-d H:i:s');


       $arrdata=array($q,$w,$e,$r,$t,$y,$u,$i,$o,$p);//放入数组中

       for($arrdata as $num){//遍历数组统计单双大小
          $res=$num %2;
          if($res==0)$shuang++;
          else $dan++;
          $res=$num>5;
          if($res==0)$xiao++;
          else $da++;

       }

    }
} 
$conn->close();



echo '单：'.$dan.'<br>';
echo '双：'.$shuang.'<br>';
echo '小：'.$xiao.'<br>';
echo '打：'.$da.'<br>';
?>
 

有帮助麻烦点下【采纳该答案】，谢谢~~