| 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 : /nginx/html/_info/query/ |
Upload File : |
<?
// infoSELECT.phpinc
#t_Begin(); // Begin TRACKing included file.
// Get table info.
require('_info/query/infoTableFields.phpinc'); // Get table field info.
$indent = '';
$query = '';
$querytable = '';
// Begin query.
if ( !isset($indent) ) { $indent = ''; }
$query .= $indent.'$query = "'.in().$indent." SELECT ";
$querytable .= $indent.'$query = "'.in().$indent." SELECT ";
// Add fields.
$prefix = '';
query_seek($fieldResult, 0);
while ($row = query_row($fieldResult)) {
$query .= $prefix.$row['Field'].in();
$querytable .= $prefix.$f_table.'.'.$row['Field'].in();
$prefix = $indent." , ";
}
// Add FROM.
$query .= $indent." FROM `".$f_table.'`'.in();
$querytable .= $indent." FROM `".$f_table.'`'.in();
// Add WHERE.
require('infoWHERE.phpinc');
// Add ORDER BY.
$query .= $indent." ORDER BY ".$orderBy.in();
$querytable .= $indent." ORDER BY ".$f_table.'.'.$orderBy.in();
// Finish query.
$query .= $indent."\";".in();
$querytable .= $indent."\";".in();
// Add query_do.
$queryend = '';
if ( $GLOBALS['debuggingAvailable'] ) $queryend .= $indent."d_Var('".$f_table."Result',\$query,'q');"."\n";
$queryend .= $indent."\$".$f_table."Result = query_do(\$query);".in();
$queryend .= $indent."\$".$f_table."Count = \$_SESSION['qry']['count'];".in();
if ( $GLOBALS['debuggingAvailable'] ) $queryend .= $indent."d_Var('$".$f_table."Result',\$".$f_table."Result);"."\n";
// Add !Count lines.
$indexFieldList = '';
foreach ( $indexField as $thisField ) {
$indexFieldList = listAppend($indexFieldList,$thisField." ('.\$".$thisField.".')");
}
$indexFieldList = listAnd($indexFieldList);
$queryend .= $indent."#if ( \$".$f_table."Count != 1 ) programmingError('The ".$indexFieldList." did not return one record. '.\$".$f_table."Count.' returned.');".in();
$queryend .= $indent."#if ( !\$".$f_table."Count ) programmingError('The ".$indexFieldList." did not return any records.');".in();
// Add Count lines.
$queryend .= $indent."if ( \$".$f_table."Count ) {".in();
$queryend .= $indent." query_seek(\$".$f_table."Result, 0);".in();
$queryend .= $indent." while (\$".$f_table."Info = query_row(\$".$f_table."Result)) {".in();
$queryend .= $indent." ".in();
$queryend .= $indent." }".in();
$queryend .= $indent."}".in();
// Add query_info lines.
if ( $GLOBALS['debuggingAvailable'] ) $queryend .= $indent."#d_Var('".$f_table."Info',\$query,'q');"."\n";
$queryend .= $indent."#\$".$f_table."Info = query_info(\$query);".in();
if ( $GLOBALS['debuggingAvailable'] ) $queryend .= $indent."#d_Var('$".$f_table."Info',\$".$f_table."Info);"."\n";
// Finish query.
$query .= $queryend;
$querytable .= $queryend;
?>
<table><tr><td><fieldset><legend><?=$f_database?> <?=$f_table?> SELECT without table name</legend>
<form><textarea class="code_info" name="SELECT" wrap="off"><?=htmlView($query)?></textarea></form>
</fieldset></td></tr></table>
<? d_Var('$indexField',$indexField,''); ?>
<table><tr><td><fieldset><legend><?=$f_database?> <?=$f_table?> SELECT with table name</legend>
<form><textarea class="code_info" name="SELECTtable" wrap="off"><?=htmlView($querytable)?></textarea></form>
</fieldset></td></tr></table>
<?
#t_End(); // End TRACKing included file.
?>