1小时后执行查询

Question

附表格样本。

​

每小时我都想把最近的东西加到我的桌子上。该表是从另一个源填充的，我需要跟踪我最后收到的id是什么，并获得所有添加的新项目。

$check5 = "select * from media_ids";
$rs5 = mysqli_query($con,$check5);
if(mysqli_num_rows($rs5)==1)
{
$row = mysqli_fetch_assoc($rs5);
$media_id=$row['media_id'];
}

// execute query

Answer 1

1. 您需要创建一个每小时运行的cron作业。

crontab -e，然后添加0 * * * * php /path/to/script/script.php

1. 向表中添加一个名为created的列，将类型设置为TIMESTAMP，将默认值设置为CURRENT_TIMESTAMP

3a。

<?php

$current = time() - 3600;
$currentMediaQuery = "select media_id from media_ids where created > {$current}"
$mediaQuery = mysqli_query($con, $currentMediaQuery);

if (mysqli_num_rows($mediaQuery) > 0) {
    while ($row = mysqli_fetch_row($mediaQuery)) {
         ... do stuff
    }
}

3b。获取10，按要求维护指针

<?php

$lastPointer = “select pointer from pointer_tracking”;
$lastPointerResult = mysqli_query($con, $lastPointer);
$lastPointer = mysqli_fetch_row($lastPointerResult)
$lastPointer = $lastPointer[0];

$currentMediaQuery = “select * from media_ids where id > {$lastPointer} limit {$lastPointer}, {$lastPointer +10}”;

$mediaQuery = mysqli_query($con, $currentMediaQuery);

if (mysqli_num_rows($mediaQuery) > 0) {
    while ($row = mysqli_fetch_row($mediaQuery)) {
        do stuff…
    }
}

if (($lastPointer + 10 > 40) {
    $lastPointer = 1;
} else {
    $lastPointer += 10;
}

mysqli_query($con, “update pointer_tracking set pointer = {$lastPointer}”);

您需要创建一个名为pointer_tracker的表，其中包含一个id和指针列，这两种类型都是整数类型。