Unformatted Attachment Preview
Codes are at the bottom part:
Subjectschedule table
Checklist table
--------------------------------------------------------END of Sample Data--------------------------------------------------------
ChecklistBSIT.php – Displays the table of checklist that has the course of Bachelor of Science in
Information Technology that can be edited and deleted. It also views schedules that will redirect you to
viewsubjectschedule.php (below).
(what I want to do) :
1. When the personnel clicks Schedule’s(with the descriptive title Communication Arts 1)it should
only show table of subjectstudent with the idChecklist of 2 in viewsubjectschedule.php (below).
2. When the personnel clicks Schedule’s(with the descriptive title I Believe)it should only show table
of subjectstudent with the idChecklist of 1 in viewsubjectschedule.php (below).
viewSubjectSchedule.php – displays all subjectschedule table (that shouldn’t be) . It should only view the
data with the same idChecklist of chosen Descriptivetitle.
Output should be:
1. When personnel choose the Communication Arts 1 Schedule
2. When personnel choose the I Believe Schedule
MYSQL CODE
-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--- Host: 127.0.0.1
-- Generation Time: May 18, 2015 at 07:22 AM
-- Server version: 5.6.17
-- PHP Version: 5.5.12
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--- Database: `sluonlineenrollment`
--
-- --------------------------------------------------------
--- Table structure for table `checklist`
--
CREATE TABLE IF NOT EXISTS `checklist` (
`idChecklist` int(5) NOT NULL AUTO_INCREMENT,
`course` varchar(45) DEFAULT NULL,
`descriptiveTitle` varchar(45) DEFAULT NULL,
`courseNo` varchar(45) DEFAULT NULL,
`lec` varchar(45) DEFAULT NULL,
`lab` varchar(45) DEFAULT NULL,
`units` varchar(45) DEFAULT NULL,
`year` varchar(45) DEFAULT NULL,
`semester` varchar(45) DEFAULT NULL,
`rate` varchar(45) DEFAULT NULL,
PRIMARY KEY (`idChecklist`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
--- Dumping data for table `checklist`
--
INSERT INTO `checklist` (`idChecklist`, `course`, `descriptiveTitle`, `courseNo`, `lec`, `lab`, `units`, `year`,
`semester`, `rate`) VALUES
(1, 'Bachelor of Science in Information Technology', 'I Believe', 'Theo 1', '3', '0', '3', '1', '2nd', '2,232.20'),
(2, 'Bachelor of Science in Information Technology', 'Communication Arts 1', 'Engl 1', '3', '0', '3', '1', '1st',
'2,232.00'),
(3, 'Bachelor of Science in Information Technology', 'Komunikasyon sa Akademikong Filipino', 'Fil 1', '3',
'0', '3', '1', '1st', '2,232.00'),
(4, 'Bachelor of Science in Information Technology', 'Philippine History', 'History 1', '3', '0', '3', '1', '1st',
'2,232.00'),
(5, 'Bachelor of Science in Information Technology', 'College Algebra', 'Math 1A', '3', '0', '3', '1', '1st',
'2,232.00'),
(8, 'edited', 'edit me 1', 'edit me 1', 'edit me 1', 'edit me 1', 'edit me 1', 'edit me 1', 'edit me 1', 'edit me
1'),
(9, 'Bachelor of Science in Information Technology', 'Plane Spherical Trigonometry', 'Math 2A', '3', '0', '3',
'1', '1st', '2,232.00'),
(14, 'bachelor of Nursing', 'Gjah', 'jvjh', 'vbh', 'vbb', 'vn', 'cvb', ' ', 'vbn'),
(15, 'Bachelor of Science in Information Technology', 'I Believe 2', 'Theo 2', '3', '0', '3', '2', '2nd', '999.00');
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;