Посмотрите на этот код, где-то он не работает. Если понимаете, исправьте, пожалуйста!!!
$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; ?>