File manager - Edit - /home/webapp69.cm.in.th/u69319090028/Shop/scratch/inspect_constraints.php
Back
<?php require_once __DIR__ . '/../database/Database.php'; $db = Database::getInstance(); $sql = " SELECT TABLE_NAME, COLUMN_NAME, CONSTRAINT_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = 'cargoo_shop' AND REFERENCED_TABLE_NAME IS NOT NULL "; $constraints = $db->query($sql)->fetchAll(PDO::FETCH_ASSOC); foreach ($constraints as $c) { echo "{$c['TABLE_NAME']}.{$c['COLUMN_NAME']} -> {$c['REFERENCED_TABLE_NAME']}.{$c['REFERENCED_COLUMN_NAME']} ({$c['CONSTRAINT_NAME']})\n"; }
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.25 |
proxy
|
phpinfo
|
Settings