| 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/Admin/Advising/ParseClasses/ |
Upload File : |
<?
// Admin/Advising/ParseClasses/UpdateClasses_Notes.phpinc
// Update pclass data.
$d_O = d_O(); #d_On(); // Uncomment to DEBUG.
d_Line(basename(__FILE__));
d_Var('$class',$class,'k');
d_Var("\$class['NOTE']",$class['NOTE'],'k');
// DELETE class notes.
$query = "
DELETE
FROM `pclassnote`
WHERE YRTR = '".query_safe($_SESSION['YRTR']['User'])."'
AND COU_ID = '".query_safe($class['COU_ID'])."'
";
$pclassnoteDelete = query_do($query);
// INSERT notes.
$noteIndex = 0;
foreach ( $class['NOTE'] as $note ) {
d_Var('$note',$note);
$query = "
INSERT
INTO `pclassnote` (
YRTR,
COU_ID,
numb,
NOTE
) VALUES (
'".query_safe($_SESSION['YRTR']['User'])."',
'".query_safe($class['COU_ID'])."',
'".query_safe($noteIndex)."',
'".query_safe($note)."'
)
";
d_Var('pclassnoteINSERT',$query,'q');
$pclassnoteINSERT = query_do($query);
@d_Var('$pclassnoteINSERT',$pclassnoteINSERT);
#$pclassnoteId = $_SESSION['qry']['insertId'];
$noteIndex++;
}
if ( isset($d_O) && !$d_O ) d_Off();
?>