ps('name'), 'slug' => $slug, 'category_id' => (int)p('category_id'), 'subcategory' => ps('subcategory'), 'description' => ps('description'), 'address' => ps('address'), 'phone' => ps('phone'), 'email' => ps('email'), 'website' => ps('website'), 'hours' => json_encode($hrs), 'lat' => (float)p('lat', 39.4364), 'lng' => (float)p('lng', -78.9762), 'is_active' => (int)p('is_active', 1), 'is_featured' => (int)p('is_featured', 0), ]; try { $setClauses = implode(', ', array_map(fn($k) => "$k=?", array_keys($updates))); $sql = "UPDATE businesses SET $setClauses WHERE id=?"; $params = array_merge(array_values($updates), [$id]); $stmt = db()->prepare($sql); $stmt->execute($params); $affected = $stmt->rowCount(); $msg = "Saved successfully ($affected row updated). SQL: $sql"; } catch (\Throwable $ex) { $err = 'DB ERROR: '.$ex->getMessage(); } } render: // ── Load business ──────────────────────────────────────── $biz = $id ? qone("SELECT * FROM businesses WHERE id=?", [$id]) : null; $cats = qall("SELECT * FROM categories ORDER BY sort_order"); $days = ['Mon','Tue','Wed','Thu','Fri','Sat','Sun']; $h = $biz ? parseHours($biz['hours']) : []; // All businesses for the picker $all = qall("SELECT id, name FROM businesses ORDER BY name"); ?>

SELECT BUSINESS TO EDIT

Or go directly: /admin/biz_edit.php?id=N

EDITING: (ID )

NAME *

SLUG

Select a business above to begin editing