| 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 : |
<?
// infoUPDATE.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');
?>
<table><tr><td>
<p><fieldset><legend><?=$table?> UPDATE</legend>
<form><textarea style="height:600px; width:978px;" wrap="off">
<?
<?
$query = "\$query = \"UPDATE ".$table." SET"."\n";
$querytable = "";
while ($row = mysql_fetch_assoc($fieldList)) {
$qc = getQuoteCharacter($row['Type']);
if ($row['Field'] != 'modifiedBy' && ($row['Field'] == 'userId' || substr($row['Field'],strlen($row['Field'])-2,2) == "By")) {
$query .= "\n";
}
if ($row['Field'] != 'modifiedBy') {
$query .= " ".$row['Field']." = ".$qc."\".\$f_".$row['Field'].".\"".$qc.",\n";
}
if ($row['Field'] == 'userId' || substr($row['Field'],strlen($row['Field'])-2,2) == "By") {
$query .= " ".$row['Field']." = ".$qc."\".\$_SESSION['trueuserId'].\"".$qc.",\n";
}
}
$query = substr($query,0,strlen($query)-2)."\n";
$querytable = substr($querytable,0,strlen($querytable)-2)."\n";
include('infoWHERE.phpinc');
$query .= "\";"."\n";
echo "\$f_modifiedDate = currentDateTime();\n";
echo $query."\$".$table."Update = query_do(\$query,__FILE__,__LINE__);"."\n";
?>
?>
</textarea></form>
</fieldset></p>
</td></tr></table>
<?
if ($TRACK != '') $_SESSION['TRACK'] .= "<li>End ".basename(__FILE__)."</ol>\n";
?>