При чём тут мои или чьито способности
try {
$pdo->beginTransaction();
$ids = $pdo->query('SELECT id FROM `comments` where news_id = 77278 and dateAdd < (NOW() - INTERVAL 2 DAY')->fetchAll(\PDO::FETCH_COLUMN);
$stmtInsert = $pdo->prepare('INSERT INTO table(column1, column2) SELECT column1, column2 FROM table2 WHERE table2.id = :id');
foreach ($ids as $id) {
$stmtInsert->execute(['id' => $id]);
}
$stmtDelete = $pdo->prepare('DELETE FROM table2 WHERE id = :id');
foreach ($ids as $id) {
$stmtDelete->execute(['id' => $id]);
}
$pdo->commit();
} catch (PDOException $e) {
$pdo->rollBack();
// $logger->error($e->getMessage());
}
INSERT INTO table2 (column1, column2, column3, ...)
SELECT column1, column2, column3, ...
FROM table1
WHERE condition;
Форма
Обработчик:
Экшен: