| 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/JimMartinson/CST2146/_Archive/_info/ |
Upload File : |
<?
// index.php
// Display data information.
$TRACK = "<b>".basename(__FILE__)."</b> (".__FILE__.")\n<ol>\n";
ini_set('include_path',"/Data_WWW/CST/".ini_get('include_path')); // ** Add the DOCUMENT_ROOT to the include_path.
// getQuoteCharacter($fieldType)
// Returns an empty string if the fieldType is numeric and a single quote (') if the fieldType is apphanumeric.
function getQuoteCharacter($fieldType) {
$isAlpha = array('date', 'time', 'year', 'char', 'blob', 'text', 'enum', 'set');
$qc="";
for ($i = 0; $i < count($isAlpha); $i++) {
if (strlen(stristr($fieldType,$isAlpha[$i]))) $qc="'";
}
return $qc;
}
// getDefaultValue($fieldType)
// Returns the default value based on the fieldType.
function getDefaultValue($fieldType) {
$isAlpha = array('date', 'time', 'year', 'char', 'blob', 'text', 'enum', 'set');
$defaultValue=0;
for ($i = 0; $i < count($isAlpha); $i++) {
if (strlen(stristr($fieldType,$isAlpha[$i]))) $defaultValue="";
}
return $defaultValue;
}
$skipAuthentication = true;
$authorizedGroups="PUBLIC";
include('Application.phpinc');
$headTitle = '_CST_ - Database';
$pageTitle = '_CST_<br>Database';
$css = '_info';
$js='div';
$thisFile = __FILE__; include('../common/pageHeader.phpinc');
$f_table=formValue('table');
$table = $f_table;
if ($f_table != '') { $sectionTitle = $f_table.' Table'; } else {$sectionTitle = 'Tables'; }
$thisFile = __FILE__; include('../common/sectionHeader.phpinc');
switch ($f_task) {
case '': // Tables.
include('infoTables.phpinc');
break;
case 'table':
$f_task = 'Fields';
case 'Fields': // Fields
include('infoFields.phpinc');
break;
case 'Data': // Data
include('infoData.phpinc');
break;
case 'Form': // Form
include('infoForm.phpinc');
break;
case 'Set': // Set
include('infoSet.phpinc');
break;
case 'DELETE': // DELETE
include('infoDELETE.phpinc');
break;
case 'INSERT': // INSERT
include('infoINSERT.phpinc');
break;
case 'SELECT': // SELECT
include('infoSELECT.phpinc');
break;
case 'UPDATE': // UPDATE
include('infoUPDATE.phpinc');
break;
case 'Reorder': // Reorder
include('infoReorder.phpinc');
break;
default:
echo '<p class="bold_info">'.__FILE__.' <span class="error_info">Code for $f_task=['.$f_task.']</span>'.' <span class="error_info">$f_subtask=['.$f_subtask."] not finished.</p>\n"; $debugOn = true;
}
// ** END f_task control switch statement.
$thisFile = __FILE__; include('../common/sectionFooter.phpinc');
$thisFile = __FILE__; include('../common/pageFooter.phpinc'); // ** Include the page footer.
?>