File Manager

Editing:TeamMember.php

<?php
class TeamMember {
  private $db;

public function __construct(){
    $this->db = new Database;
  }

// Get all team members
  public function getTeamMembers(){
    $this->db->query('SELECT * FROM team_members ORDER BY order_index ASC, id DESC');
    return $this->db->resultSet();
  }

// Get team members with pagination
  public function getTeamMembersPaginated($limit, $offset){
    $this->db->query('SELECT * FROM team_members ORDER BY order_index ASC, id DESC LIMIT :limit OFFSET :offset');
    $this->db->bind(':limit', $limit);
    $this->db->bind(':offset', $offset);
    return $this->db->resultSet();
  }

// Get total count of team members
  public function getTeamMembersCount(){
    $this->db->query('SELECT COUNT(*) as count FROM team_members');
    $row = $this->db->single();
    return $row ? $row->count : 0;
  }

// Get team member by ID
  public function getTeamMemberById($id){
    $this->db->query('SELECT * FROM team_members WHERE id = :id');
    $this->db->bind(':id', $id);
    return $this->db->single();
  }

// Add Team Member
  public function addTeamMember($data){
    $this->db->query('INSERT INTO team_members (name, designation, photo_url, order_index) VALUES (:name, :designation, :photo_url, :order_index)');
    $this->db->bind(':name', $data['name']);
    $this->db->bind(':designation', $data['designation']);
    $this->db->bind(':photo_url', $data['photo_url']);
    $this->db->bind(':order_index', $data['order_index']);

if($this->db->execute()){
      return true;
    } else {
      return false;
    }
  }

// Update Team Member
  public function updateTeamMember($data){
    $this->db->query('UPDATE team_members SET name = :name, designation = :designation, photo_url = :photo_url, order_index = :order_index WHERE id = :id');
    $this->db->bind(':id', $data['id']);
    $this->db->bind(':name', $data['name']);
    $this->db->bind(':designation', $data['designation']);
    $this->db->bind(':photo_url', $data['photo_url']);
    $this->db->bind(':order_index', $data['order_index']);

if($this->db->execute()){
      return true;
    } else {
      return false;
    }
  }

// Delete Team Member
  public function deleteTeamMember($id){
    $this->db->query('DELETE FROM team_members WHERE id = :id');
    $this->db->bind(':id', $id);

if($this->db->execute()){
      return true;
    } else {
      return false;
    }
  }
}

Cancel

🤩 File Manager - Mr.X

Editing:TeamMember.php