"; echo "

Fixing Database for Online Server...

"; // 1. Fix Notices Table Columns $queries = [ "ALTER TABLE `notices` ADD COLUMN IF NOT EXISTS `category` varchar(100) DEFAULT 'General' AFTER `id` text", "ALTER TABLE `notices` ADD COLUMN IF NOT EXISTS `image` varchar(255) DEFAULT '' AFTER `title`", "ALTER TABLE `notices` ADD COLUMN IF NOT EXISTS `content` longtext AFTER `image`", "ALTER TABLE `notices` ADD COLUMN IF NOT EXISTS `pdf_file` varchar(255) DEFAULT '' AFTER `content`" ]; // Wait, the first query had a typo in my previous thought (id text?). Let me fix it. $queries = [ "ALTER TABLE `notices` ADD COLUMN IF NOT EXISTS `category` varchar(100) DEFAULT 'General' AFTER `id` ", "ALTER TABLE `notices` ADD COLUMN IF NOT EXISTS `image` varchar(255) DEFAULT '' AFTER `title` ", "ALTER TABLE `notices` ADD COLUMN IF NOT EXISTS `content` longtext AFTER `image` ", "ALTER TABLE `notices` ADD COLUMN IF NOT EXISTS `pdf_file` varchar(255) DEFAULT '' AFTER `content` " ]; echo "

1. Updating Notices Table:

"; foreach ($queries as $q) { try { if ($conn->query($q)) { echo "

SUCCESS: Column check/add.

"; } } catch (Exception $e) { echo "

INFO: Column already exists or handled.

"; } } // 2. Fix Board Members Table & Data echo "

2. Updating Board Members (Officers Section):

"; $conn->query("CREATE TABLE IF NOT EXISTS `board_members` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `designation` varchar(100) NOT NULL, `cell` varchar(50) NOT NULL, `image` varchar(255) NOT NULL, `description` text, `sort_order` int(11) DEFAULT '0', `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;"); // Check if we need to insert dummy/local data $check = $conn->query("SELECT id FROM board_members LIMIT 1"); if ($check->num_rows == 0) { echo "

Populating Board Members table with local data...

"; $members = [ ['name' => 'Mrs. Pallavi Antwadiya', 'designation' => 'President', 'cell' => 'BOARD MINISTERS', 'image' => 'president_pallavi.png', 'sort_order' => 1], ['name' => 'Rahul Sharma', 'designation' => 'Secretary', 'cell' => 'BOARD MINISTERS', 'image' => 'secretary_rahul.png', 'sort_order' => 2], ['name' => 'Mr. Rajiv', 'designation' => 'Dist President', 'cell' => 'STATE', 'image' => 'indian_male_1.png', 'sort_order' => 5], ['name' => 'Ms. Sneha', 'designation' => 'Dist President', 'cell' => 'STATE', 'image' => 'indian_female_1.png', 'sort_order' => 6], ['name' => 'Mr. Amit', 'designation' => 'Dist President', 'cell' => 'STATE', 'image' => 'indian_male_1.png', 'sort_order' => 7], ['name' => 'Dr. Pooja', 'designation' => 'Dist President', 'cell' => 'STATE', 'image' => 'indian_female_1.png', 'sort_order' => 8], ['name' => 'Mr. Sameer', 'designation' => 'Dist President', 'cell' => 'STATE', 'image' => 'indian_male_1.png', 'sort_order' => 9], ['name' => 'SHALINI RANI', 'designation' => 'Advocate', 'cell' => 'LEGAL', 'image' => 'adv_female.png', 'sort_order' => 1], ['name' => 'Adv Nitin', 'designation' => 'Advocate High Court', 'cell' => 'LEGAL', 'image' => 'adv_female.png', 'sort_order' => 2], ['name' => 'Adv Sandeep', 'designation' => 'Advocate High Court', 'cell' => 'LEGAL', 'image' => 'adv_male.png', 'sort_order' => 3], ['name' => 'Adv Naveen', 'designation' => 'Advocate High Court', 'cell' => 'LEGAL', 'image' => 'adv_female.png', 'sort_order' => 4], ['name' => 'Adv Rajesh', 'designation' => 'Advocate High Court', 'cell' => 'LEGAL', 'image' => 'adv_male.png', 'sort_order' => 5], ['name' => 'Rajesh Kumar', 'designation' => 'Media In-charge', 'cell' => 'MEDIA', 'image' => 'indian_young_female.png', 'sort_order' => 1], ['name' => 'Sita Singh', 'designation' => 'Public Relations', 'cell' => 'MEDIA', 'image' => 'indian_young_male.png', 'sort_order' => 2], ['name' => 'Amit Verma', 'designation' => 'Social Media Manager', 'cell' => 'MEDIA', 'image' => 'indian_young_female.png', 'sort_order' => 3], ]; foreach ($members as $m) { $stmt = $conn->prepare("INSERT INTO board_members (name, designation, cell, image, sort_order) VALUES (?, ?, ?, ?, ?)"); $stmt->bind_param("ssssi", $m['name'], $m['designation'], $m['cell'], $m['image'], $m['sort_order']); $stmt->execute(); } echo "

SUCCESS: " . count($members) . " members added.

"; } else { echo "

INFO: Board Members table already has data. Skipping population.

"; } echo "

Database fixed! Your content below the slider should now show up correctly on the online server.

"; echo "

Note: Please make sure to upload the uploads/members/ folder to your online server as well.

"; echo "Go back to website"; echo ""; ?>