代码之家 › 专栏 › 技术社区 › Avalon Parkes-barton

如果数据库中的if值为true,则显示来自mysql的数据,如果不显示false,则显示true

mysql php javascript

-3

Avalon Parkes-barton · 技术社区 · 7 年前

我的总体目标是,如果ID中有一个值,那么更改ID与数字匹配的单元格

e、 g.以下数据被拉入变化单元格1120,17,40,61,69,70,81,82,9绿色,其余为红色。

如果有什么我需要改变mysql端,那么让我知道我确实尝试过,这样它就从节点red输入到数据库中,以说明mqtt提要add value present to column present中是否存在1-100之间的数字,如果它不在提要add value false中,但我无法让它工作。

数据

[{"id":"1","present":"present","date":"2018-07-17","time":"10:53:20"},
{"id":"120","present":"present","date":"2018-07-17","time":"10:54:24"},
{"id":"17","present":"present","date":"2018-07-17","time":"10:53:40"},
{"id":"40","present":"present","date":"2018-07-17","time":"10:53:27"},
{"id":"61","present":"present","date":"2018-07-17","time":"10:53:14"},
{"id":"69","present":"present","date":"2018-07-17","time":"11:02:01"},
{"id":"70","present":"present","date":"2018-07-17","time":"10:53:17"},
{"id":"81","present":"present","date":"2018-07-17","time":"10:56:50"},
{"id":"82","present":"present","date":"2018-07-17","time":"10:59:28"},
{"id":"9","present":"present","date":"2018-07-17","time":"10:53:15"}]

PHP

<?php
header('Content-type: application/json');
$servername = "localhost:3306";
$username = "user";
$password = "password!";
$dbname = "test";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
} 
#   header('Content-Type: applicaton/json');

$sql = 'SELECT 
* 
FROM test.test where time > NOW() - interval 30 minute group by id';
$result = $conn->query($sql);


$result = mysqli_query($conn ,  $sql);
$rows = array();
while($r = mysqli_fetch_assoc($result)) {
  $rows[] = $r;
}

echo json_encode($rows);
$conn->close();
?>

HTML端

  <script>    
$(document).ready(function() {
    for (var i = 0; i < 12; i++) {
        var row = $('<tr>').appendTo("#zoning tbody");
        for (var j = 1; j < 11; j++) {
            $(`<td class='${i * 10 + j}'>${i * 10 + j}</td>`).appendTo(row);
        }
    }

    $.get('php/test.php', function(response) {
        console.log(response);
        var row;
        response.forEach(function(item, index) {
            console.log(item);
    if (item.id == "notNULL") {
         return $('td.coloured').css('background-color','green').toggleClass('coloured');
        } else {
          return $('td.coloured').css('background-color','red').toggleClass('coloured');
        }            });
    });


        function updateTable() {
        //console.log('function called');
        $('td.coloured').css('background-color','#8F8F8F').toggleClass('coloured');
        $.get('php/test.php', function(response) {
            response.forEach(function(item, index) {
                console.log(item.beacon);
                //$('td.coloured').css('background-color','#8F8F8F').toggleClass('coloured');
    if (item.id == "notNULL") {
         return $('td.coloured').css('background-color','green').toggleClass('coloured');
        } else {
          return $('td.coloured').css('background-color','red').toggleClass('coloured');
        }                
    });
        });

    }
    var updateTableInterval = setInterval(updateTable, 40000);
});
</script>
</head>
<body>

<table id='zoning'>
    <tbody></tbody>
</table>

</body>
</html>

1 回复 | 直到 7 年前

-1

Maykel 7 年前

在设置项目的第一个选项中,可以将if(item.id=present)更改为if(item.id=present)。我需要出示身份证,这是错误的,你需要测试。这只是一个语法错误