$title = "";
// put records into database tables
foreach ($records as $oneClass) {
// course table
$query = "INSERT INTO tblCourses(fldCourseNumber, fldCourseName, fldDepartment, fldCredits) ";
$query .= "VALUES (?, ?, ?, ?)";
$data = array($oneClass[1], $oneClass[2], $oneClass[0], $oneClass[12]);
if ($debug) {
print "<p>sql " . $query . "</p><p><pre> ";
print_r($data);
print "</pre></p>";
}
$style = "background-color: lightblue;";
if (!($subj == $oneClass[0] and $num == $oneClass[1] and $title == $oneClass[2])) {
$results = $thisDatabase->insert($query, $data);
$pmkCourseId = $thisDatabase->lastInsert();
if ($results) {
$style = "background-color: lightgreen;";
} else {
$style = "background-color: lightred;";
}
}
$outputBuffer[] = "\t<tr></th>";
$outputBuffer[] = "\t\t<th style='" . $style . "'>" . $oneClass[1] . "</th>";
$outputBuffer[] = "\t\t<th style='" . $style . "'>" . $oneClass[2] . "</th>";
$outputBuffer[] = "\t\t<th style='" . $style . "'>" . $oneClass[0] . "</th>";
$outputBuffer[] = "\t\t<th style='" . $style . "'>" . $oneClass[12] . "</th>";
//avoid duplicates
$subj = $oneClass[0];
$num = $oneClass[1];
$title = $oneClass[2];
//
// Process for when the form passes validation (the errorMsg array is empty)
//
if (!$errorMsg) {
if ($debug) {
print "<p>Form is valid</p>";
}
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
//
// SECTION: 2e Save Data
//
// This block saves the data to a CSV file.
//Build query
$query = "INSERT INTO tblAdvisors(fldFirstName,fldEmail)VALUES(?,?)";
$plan = $thisDatabase->insert($sql, $dataRecord, 0, 0, 0, 0, false, false);
$planId = $thisDatabase->lastInsert();
$fileExt = ".csv";
$myFileName = "data/registration";
$filename = $myFileName . $fileExt;
if ($debug) {
print "\n\n<p>filename is " . $filename;
}
// now we just open the file for append
$file = fopen($filename, 'a');
// write the forms informations
fputcsv($file, $dataRecord);
// close the file
fclose($file);
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
//
// SECTION: 2f Create message
