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: 3_content.php

<div class="content-header">
    <div class="container-fluid">
        <div class="row mb-2">
            <div class="col-sm-6">
                <h1 class="m-0">Partnership 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 getTotalPartners(); ?></h3>
                        <p>Total Partners</p>
                    </div>
                </div>
            </div>
            
            <div class="col-lg-3 col-6">
                <div class="small-box bg-success">
                    <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">Partnership Data</h3>
            </div>
            <div class="card-body">
                <table id="partnershipTable" class="table table-bordered table-hover">
                    <thead>
                        <tr>
                            <th>ID</th>
                            <th>Partner Name</th>
                            <th>Member Count</th>
                            
                        </tr>
                    </thead>
                    <tbody>
                        <?php echo getPartnershipTable(); ?>
                    </tbody>
                </table>
            </div>
        </div>
        
    </div>
    
</section>

<?php
// Function to get total partners
function getTotalPartners() {
    global $conn;
    $sql = "SELECT COUNT(*) AS total_partners FROM partners";
    $result = $conn->query($sql);

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

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

// 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 partnership table data (replace with your database query)
function getPartnershipTable() {
    global $conn;
    $query = "SELECT * FROM partners";
    $result = $conn->query($query);

$tableData = '';

if ($result && $result->num_rows > 0) {
        while ($row = $result->fetch_assoc()) {
            $tableData .= "<tr>
                            <td>{$row['id']}</td>
                            <td>{$row['partner_name']}</td>
                            <td>{$row['member_count']}</td>
                            
                          </tr>";
        }
    } else {
        $tableData = "<tr><td colspan='3'>No partnership data found</td></tr>";
    }

return $tableData;
}

// 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";
    }
}

// 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";
    }
}
?>

X7ROOT File Manager

Editing: 3_content.php

Upload File

Create Folder