$query = mysqli_query($db, "SELECT COUNT(*) FROM news WHERE title='{$title}'");
$item = mysqli_fetch_row($query);
if ($item[0] == 0) {
mysqli_query($db, "INSERT INTO news (title, link, image, description, created_at) VALUES('{$title}', '{$link}', '{$image}', '{$description}', '{$date}')");
}
$query = mysqli_query($db, "SELECT COUNT(*) FROM news");
$item = mysqli_fetch_row($query);
if ($item[0] > 10) {
mysqli_query($db, "DELETE FROM news ORDER BY `id` ASC LIMIT ".($item[0] - 10));
}if ((new Monitoring())->ping($phone_ip)) {
echo 1; // в сети
if (mysqli_fetch_assoc(mysqli_query($link, "SELECT `ip` FROM `Computer_Check` WHERE `ip`='".mysqli_real_escape_string($link, $phone_ip)."'")) === NULL) {
mysqli_query($link, "INSERT INTO `First_Computer` (`decor`) VALUES ('1')") or die(mysqli_error($link));
mysqli_query($link, "REPLACE INTO `Computer_Check` (`ip`) VALUES ('".mysqli_real_escape_string($link, $phone_ip)."')") or die(mysqli_error($link));
}
} else {
echo 0; // не в сети
if (mysqli_fetch_assoc(mysqli_query($link, "SELECT `ip` FROM `Computer_Check` WHERE `ip`='".mysqli_real_escape_string($link, $phone_ip)."'")) !== NULL) {
mysqli_query($link, "INSERT INTO `First_Computer` (`decor`) VALUES('0')") or die(mysqli_error($link));
mysqli_query($link, "DELETE FROM `Computer_Check` WHERE `ip`='".mysqli_real_escape_string($link, $phone_ip)."'") or die(mysqli_error($link));
}
}
mysqli_close($link);if ($this->myOS()) {
return true;
}if (!exec("ping -q -c1 " . $phone_ip . " >/dev/null 2>&1 ; echo $?")) {if (time() % 30 == 8)
{
// код, выполняемый в 08-ую и в 38-ую секунду каждой минуты.
// поменять на '== 3' - станет каждую 03-ую и 33-ю секунду каждой минуты...
}
Если именно `id`=10, то:
SELECT * FROM `news` WHERE `id`=10А если только 10-ую запись (одну) из всех имеющихся:
SELECT * FROM `news` ORDER BY `id` ASC LIMIT 10, 1