<?php
require_once 'config/database.php';
use App\Config\Database;

try {
    $db = Database::getInstance()->getConnection();
    echo "--- categories count ---\n";
    $count1 = $db->query("SELECT COUNT(*) FROM categories")->fetchColumn();
    echo "Count: $count1\n";
    
    echo "--- medicine_categories count ---\n";
    $count2 = $db->query("SELECT COUNT(*) FROM medicine_categories")->fetchColumn();
    echo "Count: $count2\n";
} catch (Exception $e) {
    echo "Error: " . $e->getMessage() . "\n";
}
