File Manager

X7ROOT File Manager

Current Path: /home/remnbtxp/public_html/members/ajax

home / remnbtxp / public_html / members / ajax /

📁 ..
📄 add_donations.php(1.29 KB)
📄 add_expenses.php(1.13 KB)
📄 add_invoice.php(1.18 KB)
📄 add_member.php(3.38 KB)
📄 add_notes.php(538 B)
📄 add_task.php(1.22 KB)
📄 delete_donations.php(673 B)
📄 delete_expenses.php(664 B)
📄 delete_invoice.php(664 B)
📄 delete_member.php(1.09 KB)
📄 delete_notes.php(0 B)
📄 delete_task.php(645 B)
📄 edit_donations.php(1.47 KB)
📄 edit_expenses.php(2.71 KB)
📄 edit_invoice.php(1.35 KB)
📄 edit_member.php(3.84 KB)
📄 edit_notes.php(0 B)
📄 edit_task.php(1.12 KB)
📄 error_log(5.43 KB)
📄 fetch_members.php(932 B)
📄 get_expense_details.php(826 B)
📄 get_member.php(809 B)
📄 get_member_details.php(312 B)
📄 get_notes.php(468 B)
📁 qw
📄 submit_member.php(3.46 KB)

Editing: edit_expenses.php

<?php
// Include your database connection file here
require_once("../config.php");

$expenseId = "";
$expenseType = "";
$expenseAmount = "";
$expenseDate = "";

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // Retrieve and sanitize input data
    $expenseId = mysqli_real_escape_string($conn, $_POST['editExpenseSelect']);
    $expenseAmount = mysqli_real_escape_string($conn, $_POST['editExpenseAmount']);
    $expenseType = mysqli_real_escape_string($conn, $_POST['editExpenseType']);
    $expenseDate = mysqli_real_escape_string($conn, $_POST['editExpenseDate']);

// Update the expenses table (replace with your actual table name)
    $query = "UPDATE expenses SET amount='$expenseAmount', expense_type='$expenseType', expense_date='$expenseDate' WHERE expense_id='$expenseId'";

if ($conn->query($query) === TRUE) {
        // Redirect to a success page or perform any other action
        header('Location: /members/manage_expenses.php');
        exit;
    } else {
        echo "Error updating expenses: " . $conn->error;
    }
}

// Retrieve and populate expense details for editing
if ($_SERVER["REQUEST_METHOD"] == "GET" && isset($_GET['expense_id'])) {
    $expenseId = mysqli_real_escape_string($conn, $_GET['expense_id']);

// Fetch the expense details based on the expense ID
    $query = "SELECT * FROM expenses WHERE expense_id='$expenseId'";
    $result = $conn->query($query);

if ($result->num_rows > 0) {
        $expense = $result->fetch_assoc();
        $expenseAmount = $expense['amount'];
        $expenseType = $expense['expense_type'];
        $expenseDate = $expense['expense_date'];
    } else {
        echo "Expense not found.";
        exit;
    }
}

// Function to populate dropdown with expense options
function getExpenseOptions($conn) {
    // Initialize an empty string to store the HTML options
    $options = '';

// Retrieve expense options from the database
    $query = "SELECT expense_id, expense_name FROM expenses";
    $result = $conn->query($query);

// Check if there are any results
    if ($result->num_rows > 0) {
        // Loop through each row to create options
        while ($row = $result->fetch_assoc()) {
            // Escape HTML entities to prevent XSS attacks
            $expenseId = htmlspecialchars($row['expense_id']);
            $expenseName = htmlspecialchars($row['expense_name']);

// Append the option to the options string
            $options .= "<option value='$expenseId'>$expenseName</option>";
        }
    } else {
        // No expenses found
        $options = "<option value=''>No expenses found</option>";
    }

// Return the generated HTML options
    return $options;
}

X7ROOT File Manager

Editing: edit_expenses.php

Upload File

Create Folder