date_default_timezone_set(".../...");//часовой пояс для сервера
$newdate=date('d.m.Y');
$datestamp = date('20.02.2023'); //от чего считаем
include(dirname(dirname(__FILE__)).'/config.php');
$vl="";
// Коннектикут в базИ
$conn = new mysqli(DB_HOSTNAME, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$x = ["синий", "красный", "прекрасный"];
foreach ($x as $vl) {
$Value[$vl] = цена красивого ;
$Value["Code$vl"] =код красивого ;
//добавляем
$sql = "INSERT INTO tablicka SET code = '" .$Value["Code$vl"]. "',
value = '" . $Value[$vl] . "',
date_modified = '" . date("d.m.Y", strtotime($newdate) ) . "' " ;
if ($conn->query($sql) === TRUE) {
} else {
echo "Error updating record: " . $conn->error;
}
}
//удаляем ^-^
$xday = ($newdate-$datestamp);
$x=(3*$xday)-2;
for ( $i = $x; $i < ($x+3); $i++){
$sql = "DELETE FROM tablicka WHERE key_id = '".$i."' ";
if (mysqli_query($conn, $sql)) {
} else {
echo "Error deleting record: " . mysqli_error($conn);
}
}
//закрываем ^-^
$conn->close();1+key_id_orig-min(key_id_orig)