| 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/ |
Upload File : |
<?
// _info/infoSQL.phpinc
// Perform SQL queries.
#t_Begin(); // Begin TRACKing included file.
$f_sql = formValue('sql');
#d_V('sql');
?>
<style type="text/css">
#id_sql { height:20em; width:60em; }
</style>
<a name="sql"></a>
<form name="sql_form" action="<?=php_self()?>#sql" method="post">
<input type="hidden" name="f_task" value="sql">
<input type="hidden" name="f_database" value="<?=$f_database?>">
<textarea class="code_info" name="f_sql" id="id_sql"><?=str_replace(array("<",">"),array("<",">"),stripslashes($f_sql))?></textarea>
<br>
<input type="submit" name="f_subtask" value="Submit query">
</form>
<?
if ($f_sql != '') {
$f_sql_fixed = stripslashes($f_sql);
#d_Var('queryResult',$f_sql_fixed,'dq');
$queryResult = query_do($f_sql_fixed,$f_database);
#d_Var("\$queryResult",$queryResult,"d");
$queryResultCount = $_SESSION['qry']['count'];
if ($queryResult) {
if ($queryResultCount) {
?>
<br>The number of rows returned is <?=$queryResultCount?>.
<table id="sql_list">
<tr>
<?
query_seek($queryResult, 0);
$queryInfo = query_row($queryResult);
foreach ($queryInfo as $fieldName => $fieldValue) {
echo '<th>',$fieldName,"</th>";
}
?>
</tr>
<?
query_seek($queryResult, 0);
while($queryInfo = query_row($queryResult)) {
?>
<tr>
<?
foreach ($queryInfo as $fieldName => $fieldValue) {
if ( is_null($fieldValue) ) {
$fieldValue = 'NULL';
} else {
if ( $fieldValue == '' ) {
$fieldValue = 'EMPTY';
}
}
echo '<td>',$fieldValue,"</td>";
}
?>
</tr>
<?
}
?>
</table>
<?
} else {
?>
There were no rows returned.
<?
}
} else {
$_SESSION['qry']['count'] = false;
?>
There is no result. Info count is <?=$_SESSION['qry']['count']?>.
<?
}
}
#t_End(); // End TRACKing included file.
?>