Просмотр поста

# Senje (29.01.2026 / 02:27)
Unlover, Отформатировать бы сообщение, конечно 

$stmtD = $pdo->prepare("SELECT * FROM `download__files` ORDER BY id DESC");

[/code][code=php]

// Change 'articles' to your table name

$stmt->execute();

$stmtD->execute();

// Fetch all rows as an associative array

$rows = $stmtD->fetchAll(PDO::FETCH_ASSOC);

// If no rows, show a message

if (empty($rows)) {

echo "No articles found in the database.";

} else {

echo "Article Links:";

// Loop through each row and echo the link

foreach ($rows as $row) {

// Escape outputs for safety

$safe_id = (int)$row['id'];  // Cast to int for security

$safe_name = htmlspecialchars($row['name'], ENT_QUOTES, 'UTF-8');

$safe_nameT = htmlspecialchars($row['rus_name'], ENT_QUOTES, 'UTF-8');

echo '[url=/downloads/?act=view&id=' . (int)$safe_id . ']' . $safe_name . ' [/url]
';

echo '[url=/downloads/?act=view&id=' . (int)$safe_id . ']' . $safe_nameT . ' [/url]
';

[/code][code=php]        }

}

} catch (PDOException $e) {

// Handle connection or query errors

echo "Error: " . $e->getMessage() . "";

}

[/code][code=php]// Close the connection (PDO does this automatically at script end)

$pdo = null;

?>