« Back to History
tmp_kdbg.php
|
20260721_154033.php
Initial Bulk Import
Copy Code
<?php require_once __DIR__ . '/core/db.php'; echo "PDO local: " . (isset($pdo) ? "OK" : "NULL") . "\n"; echo "PDO GLOBALS: " . (isset($GLOBALS['pdo']) ? "OK" : "NULL") . "\n"; $db = $pdo ?? $GLOBALS['pdo'] ?? null; if (!$db) { die("NO DB\n"); } $st = $db->prepare("SELECT id, name FROM companies WHERE login_code = ? AND is_active = 1 LIMIT 1"); $st->execute(['84888']); $r = $st->fetch(PDO::FETCH_ASSOC); echo "Company: "; print_r($r); echo "\n"; if ($r) { $st2 = $db->prepare("SELECT id, name FROM company_employee_master WHERE id = ? AND company_id = ? AND department_id = 20 AND COALESCE(is_active,1)=1 LIMIT 1"); $st2->execute([44, (int)$r['id']]); $emp = $st2->fetch(PDO::FETCH_ASSOC); echo "Employee: "; print_r($emp); echo "\n"; }