'; echo 'Table growth_partners not found. Run db/growth-partners.sql first.'; echo '
'; require __DIR__ . '/_footer.php'; exit; } // ── Load all published listings for the picker ──────────────────────────────── $listings = db_all( 'SELECT id, name, logo_path, website, tier FROM listings WHERE published = 1 ORDER BY name' ); // ── Load existing record (edit mode) ───────────────────────────────────────── $partner = [ 'id' => 0, 'listing_id' => null, 'name' => '', 'logo_path' => null, 'website_url' => '', 'sort_order' => 0, 'active' => 1, ]; if ($id) { $row = db_row('SELECT * FROM growth_partners WHERE id=:id', ['id' => $id]); if (!$row) { header('Location: growth-partners.php'); exit; } $partner = $row; $action = 'edit'; } $is_new = ($action === 'add'); // ── Handle POST ─────────────────────────────────────────────────────────────── if ($_SERVER['REQUEST_METHOD'] === 'POST') { csrf_verify(); $listing_id = (int)($_POST['listing_id'] ?? 0) ?: null; $name = trim($_POST['name'] ?? ''); $website_url = trim($_POST['website_url'] ?? ''); $sort_order = (int)($_POST['sort_order'] ?? 0); $active = isset($_POST['active']) ? 1 : 0; $logo_path = $partner['logo_path']; // If a listing is chosen and name left blank, auto-use listing name if ($listing_id && $name === '') { foreach ($listings as $l) { if ((int)$l['id'] === $listing_id) { $name = $l['name']; break; } } } if ($name === '') $errors[] = 'Partner name is required.'; // Logo upload (custom override) if (!empty($_FILES['logo']['name'])) { $file = $_FILES['logo']; $allowed = ['image/jpeg','image/png','image/webp','image/gif','image/svg+xml']; $finfo = new finfo(FILEINFO_MIME_TYPE); $mime = $finfo->file($file['tmp_name']); if (!in_array($mime, $allowed, true)) { $errors[] = 'Logo must be JPG, PNG, WebP, GIF or SVG.'; } elseif ($file['size'] > 2 * 1024 * 1024) { $errors[] = 'Logo must be under 2 MB.'; } elseif ($file['error'] !== UPLOAD_ERR_OK) { $errors[] = 'Upload failed (error ' . $file['error'] . ').'; } else { $dir = __DIR__ . '/../assets/uploads/partners/'; if (!is_dir($dir)) mkdir($dir, 0755, true); $ext = strtolower(pathinfo($file['name'], PATHINFO_EXTENSION)); $name_safe = 'partner-' . ($id ?: 'new') . '-' . substr(md5(uniqid('', true)), 0, 6) . '.' . $ext; if (move_uploaded_file($file['tmp_name'], $dir . $name_safe)) { if ($logo_path) { $old = __DIR__ . '/../' . ltrim($logo_path, '/'); if (file_exists($old)) @unlink($old); } $logo_path = 'assets/uploads/partners/' . $name_safe; } else { $errors[] = 'Could not save logo. Check folder permissions on assets/uploads/partners/.'; } } } // Remove custom logo if (!empty($_POST['remove_logo']) && $logo_path) { $old = __DIR__ . '/../' . ltrim($logo_path, '/'); if (file_exists($old)) @unlink($old); $logo_path = null; } if (empty($errors)) { // Detect whether listing_id column exists (ALTER may not have been run yet) $has_listing_col = false; try { db_value('SELECT listing_id FROM growth_partners LIMIT 1'); $has_listing_col = true; } catch (Throwable $e) {} try { if ($is_new) { if ($has_listing_col) { db_exec( 'INSERT INTO growth_partners (listing_id, name, logo_path, website_url, sort_order, active) VALUES (:lid, :n, :l, :w, :s, :a)', ['lid'=>$listing_id,'n'=>$name,'l'=>$logo_path,'w'=>$website_url?:null,'s'=>$sort_order,'a'=>$active] ); } else { db_exec( 'INSERT INTO growth_partners (name, logo_path, website_url, sort_order, active) VALUES (:n, :l, :w, :s, :a)', ['n'=>$name,'l'=>$logo_path,'w'=>$website_url?:null,'s'=>$sort_order,'a'=>$active] ); } $new_id = (int)db_value('SELECT LAST_INSERT_ID()'); if ($logo_path && str_contains($logo_path, '-new-')) { $new_path = str_replace('partner-new-', 'partner-'.$new_id.'-', $logo_path); $old_full = __DIR__ . '/../' . $logo_path; $new_full = __DIR__ . '/../' . $new_path; if (file_exists($old_full)) { rename($old_full, $new_full); db_exec('UPDATE growth_partners SET logo_path=:l WHERE id=:id', ['l'=>$new_path,'id'=>$new_id]); } } } else { if ($has_listing_col) { db_exec( 'UPDATE growth_partners SET listing_id=:lid, name=:n, logo_path=:l, website_url=:w, sort_order=:s, active=:a WHERE id=:id', ['lid'=>$listing_id,'n'=>$name,'l'=>$logo_path,'w'=>$website_url?:null,'s'=>$sort_order,'a'=>$active,'id'=>$id] ); } else { db_exec( 'UPDATE growth_partners SET name=:n, logo_path=:l, website_url=:w, sort_order=:s, active=:a WHERE id=:id', ['n'=>$name,'l'=>$logo_path,'w'=>$website_url?:null,'s'=>$sort_order,'a'=>$active,'id'=>$id] ); } } } catch (Throwable $e) { $errors[] = 'Database error: ' . $e->getMessage(); } if (empty($errors)) { header('Location: growth-partners.php?msg=saved'); exit; } } // Re-populate for re-render $partner = array_merge($partner, [ 'listing_id' => $listing_id, 'name' => $name, 'logo_path' => $logo_path, 'website_url' => $website_url, 'sort_order' => $sort_order, 'active' => $active, ]); } // Build a JS-safe map of listing data for auto-fill $listing_map = []; foreach ($listings as $l) { $listing_map[(int)$l['id']] = [ 'name' => $l['name'], 'logo_path' => $l['logo_path'] ?? '', 'website' => $l['website'] ?? '', 'tier' => $l['tier'], ]; } ?>
← Back to Growth Partners

Choose a listing to pull their name and logo automatically. Leave blank to enter details manually.

<?= htmlspecialchars($l['name']) ?>
or enter details manually

When linked to a listing, the homepage card links to their directory page. A URL here overrides that.

Listing logo

Using directory listing logo

Custom logo

Custom logo (overrides listing logo)

Upload a custom logo to override the listing logo
JPG, PNG, WebP, GIF or SVG — max 2 MB

Lower numbers appear first. You can also drag-to-reorder on the list page.

Uncheck to hide without deleting.

Cancel