✏️ 正在编辑: DataDictionary.php
路径:
/home/eblama1/sms.karnplayinland.com/modules/Custom/DataDictionary.php
提示:
您可以编辑任何文件（包括二进制文件），但请注意不当修改可能导致文件损坏。
<?php $sql = "SELECT a.attnum,a.attname AS field,t.typname AS type, a.attlen AS length,a.atttypmod AS lengthvar, a.attnotnull AS notnull,c.relname FROM pg_class c, pg_attribute a, pg_type t WHERE a.attnum > 0 and a.attrelid = c.oid and c.relkind='r' and c.relname not like 'pg\_%' and a.attname not like '...%' and a.atttypid = t.oid ORDER BY c.relname"; $RET = DBGet( $sql, [], [ 'RELNAME' ] ); $PDF = PDFStart(); echo '<table>'; foreach ( (array) $RET as $table => $columns ) { if ( $i % 2 == 0 ) { echo '<tr><td class="valign-top">'; } echo '<b>' . $table . '</b>'; echo '<table>'; foreach ( (array) $columns as $column ) { echo '<tr><td style="width:15px;"> </td><td>' . $column['FIELD'] . '</td><td>' . $column['TYPE'] . '</td></tr>'; } echo '</table>'; if ( $i % 2 == 0 ) { echo '</td><td class="valign-top">'; } else { echo '</td></tr>'; } $i++; } echo '</table>'; PDFStop( $PDF );
💾 保存文件
← 返回文件管理器