prepare("SELECT id FROM stories WHERE user_id = ? AND story_number = ?"); $checkStmt->bind_param("is", $user_id, $number); $checkStmt->execute(); $checkResult = $checkStmt->get_result(); $checkStmt->close(); if ($checkResult->num_rows > 0) { // UPDATE existing story $updateStmt = $conn->prepare("UPDATE stories SET story_title = ?, category = ?, content = ? WHERE user_id = ? AND story_number = ?"); $updateStmt->bind_param("sssis", $title, $category, $content, $user_id, $number); if ($updateStmt->execute()) { $updateStmt->close(); $conn->close(); header("Location: save_text.php?updated=true"); exit(); } $updateStmt->close(); } else { // INSERT new story $insertStmt = $conn->prepare("INSERT INTO stories (user_id, story_number, story_title, category, content) VALUES (?, ?, ?, ?, ?)"); $insertStmt->bind_param("issss", $user_id, $number, $title, $category, $content); if ($insertStmt->execute()) { $insertStmt->close(); $conn->close(); header("Location: save_text.php?saved=true"); exit(); } $insertStmt->close(); } // Fallback error $conn->close(); header("Location: save_text.php?error=db_fail"); exit(); } // ================================================================= // 3. AJAX HANDLER (Output stories only, then exit) // ================================================================= if (isset($_GET['ajax_load'])) { $offset = (int)($_GET['offset'] ?? 0); $limit = (int)($_GET['limit'] ?? STORY_LOAD_LIMIT); if (!$conn) { // Silent fail for AJAX if DB connection is missing exit; } $search = $_GET['search'] ?? ''; $filter = $_GET['filter'] ?? ''; // Prepare query with filter + search logic $types = "i"; $params = [$user_id]; $query = "SELECT story_number, story_title, category, content FROM stories WHERE user_id = ?"; if (!empty($filter) && $filter !== 'All') { $query .= " AND category = ?"; $types .= "s"; $params[] = $filter; } if (!empty($search)) { $query .= " AND (story_title LIKE ? OR category LIKE ? OR content LIKE ?)"; $types .= "sss"; $searchTerm = "%" . $search . "%"; $params[] = $searchTerm; $params[] = $searchTerm; $params[] = $searchTerm; } $query .= " ORDER BY story_number DESC LIMIT ? OFFSET ?"; $types .= "ii"; $params[] = $limit; $params[] = $offset; $stmt = $conn->prepare($query); // FIX: Use call_user_func_array for binding dynamic parameters by reference if ($stmt && !empty($params)) { $bind_names = [$types]; for ($i = 0; $i < count($params); $i++) { $bind_names[] = &$params[$i]; // Pass parameters by reference } call_user_func_array([$stmt, 'bind_param'], $bind_names); } // END FIX $result = null; if ($stmt && $stmt->execute()) { $result = $stmt->get_result(); $stmt->close(); } else { error_log("AJAX query failed: " . ($stmt ? $stmt->error : 'Statement failed preparation.')); } // Output stories HTML without the main page wrapper if ($result && $result->num_rows > 0) { ob_clean(); // Ensure only the stories HTML is output while ($row = $result->fetch_assoc()) { $num = htmlspecialchars($row['story_number']); $title = htmlspecialchars($row['story_title']); $cat = htmlspecialchars($row['category']); $cont = $row['content']; // NOTE: story-actions now uses class names that align with the provided CSS echo "
Story #$num — $cat

$title

$cont
✏️ Edit 🗑️ Delete
"; } } $conn->close(); exit; } // ================================================================= // 4. MAIN PAGE SETUP (USER-SPECIFIC CATEGORY FETCH) // ================================================================= // Fetching categories *before* output buffer ends $search = $_GET['search'] ?? ''; $filter = $_GET['filter'] ?? ''; $showSuccess = isset($_GET['saved']) && $_GET['saved'] === 'true'; $showUpdateSuccess = isset($_GET['updated']) && $_GET['updated'] === 'true'; $showError = isset($_GET['error']); $categories = ['All']; if (isset($conn)) { $catStmt = $conn->prepare("SELECT DISTINCT category FROM stories WHERE user_id = ? AND category IS NOT NULL AND category != '' ORDER BY category ASC"); $catStmt->bind_param("i", $user_id); $catStmt->execute(); $catResult = $catStmt->get_result(); while ($row = $catResult->fetch_assoc()) { $catName = $row['category']; if (!empty($catName)) { $categories[] = $catName; } } $catStmt->close(); // Do not close $conn here if dynamic_front_menu.php still needs it } ?> Top Teacher Education - My Stories tag. include('dynamic_front_menu.php'); ?>

Saved Stories

❌ An error occurred or required fields were missing. Please try again.

Click on any word to see its meaning, hear the sound, and **save it to your memorization list.** 📝

📚 View Memorized Words
Filter by Category"; // Show category filter buttons echo "
"; foreach ($categories as $cat) { $isActive = (empty($filter) && $cat === 'All') || ($filter === $cat); $activeStyle = $isActive ? 'background-color: #2ecc71;' : 'background-color: #3498db;'; $url = ($cat === 'All') ? 'save_text.php' : 'save_text.php?filter=' . urlencode($cat); // Also retain the search query if active if (!empty($search) && $cat !== 'All') { $url .= '&search=' . urlencode($search); } elseif (!empty($search) && $cat === 'All') { // Retain search when clicking 'All' $url .= '?search=' . urlencode($search); } echo "$cat"; } echo "
"; ?>