File Manager

X7ROOT File Manager

Current Path: /home/u126090504/domains/saiadarshainternationalschool.org.in/public_html

home / u126090504 / domains / saiadarshainternationalschool.org.in / public_html /

📁 ..
📄 .htaccess(0 B)
📄 Antiraging-Cell.php(2.73 KB)
📄 SVM-INT (1) (1).zip(117.51 MB)
📄 about-us.php(5.86 KB)
📄 academic-calendar.php(2.73 KB)
📄 achievements.php(9.56 KB)
📄 achievers.php(15.19 KB)
📁 admin
📄 admission-process.php(6.85 KB)
📄 admission.php(12.93 KB)
📄 admission_submit.php(3.38 KB)
📄 album.php(890 B)
📄 assessment-policy.php(6.8 KB)
📄 cbse-curriculum-summary.php(5.99 KB)
📄 computer-courses.php(22.83 KB)
📄 config.php(1.27 KB)
📄 contact-us.php(14.63 KB)
📄 contactdb.php(796 B)
📄 courses.php(10.44 KB)
📁 css
📄 director's-message.php(6.54 KB)
📄 downloads.php(2.9 KB)
📄 error.log(14.6 KB)
📄 facilities.php(6.04 KB)
📄 faculty.php(10.27 KB)
📄 fee-structure.php(7.97 KB)
📁 fonts
📄 footer.php(23.95 KB)
📄 franchise.php(2.09 KB)
📄 gallery.php(3.05 KB)
📄 google929b505e9f42f894.html(53 B)
📄 grievance-form.php(16.52 KB)
📄 header.php(19.69 KB)
📄 homework.php(9.64 KB)
📁 images
📄 index.php(39.38 KB)
📄 infrastructure-details.php(5.39 KB)
📁 js
📁 lib
📄 managing-committee.php(3.34 KB)
📄 media-corner.php(2.48 KB)
📄 non-academic-achievers.php(14.65 KB)
📄 payment.php(21.85 KB)
📄 payment_submit.php(15.1 KB)
📄 payment_verify.php(2.31 KB)
📄 placement.php(8.33 KB)
📄 principal's-message.php(6.65 KB)
📄 public-disclosure.php(3.38 KB)
📁 qrcodes
📁 revolution
📁 sai
📄 scope.php(14.14 KB)
📄 search_videos.php(1.76 KB)
📄 sitemap.xml(4.69 KB)
📄 subjects-offered.php(6 KB)
📄 submit-grievance.php(3.88 KB)
📁 svm
📄 thank-you.php(1.28 KB)
📄 u126090504_svmint.sql(40.87 KB)
📁 uploads
📄 videos.php(6.87 KB)

Editing: non-academic-achievers.php

<?php
require_once 'config.php';
include 'header.php';

/* ---------- Filters & Pagination ---------- */
$perPage = 9;
$page = max(1, (int)($_GET['page'] ?? 1));
$offset = ($page - 1) * $perPage;

$session = trim($_GET['session'] ?? '');
$activity = trim($_GET['activity'] ?? '');
$q = trim($_GET['q'] ?? '');

$where = ["status='active'"];
$params = [];
$types  = '';

if ($session !== '') { $where[] = "session_year = ?"; $params[] = $session; $types .= 's'; }
if ($activity !== '') { $where[] = "activity = ?"; $params[] = $activity; $types .= 's'; }
if ($q !== '') {
  $where[] = "(name LIKE ? OR activity LIKE ? OR achievement LIKE ? OR org LIKE ?)";
  $s = "%{$q}%";
  array_push($params, $s, $s, $s, $s); $types .= 'ssss';
}

$whereSql = 'WHERE ' . implode(' AND ', $where);

/* Distinct filter options */
$sessions = [];
$acts = [];
if ($rs1 = $conn->query("SELECT DISTINCT session_year FROM n_achievers ORDER BY session_year DESC")) {
  while ($r = $rs1->fetch_assoc()) $sessions[] = $r['session_year'];
}
if ($rs2 = $conn->query("SELECT DISTINCT activity FROM n_achievers ORDER BY activity ASC")) {
  while ($r = $rs2->fetch_assoc()) $acts[] = $r['activity'];
}

/* Total count */
$sqlCount = "SELECT COUNT(*) c FROM n_achievers $whereSql";
$stc = $conn->prepare($sqlCount);
if ($types) $stc->bind_param($types, ...$params);
$stc->execute();
$total = (int)$stc->get_result()->fetch_assoc()['c'];
$pages = max(1, (int)ceil($total / $perPage));

/* Data */
$sql = "SELECT id, photo, name, activity, achievement, session_year, org
        FROM n_achievers
        $whereSql
        ORDER BY id DESC
        LIMIT ? OFFSET ?";
$stm = $conn->prepare($sql);
if ($types) {
  $bindTypes = $types . 'ii';
  $bindParams = array_merge($params, [$perPage, $offset]);
  $stm->bind_param($bindTypes, ...$bindParams);
} else {
  $stm->bind_param('ii', $perPage, $offset);
}
$stm->execute();
$res = $stm->get_result();

/* helper for querystring building */
function keepQS($extra = []) {
  $base = $_GET;
  foreach ($extra as $k=>$v) $base[$k] = $v;
  // remove empties
  foreach ($base as $k=>$v) if ($v==='') unset($base[$k]);
  return htmlspecialchars('?' . http_build_query($base));
}
?>

/* pagination */
.naachievers-wrapper .pager {
  display:flex; gap:8px; justify-content:center; align-items:center;
  margin-top: 22px;
}
.naachievers-wrapper .pager a, .naachievers-wrapper .pager span {
  min-width:40px; text-align:center; padding:8px 12px; border-radius:10px; border:1px solid #eee; background:#fff; color:#333; text-decoration:none; font-weight:600;
}
.naachievers-wrapper .pager .active { border-color: var(--accent); color: var(--accent); }

/* modal quick view */
.naachievers-wrapper .modal-body .qv-img {
  width:100%; aspect-ratio: 16/10; object-fit: cover; border-radius: 12px;
}
</style>

<div class="ttm-page-title-row">
  <div class="ttm-page-title-row-inner ttm-textcolor-white">
    <div class="container">
      <div class="row align-items-center">
        <div class="col-lg-12">
          <div class="page-title-heading">
            <h2 class="title">Non-Academic Achievers</h2>
          </div>
       
        </div>
      </div>
    </div>
  </div>
</div>

<div class="site-main naachievers-wrapper">
  <section class="ttm-row clearfix">
    <div class="container">
     
      
      <form class="filterbar mb-3" method="get" action="">
        <div class="form-row">
          <div class="col-md-4 mb-2">
            <label class="mb-1"><strong>Session</strong></label>
            <select name="session" class="custom-select">
              <option value="">All Sessions</option>
              <?php foreach ($sessions as $s): ?>
                <option value="<?= htmlspecialchars($s) ?>" <?= $session===$s?'selected':'' ?>><?= htmlspecialchars($s) ?></option>
              <?php endforeach; ?>
            </select>
          </div>
          <div class="col-md-4 mb-2">
            <label class="mb-1"><strong>Activity</strong></label>
            <select name="activity" class="custom-select">
              <option value="">All Activities</option>
              <?php foreach ($acts as $a): ?>
                <option value="<?= htmlspecialchars($a) ?>" <?= $activity===$a?'selected':'' ?>><?= htmlspecialchars($a) ?></option>
              <?php endforeach; ?>
            </select>
          </div>
          <div class="col-md-4 mb-2">
            <label class="mb-1"><strong>Search</strong></label>
            <div class="input-group">
              <input type="text" name="q" class="form-control" placeholder="Name, achievement, organizer…" value="<?= htmlspecialchars($q) ?>">
              <div class="input-group-append">
                <button class="btn btn-dark" type="submit">Filter</button>
              </div>
            </div>
          </div>
        </div>
        <?php if ($session || $activity || $q): ?>
          <div class="mt-2">
            <a class="btn btn-link p-0" href="<?= htmlspecialchars(strtok($_SERVER['REQUEST_URI'],'?')) ?>">Clear filters</a>
          </div>
        <?php endif; ?>
      </form>

<div class="d-flex justify-content-between align-items-center mb-2">
        <div><strong><?= $total ?></strong> achiever<?= $total==1?'':'s' ?> found</div>
        <div class="small text-muted">Page <?= $page ?> of <?= $pages ?></div>
      </div>

<div class="grid">
        <?php if ($res && $res->num_rows > 0): ?>
          <?php while ($row = $res->fetch_assoc()):
            $photo = htmlspecialchars($row['photo'] ?? '');
            $name  = htmlspecialchars($row['name']);
            $act   = htmlspecialchars($row['activity']);
            $ach   = htmlspecialchars($row['achievement']);
            $sess  = htmlspecialchars($row['session_year']);
            $org   = htmlspecialchars($row['org'] ?? '');
            $img   = $photo ? "uploads/non_academic/{$photo}" : "assets/img/no-image.png";
          ?>
          <article class="cardx">
            <div class="position-relative">
              <img class="thumb" src="<?= $img ?>" alt="<?= $name ?> - <?= $act ?>" onerror="this.src='assets/img/no-image.png'">
              <span class="badge"><?= $sess ?></span>
            </div>
            <div class="content">
              <div class="name"><?= $name ?></div>
              <div class="meta">
                <span class="pill"><i class="fa fa-futbol-o"></i><?= $act ?></span>
                <?php if ($org): ?><span class="pill"><i class="fa fa-map-marker"></i><?= $org ?></span><?php endif; ?>
              </div>
              <div class="ach"><i class="fa fa-trophy"></i> <?= $ach ?></div>

<button
                type="button"
                class="viewbtn"
                data-bs-toggle="modal"
                data-bs-target="#qvModal"
                data-name="<?= $name ?>"
                data-img="<?= $img ?>"
                data-act="<?= $act ?>"
                data-ach="<?= $ach ?>"
                data-sess="<?= $sess ?>"
                data-org="<?= $org ?>">Quick View</button>
            </div>
          </article>
          <?php endwhile; ?>
        <?php else: ?>
          <div class="col-12"><p>No Achievers Found</p></div>
        <?php endif; ?>
      </div>

<?php if ($pages > 1): ?>
        <nav class="pager" aria-label="Pagination">
          <?php
            $prev = max(1, $page-1);
            $next = min($pages, $page+1);
          ?>
          <a href="<?= keepQS(['page'=>1]) ?>">&laquo;</a>
          <a href="<?= keepQS(['page'=>$prev]) ?>">&lsaquo;</a>
          <?php
            $start = max(1, $page-2);
            $end = min($pages, $page+2);
            for ($i=$start; $i<=$end; $i++):
          ?>
            <?php if ($i == $page): ?>
              <span class="active"><?= $i ?></span>
            <?php else: ?>
              <a href="<?= keepQS(['page'=>$i]) ?>"><?= $i ?></a>
            <?php endif; ?>
          <?php endfor; ?>
          <a href="<?= keepQS(['page'=>$next]) ?>">&rsaquo;</a>
          <a href="<?= keepQS(['page'=>$pages]) ?>">&raquo;</a>
        </nav>
      <?php endif; ?>
    </div>
  </section>
</div>

<div class="modal fade" id="qvModal" tabindex="-1" aria-hidden="true">
  <div class="modal-dialog modal-lg modal-dialog-centered">
    <div class="modal-content">
      <div class="modal-body p-0">
        <div class="row no-gutters">
          <div class="col-md-6">
            <img class="qv-img" src="" alt="" id="qvImg">
          </div>
          <div class="col-md-6 p-3">
            <h4 id="qvName" class="mb-1"></h4>
            <div class="text-muted mb-2"><span id="qvSess"></span></div>
            <div class="mb-2"><strong>Activity:</strong> <span id="qvAct"></span></div>
            <div class="mb-2"><strong>Achievement:</strong> <span id="qvAch"></span></div>
            <div class="mb-2"><strong>Organizer/Place:</strong> <span id="qvOrg"></span></div>
            <button type="button" class="btn btn-dark mt-2" data-bs-dismiss="modal">Close</button>
          </div>
        </div>
      </div>
    </div>
  </div>
</div>

// Fill modal content
    var name = btn.getAttribute('data-name') || '';
    var act  = btn.getAttribute('data-act')  || '';
    var ach  = btn.getAttribute('data-ach')  || '';
    var sess = btn.getAttribute('data-sess') || '';
    var org  = btn.getAttribute('data-org')  || '—';
    var img  = btn.getAttribute('data-img')  || '';

document.getElementById('qvName').textContent = name;
    document.getElementById('qvAct').textContent  = act;
    document.getElementById('qvAch').textContent  = ach;
    document.getElementById('qvSess').textContent = sess;
    document.getElementById('qvOrg').textContent  = org;
    var qvImg = document.getElementById('qvImg');
    qvImg.src  = img;
    qvImg.alt  = name + ' - ' + act;

// Show modal via Bootstrap 5 API if available
    var modalEl = document.getElementById('qvModal');

if (window.bootstrap && typeof bootstrap.Modal !== 'undefined') {
      var modal = bootstrap.Modal.getOrCreateInstance(modalEl);
      modal.show();
    }
    // Fallback to Bootstrap 4 jQuery plugin if available
    else if (window.jQuery && typeof jQuery.fn.modal === 'function') {
      jQuery(modalEl).modal('show');
    }
    // Last resort: toggle class (basic)
    else {
      modalEl.classList.add('show');
      modalEl.style.display = 'block';
      modalEl.removeAttribute('aria-hidden');
      // close on background click
      modalEl.addEventListener('click', function(ev){
        if (ev.target === modalEl) {
          modalEl.classList.remove('show');
          modalEl.style.display = 'none';
          modalEl.setAttribute('aria-hidden','true');
        }
      }, { once:true });
    }
  }, false);
});
</script>

<?php include 'footer.php'; ?>

X7ROOT File Manager

Editing: non-academic-achievers.php

Upload File

Create Folder