芝麻web文件管理V1.00

编辑当前文件:/home/pulsehostuk9/public_html/teafund.pulsehost.co.uk/api/members_search.php

<?php
declare(strict_types=1);
require_once __DIR__ . '/../includes/auth.php';
require_once __DIR__ . '/../includes/db.php';
require_manage();

header('Content-Type: application/json; charset=utf-8');

$q = trim($_GET['q'] ?? '');
$fund_id = isset($_GET['fund_id']) ? (int)$_GET['fund_id'] : 0;
if ($q === '' || mb_strlen($q) < 2) { echo '[]'; exit; }

try {
  $pdo = get_pdo();
  $asId = ctype_digit($q) ? (int)$q : 0;
  $like = '%' . $q . '%';
  $sql = "SELECT m.id, m.name, m.email, m.active, m.fund_id, f.name AS fund_name
          FROM members m
          JOIN funds f ON f.id = m.fund_id
          WHERE (m.name LIKE :like OR m.email LIKE :like OR m.id = :id)";
  if ($fund_id > 0) { $sql .= " AND m.fund_id = :fund_id"; }
  $sql .= " ORDER BY m.active DESC, m.name LIMIT 20";
  $stmt = $pdo->prepare($sql);
  $params = [':like' => $like, ':id' => $asId];
  if ($fund_id > 0) $params[':fund_id'] = $fund_id;
  $stmt->execute($params);
  $rows = $stmt->fetchAll(PDO::FETCH_ASSOC) ?: [];
  echo json_encode(array_map(function($r){
    return [
      'id' => (int)$r['id'],
      'name' => $r['name'],
      'email' => $r['email'],
      'fund' => $r['fund_name'],
      'fund_id' => (int)$r['fund_id'],
      'active' => (int)$r['active']
    ];
  }, $rows));
} catch (Throwable $e) {
  http_response_code(500);
  echo json_encode(['error' => 'server']);
}