| 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 : |
<?
// infoData.phpinc
$query="SHOW COLUMNS FROM ".$table;
$fieldList = query_do($query,__FILE__,__LINE__);
$fieldCount = $_SESSION['mysql_num_rows'];
$isAlpha = array('date', 'time', 'year', 'char', 'blob', 'text', 'enum', 'set');
include('infoMenu.phpinc');
$query="SELECT * FROM ".$table;
$dataList = query_do($query,__FILE__,__LINE__);
$dataCount = $_SESSION['mysql_num_rows'];
?>
<style type="text/css">
table.data {
border-top:1px solid silver;
border-left:1px solid silver;
}
td.data, th.data {
border-bottom:1px solid silver;
border-right:1px solid silver;
}
</style>
<table><tr><td class="data">
<p><fieldset><legend><?=$table?> Data (<?=$dataCount?> records)</legend>
<table cellpadding="1" cellspacing="0" class="data">
<tr>
<?
mysql_data_seek($fieldList, 0);
while ($row = mysql_fetch_assoc($fieldList)) {
?>
<th class="blue_info data"><?=$row['Field']?></th>
<?
}
?>
</tr>
<?
if ($dataCount) {
mysql_data_seek($dataList, 0);
while ($dataInfo = mysql_fetch_assoc($dataList)) {
?>
<tr>
<?
mysql_data_seek($fieldList, 0);
while ($row = mysql_fetch_assoc($fieldList)) {
if (stripos($row['Field'],"password") !== false) {
?>
<td class="data"><?=str_repeat("*", strlen($row['Field']))?></td>
<?
} else {
?>
<td class="data"><?=$dataInfo[$row['Field']]?></td>
<?
}
}
?>
</tr>
<?
}
} else {
?>
<tr><td colspan=" <?=$fieldCount?>" class="bold_info center_info error_info">No data in table</td>
</tr>
<?
}
?>
</table>
</fieldset></p>
</td></tr></table>
</p>