| 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 : |
<?
// infoWHERE.phpinc
if (!isset($query)) { $query = ''; }
if (!isset($querytable)) { $querytable = ''; }
$isAlpha = array('date', 'time', 'year', 'char', 'blob', 'text', 'enum', 'set');
$index = 0;
mysql_data_seek($fieldList, 0);
$orderBy = 'fieldName';
while ($row = mysql_fetch_assoc($fieldList)) {
#if ($index < 6) {
if (strlen(stristr($row['Field'],'Name')) && $orderBy == 'fieldName') $orderBy=$row['Field'];
$qc = getQuoteCharacter($row['Type']);
if (!$index) {
$condition = 'WHERE';
} else {
$condition = ' AND';
}
if ($row['Field'] == 'userId' || substr($row['Field'],strlen($row['Field'])-2,2) == "By") {
$query .= "\n";
$querytable .= "\n";
}
$query .= $condition." ".$row['Field']." = ".$qc."\".\$f_".$row['Field'].".\"".$qc."\n";
$querytable .= $condition." ".$table.".".$row['Field']." = ".$qc."\".\$f_".$row['Field'].".\"".$qc."\n";
if ($row['Field'] == 'userId' || substr($row['Field'],strlen($row['Field'])-2,2) == "By") {
// $_SESSION['userId']
$query .= $condition." ".$row['Field']." = ".$qc."\".\$_SESSION['userId"."'].\"".$qc."\n";
$querytable .= $condition." ".$table.".".$row['Field']." = ".$qc."\".\$_SESSION['userId"."'].\"".$qc."\n";
// $_SESSION['trueuserId']
$query .= $condition." ".$row['Field']." = ".$qc."\".\$_SESSION['trueuserId"."'].\"".$qc."\n";
$querytable .= $condition." ".$table.".".$row['Field']." = ".$qc."\".\$_SESSION['trueuserId"."'].\"".$qc."\n";
}
#}
$index++;
}
?>