Choose a table row and display the data of that chosen row in a new php page

munp13
timer Asked: May 18th, 2015

Question Description

admin.zip the php code and sluonlineenrollment.sql

Subjectschedule table.docx the descriptive info that I want to happen

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 */;
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors