$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