print_r($records);
print "</pre></p>";
}
//Create tables if they dont exisit
// -- Table structure for table `tblTeachers`
$query = "DROP TABLE IF EXISTS tblTeachers";
$results = $thisDatabase->delete($query);
$query = "CREATE TABLE IF NOT EXISTS tblTeachers ( ";
$query .= "fldLastName varchar(100) NOT NULL, ";
$query .= "fldFirstName varchar(100) NOT NULL, ";
$query .= "pmkNetId varchar(12) NOT NULL, ";
$query .= "fldSalary int(11) NOT NULL, ";
$query .= "fldPhone varchar(7) NOT NULL, ";
$query .= "PRIMARY KEY (pmkNetId)";
$query .= ") ENGINE=InnoDB DEFAULT CHARSET=utf8";
$results = $thisDatabase->insert($query);
$outputBuffer[] = "<p>tblTeachers Created.</p>";
// -- Table structure for table `tblCourses`
$query = "DROP TABLE IF EXISTS tblCourses";
$results = $thisDatabase->delete($query);
$query = "CREATE TABLE IF NOT EXISTS tblCourses ( ";
$query .= "pmkCourseId int(11) NOT NULL AUTO_INCREMENT, ";
$query .= "fldCourseNumber int(11) NOT NULL, ";
$query .= "fldCourseName varchar(250) NOT NULL, ";
$query .= "fldDepartment varchar(5) NOT NULL, ";
$query .= "fldCredits tinyint(4) NOT NULL DEFAULT '3',";
$query .= "PRIMARY KEY (`pmkCourseId`)";
$query .= ") ENGINE=InnoDB DEFAULT CHARSET=utf8";
$results = $thisDatabase->insert($query);
$outputBuffer[] = "<p>tblCourses Created.</p>";
// -- Table structure for table `tblSections`
// SECTION: 2d Process Form - Passed Validation
//
// 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);
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
//
