prepare("SELECT * FROM companies WHERE user_id = ?"); $stmt->execute([$user_id]); $company = $stmt->fetch(); if ($_SERVER['REQUEST_METHOD'] === 'POST') { $name = trim($_POST['name'] ?? ''); $address = trim($_POST['address'] ?? ''); $currency = trim($_POST['currency'] ?? 'SGD'); $gst_number = trim($_POST['gst_number'] ?? ''); if (empty($name)) { $errors[] = 'Company name is required.'; } if (empty($errors)) { if ($company) { // Update existing record $stmt = $pdo->prepare("UPDATE companies SET name = ?, address = ?, currency = ?, gst_number = ? WHERE user_id = ?"); if ($stmt->execute([$name, $address, $currency, $gst_number, $user_id])) { $success_message = 'Company settings updated successfully!'; } else { $errors[] = 'Failed to update settings. Please try again.'; } } else { // Insert new record $stmt = $pdo->prepare("INSERT INTO companies (user_id, name, address, currency, gst_number) VALUES (?, ?, ?, ?, ?)"); if ($stmt->execute([$user_id, $name, $address, $currency, $gst_number])) { $success_message = 'Company settings saved successfully!'; } else { $errors[] = 'Failed to save settings. Please try again.'; } } // Refresh company data after update/insert $stmt = $pdo->prepare("SELECT * FROM companies WHERE user_id = ?"); $stmt->execute([$user_id]); $company = $stmt->fetch(); } } require_once __DIR__ . '/includes/sidebar.php'; ?>

Company Settings

Use this form to set up or update your company's details. This information will be used on invoices and other official documents.