1000 Projects
<<<Android Project Training's ( Online | Classroom)>>>

College Management System PHP Project Source Code

August 22, 2012

Introduction to College Management System PHP Project:

College management system project is implemented in PHP programming language using MY SQL database. Main aim of this project is to develop an online website which will cover details about institutes, courses, student’s information, student’s details and other information related to education.

In existing system there is no specific method for finding details about different institutes and know about institute from previous year students from respective colleges. Students should visit college and find details about the college which is a time taking procedure.


In present web portal project students can find details about different institutes and courses offered by different institutes through online web site.

Here we provide entire project source code with modules and database for free download.

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-- Database: `registration`
--

-- --------------------------------------------------------

--
-- Table structure for table `advance_ta`
--

CREATE TABLE `advance_ta` (
`sno` INT(10) NOT NULL AUTO_INCREMENT,
`user_name` VARCHAR(20) NOT NULL,
`training_name` VARCHAR(50) NOT NULL,
`chap_name` VARCHAR(25) NOT NULL,
`last_accessed` datetime DEFAULT NULL,
`exercise` VARCHAR(10) NOT NULL,
`progress` INT(5) NOT NULL,
`grade` VARCHAR(5) NOT NULL,
`slide_no` INT(5) NOT NULL,
PRIMARY KEY (`sno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;

--
-- Dumping data for table `advance_ta`
--

INSERT INTO `advance_ta` (`sno`, `user_name`, `training_name`, `chap_name`, `last_accessed`, `exercise`, `progress`, `grade`, `slide_no`) VALUES
(1, 'ajay123', 'Level 2 - Advanced', 'Module5', '2010-04-15 14:25:57', '', 95, '', 20),
(2, 'ajay123', 'Level 2 - Advanced', 'Module6', '2010-04-15 12:53:04', '', 4, '', 1),
(3, 'ajay123', 'Level 2 - Advanced', 'Module7', '2010-04-15 16:13:19', '', 12, '', 4),
(4, 'ajay123', 'Level 2 - Advanced', 'Module8', NULL, '', 0, '', 0),
(5, 'ajay123', 'Level 2 - Advanced', 'Module9', NULL, '', 0, '', 0),
(6, 'ajay123', 'Level 2 - Advanced', 'Module10', NULL, '', 0, '', 0),
(7, 'ajay123', 'Level 2 - Advanced', 'Module11', NULL, '', 0, '', 0),
(8, 'ajay123', 'Level 2 - Advanced', 'Module12', NULL, '', 0, '', 0),
(9, 'ajay123', 'Level 2 - Advanced', 'Module13', NULL, '', 0, '', 0),
(10, 'ajay123', 'Level 2 - Advanced', 'Module14', NULL, '', 0, '', 0),
(11, 'ajay123', 'Level 2 - Advanced', 'Module15', NULL, '', 0, '', 0),
(12, 'ajay123', 'Level 2 - Advanced', 'Module16', NULL, '', 0, '', 0),
(13, 'ajay123', 'Level 2 - Advanced', 'Module17', NULL, '', 0, '', 0),
(14, 'ajay123', 'Level 2 - Advanced', 'Module18', NULL, '', 0, '', 0),
(15, 'ajay123', 'Level 2 - Advanced', 'Module19', NULL, '', 0, '', 0),
(16, 'paul', 'Level 2 - Advanced', 'Module5', NULL, '', 0, '', 0),
(17, 'paul', 'Level 2 - Advanced', 'Module6', NULL, '', 0, '', 0),
(18, 'paul', 'Level 2 - Advanced', 'Module7', NULL, '', 0, '', 0),
(19, 'paul', 'Level 2 - Advanced', 'Module8', NULL, '', 0, '', 0),
(20, 'paul', 'Level 2 - Advanced', 'Module9', NULL, '', 0, '', 0),
(21, 'paul', 'Level 2 - Advanced', 'Module10', NULL, '', 0, '', 0),
(22, 'paul', 'Level 2 - Advanced', 'Module11', NULL, '', 0, '', 0),
(23, 'paul', 'Level 2 - Advanced', 'Module12', NULL, '', 0, '', 0),
(24, 'paul', 'Level 2 - Advanced', 'Module13', NULL, '', 0, '', 0),
(25, 'paul', 'Level 2 - Advanced', 'Module14', NULL, '', 0, '', 0),
(26, 'paul', 'Level 2 - Advanced', 'Module15', NULL, '', 0, '', 0),
(27, 'paul', 'Level 2 - Advanced', 'Module16', NULL, '', 0, '', 0),
(28, 'paul', 'Level 2 - Advanced', 'Module17', NULL, '', 0, '', 0),
(29, 'paul', 'Level 2 - Advanced', 'Module18', NULL, '', 0, '', 0),
(30, 'paul', 'Level 2 - Advanced', 'Module19', NULL, '', 0, '', 0);

-- --------------------------------------------------------

--
-- Table structure for table `basic_ta`
--

CREATE TABLE `basic_ta` (
`sno` INT(10) NOT NULL AUTO_INCREMENT,
`user_name` VARCHAR(20) NOT NULL,
`training_name` VARCHAR(50) NOT NULL,
`chap_name` VARCHAR(25) NOT NULL,
`last_accessed` datetime DEFAULT NULL,
`exercise` VARCHAR(10) NOT NULL,
`progress` INT(5) NOT NULL,
`grade` VARCHAR(5) NOT NULL,
`slide_no` INT(5) NOT NULL,
PRIMARY KEY (`sno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `basic_ta`
--

INSERT INTO `basic_ta` (`sno`, `user_name`, `training_name`, `chap_name`, `last_accessed`, `exercise`, `progress`, `grade`, `slide_no`) VALUES
(1, 'ajay123', 'Level 1 - Basic', 'Module1', '2010-04-12 10:26:59', '', 93, '', 26),
(2, 'ajay123', 'Level 1 - Basic', 'Module2', '2010-04-13 18:00:13', '', 19, '', 6),
(3, 'ajay123', 'Level 1 - Basic', 'Module3', '2010-04-14 13:33:14', '', 79, '', 27),
(4, 'ajay123', 'Level 1 - Basic', 'Module4', '2010-04-14 11:38:35', '', 100, '', 27),
(5, 'ajay', 'Level 1 - Basic', 'Module1', '2010-03-26 11:48:15', '', 68, '', 15),
(6, 'ajay', 'Level 1 - Basic', 'Module2', '2010-02-20 15:34:45', '', 0, '', 0),
(7, 'ajay', 'Level 1 - Basic', 'Module3', '2010-02-20 17:26:55', '', 100, '', 32),
(8, 'ajay', 'Level 1 - Basic', 'Module4', '2010-02-20 17:26:04', '', 8, '', 2),
(9, 'paul', 'Level 1 - Basic', 'Module1', NULL, '', 0, '', 0),
(10, 'paul', 'Level 1 - Basic', 'Module2', NULL, '', 0, '', 0),
(11, 'paul', 'Level 1 - Basic', 'Module3', NULL, '', 0, '', 0),
(12, 'paul', 'Level 1 - Basic', 'Module4', NULL, '', 0, '', 0);

-- --------------------------------------------------------

--
-- Table structure for table `batch`
--

CREATE TABLE `batch` (
`sno` INT(11) NOT NULL AUTO_INCREMENT,
`batchid` VARCHAR(100) NOT NULL,
`limit1` INT(11) NOT NULL,
`days` VARCHAR(100) NOT NULL,
`time1` VARCHAR(100) NOT NULL,
`course` VARCHAR(200) NOT NULL,
`duration` INT(11) NOT NULL,
`startdate` DATE NOT NULL,
`enddate` DATE DEFAULT NULL,
PRIMARY KEY (`sno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `batch`
--

INSERT INTO `batch` (`sno`, `batchid`, `limit1`, `days`, `time1`, `course`, `duration`, `startdate`, `enddate`) VALUES
(1, 'B-1', 15, 'MWF', '7-8 AM', 'Ms-Office', 1, '2009-09-01', '2009-09-30'),
(2, 'B-2', 24, 'MWF', '7-8 AM', 'Flash', 15, '2009-10-01', '2009-10-14'),
(3, 'B-3', 40, 'MWF', '7-8 AM', 'Visual Basic', 3, '2009-11-01', '2010-01-31');

-- --------------------------------------------------------

--
-- Table structure for table `batch_dtime`
--

CREATE TABLE `batch_dtime` (
`days` VARCHAR(100) NOT NULL,
`time1` VARCHAR(100) NOT NULL,
`totalstudent` INT(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `batch_dtime`
--

-- --------------------------------------------------------

--
-- Table structure for table `courses`
--

CREATE TABLE `courses` (
`sno` INT(11) NOT NULL AUTO_INCREMENT,
`course_name` VARCHAR(100) NOT NULL,
`duration` VARCHAR(100) NOT NULL,
`type` VARCHAR(100) NOT NULL,
`course_id` VARCHAR(100) NOT NULL,
PRIMARY KEY (`sno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `courses`
--

INSERT INTO `courses` (`sno`, `course_name`, `duration`, `type`, `course_id`) VALUES
(1, 'Ms-Office', '1', 'M', 'ms001'),
(2, 'Visual Basic', '3', 'M', 'vb002'),
(3, 'Flash', '15', 'D', 'flash001'),
(4, 'PhotoShop', '3', 'M', 'photoshop1');

-- --------------------------------------------------------

--
-- Table structure for table `institutes`
--

CREATE TABLE `institutes` (
`sno` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(200) NOT NULL,
`institute_type` INT(11) NOT NULL,
`code` VARCHAR(200) NOT NULL,
PRIMARY KEY (`sno`),
KEY `sno` (`sno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `institutes`
--

INSERT INTO `institutes` (`sno`, `name`, `institute_type`, `code`) VALUES
(1, 'RKMV Shimla', 1, 'C-1'),
(2, 'GC Seema', 1, 'C-2'),
(3, 'GC Rampur', 1, 'C-3'),
(4, 'GC Sanjauli', 1, 'C-4'),
(5, 'GC Chaura Maidan', 1, 'C-5'),
(6, 'GC Theog', 1, 'C-6'),
(7, 'GC Saraswatinagar', 1, 'C-7'),
(8, 'GSSS Suni', 2, 'S-1'),
(9, 'GSSS Rampur(B)', 2, 'S-2'),
(10, 'GSSS Theog(B)', 2, 'S-3'),
(11, 'GSSS Rampur(G)', 2, 'S-4'),
(12, 'GSSS Chhota Shimla', 2, 'S-5'),
(13, 'GSSS Lakkar Bazar', 2, 'S-6'),
(14, 'GSSS Portmore(G)', 2, 'S-7'),
(15, 'GSSS Sanjauli', 2, 'S-8'),
(16, 'GSSS Shimla(B)', 2, 'S-9');

-- --------------------------------------------------------

--
-- Table structure for table `institute_name`
--

CREATE TABLE `institute_name` (
`name` VARCHAR(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `institute_name`
--

INSERT INTO `institute_name` (`name`) VALUES
('GSSS Suni');

-- --------------------------------------------------------

--
-- Table structure for table `login`
--

CREATE TABLE `login` (
`sno` INT(11) NOT NULL AUTO_INCREMENT,
`username` VARCHAR(100) NOT NULL,
`password` VARCHAR(100) NOT NULL,
`code` INT(11) NOT NULL,
PRIMARY KEY (`sno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `login`
--

INSERT INTO `login` (`sno`, `username`, `password`, `code`) VALUES
(1, 'GSSSSUNI', 'GSSSSUNI', 1);

-- --------------------------------------------------------

--
-- Table structure for table `student_batch`
--

CREATE TABLE `student_batch` (
`batchid` VARCHAR(100) NOT NULL,
`Student_id` VARCHAR(100) NOT NULL,
`name` VARCHAR(200) NOT NULL,
`batchtime` VARCHAR(100) NOT NULL,
`batchdays` VARCHAR(100) NOT NULL,
`batchdate` DATE NOT NULL,
`totalenroll` INT(11) NOT NULL,
`course` VARCHAR(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `student_batch`
--

INSERT INTO `student_batch` (`batchid`, `Student_id`, `name`, `batchtime`, `batchdays`, `batchdate`, `totalenroll`, `course`) VALUES
('B-2', 'S-1-1', 'Manoj Satywali', '7-8 AM', 'MWF', '0000-00-00', 0, 'Ms-Office'),
('B-1', 'S-1-2', 'Ajay Sharma', '7-8 AM', 'MWF', '0000-00-00', 0, 'Ms-Office'),
('B-1', 'S-1-3', 'Sanjay Kothari', '7-8 AM', 'MWF', '0000-00-00', 0, 'Ms-Office');

-- --------------------------------------------------------

--
-- Table structure for table `student_details`
--

CREATE TABLE `student_details` (
`sno` INT(11) NOT NULL AUTO_INCREMENT,
`Student_name` VARCHAR(100) NOT NULL,
`User_name` VARCHAR(20) NOT NULL,
`password` VARCHAR(12) NOT NULL,
`Class` VARCHAR(20) NOT NULL,
`Category` VARCHAR(20) NOT NULL,
`Contact_no` VARCHAR(20) NOT NULL,
`Email` VARCHAR(100) NOT NULL,
`institute_name` VARCHAR(200) NOT NULL,
`Student_id` VARCHAR(100) NOT NULL,
`batchcode` VARCHAR(100) DEFAULT NULL,
`last_accessed` datetime NOT NULL,
UNIQUE KEY `sno` (`sno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `student_details`
--

INSERT INTO `student_details` (`sno`, `Student_name`, `User_name`, `password`, `Class`, `Category`, `Contact_no`, `Email`, `institute_name`, `Student_id`, `batchcode`, `last_accessed`) VALUES
(1, 'Manoj Satywali', 'manojsatywali', '12345', '10th', 'science', '9540097170', 'manoj.satywali@planetdewsoft.com', 'GSSS Suni', 'S-1-1', 'B-2', '0000-00-00 00:00:00'),
(2, 'Ajay Sharma', 'ajay', '1234', '10th', 'Arts', '9585828585', 'ajay.sharma@planetdewsoft.com', 'GSSS Suni', 'S-1-2', 'B-1', '2010-03-26 16:01:22'),
(3, 'Sanjay Kothari', 'kothari', '12345', '10th', 'arts', '1234567899', '', 'GSSS Suni', 'S-1-3', 'B-1', '0000-00-00 00:00:00'),
(4, 'Prakash Singh', 'prakash', '12345', '12th', 'arts', '2121212121', '', 'GSSS Suni', 'S-1-4', NULL, '0000-00-00 00:00:00'),
(5, 'Vivek Paul', 'paul', '123', '12th', 'commercer', '1245845444', 'vivek.paul@planetdewsoft.com', 'GSSS Suni', 'S-1-5', NULL, '2010-04-14 14:31:00'),
(6, 'Rajeev Kumar', 'rajeev', '12345', '10th', 'arts', '05245245145', 'rajeev@rediffmail.com', 'GSSS Suni', 'S-1-6', NULL, '0000-00-00 00:00:00'),
(7, 'Ajay singh', 'ajay123', '123', '8th', 'science', '9899895797', '', 'GSSS Suni', 'S-1-7', NULL, '2010-04-15 16:12:38');

-- --------------------------------------------------------

--
-- Table structure for table `t_group`
--

CREATE TABLE `t_group` (
`sno` INT(4) NOT NULL AUTO_INCREMENT,
`training_time` VARCHAR(70) NOT NULL,
`recommended_time` VARCHAR(70) NOT NULL,
`group_name` VARCHAR(70) NOT NULL,
PRIMARY KEY (`sno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `t_group`
--

INSERT INTO `t_group` (`sno`, `training_time`, `recommended_time`, `group_name`) VALUES
(1, '150', '170', 'Level 1 - Basic'),
(2, '145', '155', 'Level 2 - Advanced'),
(3, '135', '145', 'Level 3 - Expert');

-- --------------------------------------------------------

--
-- Table structure for table `user_track`
--

CREATE TABLE `user_track` (
`sno` INT(11) NOT NULL AUTO_INCREMENT,
`training_id` INT(200) DEFAULT NULL,
`user_name` VARCHAR(200) NOT NULL,
`training_name` VARCHAR(200) DEFAULT NULL,
`training_time` VARCHAR(200) DEFAULT NULL,
`recommendate_time` VARCHAR(200) DEFAULT NULL,
`exercise` VARCHAR(100) NOT NULL,
`last_accessed` datetime DEFAULT NULL,
`grade` VARCHAR(10) DEFAULT NULL,
`progress` INT(11) DEFAULT NULL,
`institute_name` VARCHAR(200) NOT NULL,
`Student_id` VARCHAR(200) NOT NULL,
`slide_no` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`sno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `user_track`
--

INSERT INTO `user_track` (`sno`, `training_id`, `user_name`, `training_name`, `training_time`, `recommendate_time`, `exercise`, `last_accessed`, `grade`, `progress`, `institute_name`, `Student_id`, `slide_no`) VALUES
(1, NULL, 'manojsatywali', 'English to Hindi', NULL, NULL, 'NO', NULL, NULL, 0, 'GSSS Suni', 'S-1-1', 0),
(2, NULL, 'ajay', 'English to Hindi', NULL, NULL, 'NO', '2009-11-07 13:41:31', NULL, 0, 'GSSS Suni', 'S-1-2', 0),
(3, NULL, 'kothari', 'English to Hindi', NULL, NULL, 'NO', NULL, NULL, 0, 'GSSS Suni', 'S-1-3', 0),
(4, NULL, 'prakash', 'English to Hindi', NULL, NULL, 'NO', NULL, NULL, 0, 'GSSS Suni', 'S-1-4', 0),
(5, NULL, 'paul', 'English to Hindi', NULL, NULL, 'NO', '2009-10-20 17:22:36', NULL, 33, 'GSSS Suni', 'S-1-5', 1),
(6, NULL, 'rajeev', 'English to Hindi', NULL, NULL, 'NO', '2009-10-20 17:45:07', NULL, 100, 'GSSS Suni', 'S-1-6', 3),
(7, NULL, 'ajay123', 'English to Hindi', NULL, NULL, 'NO', '2009-11-05 15:06:52', NULL, 33, 'GSSS Suni', 'S-1-7', 4);

 Download College Management System PHP Project Source Code


The following two tabs change content below.
Hi, Find more on FB...

Latest posts by Ramesh Gavva/Kasarla shanthan (see all)

posted in CSE Mini Projects, CSE Projects, CSE Projects with Source Code, Php Projects by Ramesh Gavva/Kasarla shanthan

Follow comments via the RSS Feed | Leave a comment | Trackback URL


‹‹‹ Activity Tracker ASP.NET Project Abstract

Internship Resume Format ›››

Custom Search

12 Comments to "College Management System PHP Project Source Code"

  1. amit chaddha wrote:

    plz send me college management project……………………………………

  2. Akshat Shrivastava wrote:

    Hi can i please know the user name n password required to run this software… plz reply soon!

  3. abha wrote:

    hey please send me this project!
    Thanks! :)

  4. bhushan wrote:

    please send me the college management project in php please urjent required

  5. Gagan wrote:

    hey i did not get php code in this project

  6. Projects Helper wrote:

    This link may help you it is student management system. http://projectseminar.org/php-projects/student-information-system-project/705/

  7. MONIKA wrote:

    plez send me codind of this site

  8. kalpana wrote:

    Hai please send the source coding for college management system in HTML

  9. Douglas wrote:

    please send me college management project in full with the source codes. Kindly reply , if possible give me your mobile number i will call you.

  10. Diwakar wrote:

    Sir,

    Can I know the username and password required to login in into the project

  11. ramana wrote:

    tell username
    and password for this program

  12. patelkamlesh wrote:

    plz send your collage management system in project…..php

Leave Your Comment

 
Copyright 2014 | Powered by 1000Projects.org | Developed by WikiHands.