$dbName = strtoupper(get_current_user()) . '_UVM_Courses';
$thisDatabase = new myDatabase($dbUserName, $whichPass, $dbName);
/* ##### html setup */
$phpSelf = htmlentities($_SERVER['PHP_SELF'], ENT_QUOTES, "UTF-8");
$path_parts = pathinfo($phpSelf);
print '<body id="' . $path_parts['filename'] . '">';
/* ##### Step two
*
* open the file that contains the query
*/
$myfile = fopen("q06.sql", "r") or die("Unable to open file!");
$query = fread($myfile, filesize("q06.sql"));
/* ##### Step three
* Execute the query
* */
$results = $thisDatabase->select($query);
/* ##### Step four
* prepare output and loop through array
* */
$numberRecords = count($results);
print "<h2>Total Records: " . $numberRecords . "</h2>";
print "<h3>SQL: " . $query . "</h3>";
print "<table>";
$firstTime = true;
/* since it is associative array display the field names */
foreach ($results as $row) {
if ($firstTime) {
print "<thead><tr>";
$keys = array_keys($row);
foreach ($keys as $key) {
if (!is_int($key)) {
$thisDatabase = new myDatabase($dbUserName, $whichPass, $dbName);
// -- Table structure for table `tblSections`
$query = "DROP TABLE IF EXISTS tblEnrolls";
$results = $thisDatabase->delete($query);
$query = "CREATE TABLE IF NOT EXISTS tblEnrolls ( ";
$query .= "fnkCourseId int(11) NOT NULL, ";
$query .= "fnkSectionId int(11) NOT NULL, ";
$query .= "fnkStudentId int(11) NOT NULL, ";
$query .= "fldGrade int(11) NOT NULL, ";
$query .= "PRIMARY KEY (`fnkCourseId`,`fnkSectionId`,`fnkStudentId`)";
$query .= ") ENGINE=InnoDB DEFAULT CHARSET=utf8";
$results = $thisDatabase->insert($query);
print "<p>tblEnrolls Created.</p>";
//get all the student id numbers
$query = "SELECT pmkStudentId, 0 as numClasses FROM tblStudents";
$allStudents = $thisDatabase->select($query);
//get all the cs classes sections id numbers
$query = "SELECT fnkCourseId, fldCRN, fldNumStudents ";
$query .= "FROM tblSections, tblCourses ";
$query .= "WHERE pmkCourseId=fnkCourseId ";
$query .= "AND fldDepartment = 'CS'";
//get all the sections id numbers
//$query = "SELECT fnkCourseId, fldCRN, fldNumStudents ";
//$query .= "FROM tblSections";
$allSections = $thisDatabase->select($query);
if ($debug) {
print "<p>allSections:<pre>";
print_r($allSections);
print "</pre></p>";
}
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
$query .= " fldType as Type ,";
$query .= " fldStart as Start ,";
$query .= " fldStop as Stop ,";
$query .= " fldDays as Days ,";
$query .= " fldBuilding as Building ,";
$query .= " fldRoom as Room ";
$query .= "FROM tblCourses , tblSections , tblTeachers";
$query .= ' WHERE pmkCourseID = fnkCourseID';
$query .= ' AND pmkNetID = fnkTeacherNetID';
$query .= ' AND fldStart like "' . $Start . '%"';
$query .= ' AND fldBuilding like "' . $Building . '%"';
$query .= ' AND fldDepartment like "%' . $Department . '%"';
$query .= ' AND fldCourseNumber like "%' . $CourseNumber . '%"';
$query .= ' AND fldLastName like "%' . $LastName . '%"';
$data = array($Start, $Building, $Department, $CourseNumber, $LastName);
$results = $thisDatabase->select($query, $data);
/////////// CALC COUNT AND DISPLAY ////////////
$numberRecords = count($results);
print "<h2>Total Records: " . $numberRecords . "</h2>";
$keys = array_keys($row);
//////////
//////// TABLE CONSTRUCTION ///////////////
print "<table>";
$firstTime = true;
/* since it is associative array display the field names */
foreach ($results as $row) {
if ($firstTime) {
print "<thead><tr>";
$keys = array_keys($row);
foreach ($keys as $key) {
preg_replace(' /(?<! )(?<!^)(?<![A-Z])[A-Z]/', ' $0', substr($key, 3));
$thisDatabase = new myDatabase($dbUserName, $whichPass, $dbName);
$phpSelf = htmlentities($_SERVER['PHP_SELF'], ENT_QUOTES, "UTF-8");
$path_parts = pathinfo($phpSelf);
print '<body id="' . $path_parts['filename'] . '">';
$tableName = "";
if (isset($_GET['getRecordsFor'])) {
// Sanitize the input to help prevent sql injection
$tableName = htmlentities($_GET['getRecordsFor'], ENT_QUOTES);
}
print "<h2>Database: " . $dbName . "</h2>";
// print out a list of all the tables and their description
// make each table name a link to display the record
print "<section id='tables2'>";
print "<table>";
$query = "SHOW TABLES";
$results = $thisDatabase->select($query);
foreach ($results as $row) {
// table name link
print '<tr class="odd">';
echo "<th colspan='6' style='text-align: left'><a href='?getRecordsFor=" . $row[0] . "#" . $row[0] . "'>" . $row[0] . "</a></th></tr>";
//get the fields and any information about them
$query = "SHOW COLUMNS FROM " . $row[0];
$results2 = $thisDatabase->select($query);
foreach ($results2 as $row2) {
print "<tr>";
print "<td>" . $row2['Field'] . "</td>";
print "<td>" . $row2['Type'] . "</td>";
print "<td>" . $row2['Null'] . "</td>";
print "<td>" . $row2['Key'] . "</td>";
print "<td>" . $row2['Default'] . "</td>";
print "<td>" . $row2['Extra'] . "</td>";
