php如何计算统计一列的单双大小出现的次数?
<?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();
?>