prepare(" SELECT project_id, project_name, client_name FROM projects WHERE project_id = ? AND client_id = ? "); $stmt->execute([$project_id, $client_id]); $project = $stmt->fetch(PDO::FETCH_ASSOC); if (!$project) { header('Location: projects-list.php'); exit; } // Get batches for this project $stmt = $shopPdo->prepare(" SELECT batch_number, total_urls, sent_count, upload_type, created_at FROM survey_url_batches WHERE project_id = ? ORDER BY batch_number DESC "); $stmt->execute([$project_id]); $batches = $stmt->fetchAll(PDO::FETCH_ASSOC); } catch (Exception $e) { $error = "Error loading project: " . $e->getMessage(); } $page_title = "Manage Survey URLs"; ?>
No survey URLs uploaded yet. Add your first batch above.