| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/Scheduler/admin/_info/query/ |
Upload File : |
<?
// infoTableFields.phpinc
// Get table field info if we dont already have it.
t_Begin(); // Begin TRACKing included file.
if ( !isset($fieldArray) || ( isset($forceQuery) && $forceQuery ) ) {
$fieldQuery="SHOW COLUMNS FROM `".$f['table']."`";
$fieldResult = query_do($fieldQuery,$f['database']);
$fieldCount = $GLOBALS['_QUERY']['count'];
if ( $fieldCount && !isset($fieldArray) ) {
#d_Line('$fieldArray = array()','oe',false,true);
$fieldArray = array();
$tablePrimaryKey = array();
#d_Var('$fieldResult',$fieldResult,'k');
query_seek($fieldResult, 0);
while ( $fieldInfo = query_row($fieldResult) ) {
if ( $fieldInfo['Key'] == 'PRI' ) $tablePrimaryKey[] = $fieldInfo['Field']; // Set the Id fields.
$fieldArray[$fieldInfo['Field']] = array();
$fieldArray[$fieldInfo['Field']]['Type'] = $fieldInfo['Type']; // Keep Type.
$fieldArray[$fieldInfo['Field']]['Null'] = $fieldInfo['Null']; // Keep Null.
$fieldArray[$fieldInfo['Field']]['Key'] = $fieldInfo['Key']; // Keep Key.
$fieldArray[$fieldInfo['Field']]['Default'] = $fieldInfo['Default']; // Keep Default.
$fieldArray[$fieldInfo['Field']]['Extra'] = $fieldInfo['Extra']; // Keep Extra.
formValue('',$fieldInfo['Field'].'_type','type');
if ( !$type ) $fieldArray[$fieldInfo['Field']]['type'] = 'use'; // Set to use in query.
} // while ( $fieldInfo = query_row($fieldResult) )
} // if ( $fieldCount )
} // if ( !isset($fieldArray) )
t_End(); // End TRACKing included file.
?>