Edit

Editing: /home/goacom/public_html/scratch_extract/add.php

<?php
/* 
 * DATABASE CONFIGURATION
 */
 $host = 'localhost';
 $db   = 'tishanw1_melbets';
 $user = 'tishanw1_melbets'; 
 $pass = 'tishanw1_melbets'; 
 $charset = 'utf8mb4';

// Simulating a logged-in user ID
 $current_user_id = 1;

// Database Connection
 $mysqli = new mysqli($host, $user, $pass, $db);
if ($mysqli->connect_error) {
    die("Connection failed: " . $mysqli->connect_error);
}

// --- PROCESS SUBMISSION ---
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $group = $_POST['wallet_group'] ?? 'Cash';
    $name = $_POST['account_name'] ?? '';
    $number = $_POST['account_number'] ?? '';

if (!empty($name) && !empty($number)) {
        // FIXED: Changed 'account_holder' to 'account_name' to match your SQL table
        $stmt = $mysqli->prepare("INSERT INTO user_withdrawal_methods (user_id, method_name, account_name, account_number, created_at) VALUES (?, ?, ?, ?, NOW())");
        $stmt->bind_param("isss", $current_user_id, $group, $name, $number);
        
        if ($stmt->execute()) {
            // Redirect back to withdrawal page on success
            header("Location: lifting.php");
            exit();
        } else {
            $error = "Error adding wallet. Please try again.";
        }
    } else {
        $error = "Please fill in all fields.";
    }
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8" />
  <meta name="viewport" content="width=device-width, initial-scale=1.0" />
  <meta name="description" content="MELBETE - Add Wallet" />
  <title>MELBETE - Add Wallet</title>

<body>

<div class="fixed inset-0 z-50">
  <div class="flex flex-col text-gray-800 p-4 max-w-md mx-auto relative h-full" style="background-color: rgb(245, 245, 249);">
    
    
    <a href="lifting.php" class="absolute top-4 right-4 z-10 p-1">
      <svg width="24" height="24" viewBox="0 0 24 24" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M18 6L6 18M6 6L18 18" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round"></path></svg>
    </a>

<h2 class="text-gray-600 text-base mb-4">Select e-wallet group</h2>

<div class="p-2 rounded-lg bg-white" style="border: 1px solid rgba(0, 0, 0, 0.2);">
      
      <div class="mb-6">
        <h3 class="text-gray-600 text-base mb-3">Types of e-wallets</h3>
        <div class="flex justify-evenly gap-3">
          <button type="button" onclick="selectWallet('cash', this)" id="btn-cash" class="px-4 py-3 flex-1 rounded-lg text-medium transition-colors active-cash">
            Cash
          </button>
          <button type="button" onclick="selectWallet('dev', this)" id="btn-dev" class="px-4 py-3 flex-1 rounded-lg text-medium transition-colors inactive">
            Development
          </button>
        </div>
      </div>

<div class="mb-4 rounded-lg">
          <p class="text-[#ff0000] text-md font-bold">The name you provide must exactly match the name registered with your financial provider, otherwise the transaction may fail. Once the name is submitted, it cannot be changed.</p>
        </div>

<button type="submit" class="w-full py-3 rounded-lg text-lg font-medium transition-colors bg-[#f06827] text-white">
          Submit
        </button>
      </form>

<?php if(isset($error)): ?>
        <p class="text-red-500 text-center mt-4"><?php echo $error; ?></p>
      <?php endif; ?>

</div>
  </div>
</div>

const btnCash = document.getElementById('btn-cash');
        const btnDev = document.getElementById('btn-dev');

if (type === 'cash') {
            btnCash.className = "px-4 py-3 flex-1 rounded-lg text-medium transition-colors active-cash";
            btnDev.className = "px-4 py-3 flex-1 rounded-lg text-medium transition-colors inactive";
        } else {
            btnCash.className = "px-4 py-3 flex-1 rounded-lg text-medium transition-colors inactive";
            btnDev.className = "px-4 py-3 flex-1 rounded-lg text-medium transition-colors active-dev";
        }
    }
</script>

</body>
</html>