query('SELECT * FROM posts ORDER BY id ASC')->fetchAll();
foreach($posts as $post) {
$message = preg_replace(
'//',
'',
$post['message']
);
if ($message != $post['message']) {
echo "Post #".$post['id']."\n";
echo "SOURCE\n";
echo $post['message']."\n";
echo "CHANGED\n";
echo $message."\n\n";
if (isset($_GET['apply'])) {
$update = $db->prepare('UPDATE posts SET message=? WHERE id=?');
$update->execute(array(
$message,
$post['id']
));
}
}
}