File Manager

X7ROOT File Manager

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

home / remnbtxp / public_html / members / includes /

📁 ..
📄 2_content.php(7.8 KB)
📄 2_sidebar.php(2.05 KB)
📄 3_content.php(5.26 KB)
📄 3_sidebar.php(1.71 KB)
📄 4_content.php(6.65 KB)
📄 4_sidebar.php(1.88 KB)
📄 5_content.php(6.12 KB)
📄 5_sidebar.php(2.01 KB)
📄 6_content.php(5.54 KB)
📄 6_sidebar.php(1.99 KB)
📄 7_content.php(5.79 KB)
📄 7_sidebar.php(1.65 KB)
📄 manage_donations_content.php(10.09 KB)
📄 manage_expenses_content.php(9.4 KB)
📄 manage_invoices_content.php(9.48 KB)
📄 manage_member_content.php(32.32 KB)
📄 manage_notes_content.php(9.51 KB)
📄 manage_partnerships_content.php(9.5 KB)
📄 manage_task_content.php(10.01 KB)
📄 robots.txt(26 B)

Editing: 4_content.php

<div class="content-header">
    <div class="container-fluid">
        <div class="row mb-2">
            <div class="col-sm-6">
                <h1 class="m-0">Relationship Manager Dashboard</h1>
            </div>
            
        </div>
        
    </div>
    
</div>

<section class="content">
    <div class="container-fluid">
        
        <div class="row">
            
            <div class="col-lg-3 col-6">
                <div class="small-box bg-info">
                    <div class="inner">
                        <h3><?php echo getTotalMembers(); ?></h3>
                        <p>Total Members</p>
                    </div>
                    
                </div>
            </div>
            
            <div class="col-lg-3 col-6">
                <div class="small-box bg-warning">
                    <div class="inner">
                        <h3><?php echo getPendingTasks(); ?></h3>
                        <p>Pending Tasks</p>
                    </div>
                    
                </div>
            </div>
            
            <div class="col-lg-3 col-6">
                <div class="small-box bg-success">
                    <div class="inner">
                        <h3><?php echo getCompletedTasks(); ?></h3>
                        <p>Completed Tasks</p>
                    </div>
                    
                </div>
            </div>
            
        </div>

<div class="card">
            <div class="card-header">
                <h3 class="card-title">Members Table</h3>
            </div>
            
            <div class="card-body">
                <table id="membersTable" class="table table-bordered table-hover">
                    <thead>
                        <tr>
                        <th>ID</th>
                        <th>Name</th>
                        <th>O. Names</th>
                        <th>Mobile</th>
                        <th>Telephone</th>
                        <th>Email</th>
                        <th>DOB</th>
                        <th>Occupation</th>
                        <th>Next Of Kin</th>
                            
                        </tr>
                    </thead>
                    <tbody>
                        <?php echo getMembersTable(); ?>
                    </tbody>
                </table>
            </div>
            
        </div>

</div>
    
</section>

<?php
// Function to get total members
function getTotalMembers() {
    global $conn;

$sql = "SELECT COUNT(*) AS total_members FROM members";
    $result = $conn->query($sql);

if ($result && $result->num_rows > 0) {
        $row = $result->fetch_assoc();
        return $row['total_members'];
    }

return 0; // Return 0 if there are no members
}

// Function to fetch members table data (replace with your database query)
function getMembersTable() {
    global $conn; // Assuming $conn is your database connection object

// Query to select data from the members table
    $query = "SELECT * FROM members";

// Execute the query
    $result = $conn->query($query);

// Initialize an empty string to store table data
    $tableData = '';

// Check if there are any results
    if ($result && $result->num_rows > 0) {
        // Loop through each row in the result set
        while ($row = $result->fetch_assoc()) {
            // Append data from each row to the tableData string
            $tableData .= "<tr>
                <td>{$row['id']}</td>
                <td>{$row['memberName']}</td>
                <td>{$row['memberOtherNames']}</td>
                <td>{$row['memberMobile']}</td>
                <td>{$row['memberTelephone']}</td>
                <td>{$row['memberEmail']}</td>
                <td>{$row['memberDOB']}</td>
                <td>{$row['memberOccupation']}</td>
                <td>{$row['memberAddress1']}</td>
                <td>{$row['memberAddress2']}</td>
                <td>{$row['memberCityCounty']}</td>
                <td>{$row['memberCountry']}</td>
                <td>{$row['memberNextOfKin']}</td>
                <td>{$row['memberNextOfKinMobile']}</td>
                <td>{$row['NOKAddress1']}</td>
                <td>{$row['NOKAddress2']}</td>
                <td>{$row['NOKCityCounty']}</td>
                <td>{$row['NOKCountry']}</td>
                <td>{$row['socialMedia']}</td>
                <td>{$row['weekdayCallTime']}</td>
                <td>{$row['weekEndCallTime']}</td>
                <td>{$row['contactChoice']}</td>
                <td>{$row['connectAsFamily']}</td>
                <td>{$row['partnerType']}</td>
                <td>{$row['volunteerPartnership']}</td>
                <td>{$row['donationOption']}</td>
                <td>{$row['ministryOption']}</td>
                <td>{$row['otherMinistryDonation']}</td>
                <td>{$row['created_at']}</td>
                
            </tr>";
        }
    } else {
        // If no members found, display a message
        $tableData = "<tr><td colspan='3'>No Members found</td></tr>";
    }

// Return the tableData string
    return $tableData;
}

// Function to fetch pending tasks (replace with your database query)
function getPendingTasks() {
    global $conn;
    $query = "SELECT COUNT(*) AS pendingTasks FROM tasks WHERE task_status = 'Pending'";
    $result = $conn->query($query);

if ($result) {
        $row = $result->fetch_assoc();
        return $row['pendingTasks'];
    } else {
        return "Error fetching pending tasks";
    }
}

// Function to fetch completed tasks (replace with your database query)
function getCompletedTasks() {
    global $conn;
    $query = "SELECT COUNT(*) AS completedTasks FROM tasks WHERE task_status = 'Completed'";
    $result = $conn->query($query);

if ($result) {
        $row = $result->fetch_assoc();
        return $row['completedTasks'];
    } else {
        return "Error fetching completed tasks";
    }
}
?>

X7ROOT File Manager

Editing: 4_content.php

Upload File

Create Folder