| 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/JimMartinson/_Archive/MMDT1145/_Archive/ |
Upload File : |
<?
// JimMartinson/MMDT1145/Lab05.php
$TRACK = "<b>".basename(__FILE__).'</b> <span class="pv_fl">('.__FILE__.")</span>\n<ol>\n";
ini_set('include_path',ini_get('include_path').PATH_SEPARATOR.$_SERVER['DOCUMENT_ROOT']."/"); // Add the DOCUMENT_ROOT to the include_path.
include('application.phpinc');
include('Course/courseInfo.phpinc');
include('classInfo.phpinc');
$assignmentNumber = 5;
$assignmentType = "Lab";
$assignmentTitle = "Project Database Admin Pages";
$evaluationType = "Lab";
if (!isset($evaluationNumber)) { $evaluationNumber = $assignmentNumber; }
if (!isset($evaluationTitle)) { $evaluationTitle = $assignmentTitle; }
if (strlen($assignmentNumber) == 1) { $assignmentName = $assignmentType."0".$assignmentNumber; $evaluationName = $evaluationType."0".$evaluationNumber; } else {
$assignmentName = $assignmentType.$assignmentNumber; $evaluationName = $evaluationType.$assignmentNumber; }
$title = $evaluationType." ".$evaluationNumber.": ".$evaluationTitle;
$headTitle = '_CST_ - '.$courseNumber.' '.$courseTitle.' - '.$title;
$pageTitle = $courseNumber.' '.$courseTitle.'<br>'.$title;
$pageMenu = 'Course/courseMenu.phpinc';
$smallTitle = true;
include('common/pageHeader.phpinc');
$sectionTitle = $courseNumber.' '.$courseTitle.' - '.$title;
include('common/sectionHeader.phpinc');
$userFullName = str_replace(" ","",$_SESSION['userFullName']);
?>
<p>
<fieldset><legend><?=$evaluationType?> Assignment</legend>
Below list of tables and student assignments. The assignment is to produce the pages for managing the table assigned. These should work similar to the http://iven.loc/admin/database/projectstatus/ pages created in class by me.
<br>
Database admin tables. These table list and add/edit pages should be placed in /admin/database/tablename where 'tablename' is the name of the table assigned to you.
Feel free to place sample data in the database as needed.
<pre>
costcenter - Megan Kammermeier
dean - Gail Rach
department_dean - Marissa Walter
department - Edward Berg
equipmentstatus - Robert Eddy
equipmenttype - Matthew Green
group - Jim
group_page - Jim
location - John Stifter
locationcampus - Samuel Brandl
misc - Jim
phonenumbertype - Lucas Matthys
project_user_relationship
projectstatus - Jim
projectstatusgroup - Jim
projecttype - Jim
user - Jim
user_department - Allison Dobie
user_group - Jim
userphonenumber - Jim
vendor - Kyle Clough
vendor_equipmenttype - Ryan Clements
</pre>
Export your database design using MySQL Administrator's Backup feature.<br>Zip up your <b>iven</b> folder into a file called <b class="nobr"><?=$userFullName?>-<?=$courseNumber?>-<?=$evaluationName?>.zip</b>
<br>
Send an email to <a href="mailto:jim.martinson@ridgewater.edu?subject=<?=$courseNumber?> - <?=$evaluationName?> Submission">jim.martinson@ridgewater.edu</a> with a subject of <b><?=$courseNumber?> - <?=$evaluationName?> Submission</b> and attach your <b class="nobr"><?=$userFullName?>-<?=$courseNumber?>-<?=$evaluationName?>.zip</b> file.
</fieldset>
<fieldset><legend>Grading Criteria</legend>
Demonstrated assignment effectively: 20 points.
<br />
There are some things I expect. If they are incorrect you will lose the following:
<br />
Incorrect attachment file name: -2 pt.
<br />
Work submitted incorrectly: -2 pt.
<br />
Incorrect subject in email: -2 pt.
<br />
Second and subsequent submission of work for grading: -2 pt.
<br />
Work submitted late: -2 pts per week.
</fieldset>
<?
include('ReferencesResources.phpinc');
include('common/sectionFooter.phpinc');
include('common/pageFooter.phpinc');
?>