Tul xxx Tul

Viewing: check_duplicates.php

<?php
$mysqli = new mysqli("localhost", "root", "", "gimnasio");
if ($mysqli->connect_errno) { echo "Failed to connect to MySQL: " . $mysqli->connect_error; exit(); }

$res = $mysqli->query("SELECT m.id, u.name, mt.name as plan, m.status, m.created_at 
                      FROM memberships m 
                      JOIN users u ON u.id = m.user_id 
                      JOIN membership_types mt ON mt.id = m.membership_type_id 
                      WHERE m.user_id IN (SELECT user_id FROM memberships GROUP BY user_id, membership_type_id HAVING COUNT(*) > 1)
                      ORDER BY u.name, mt.name, m.created_at DESC");

while ($row = $res->fetch_assoc()) {
    print_r($row);
}
$mysqli->close();

User / IP	: 216.73.216.146
Host / Server	: 45.84.207.204 / aircan.me
System	: Linux lt-bnk-web1726.main-hosting.eu 5.14.0-611.36.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 3 11:23:52 EST 2026 x86_64