In this tutorial, I will teach you how to create a quick search with jQuery, PHP and MySQL Database.
With this, you can find easilly the record that you’re going to search in the input box. This is useful and high performace jQuery methods for instant search in the large set of data from the table.
It also turns all input box into quick and easy searching of data.
Let’s begin:
- Create a database in the MySQL and name it “quicksearchdb“.
- Create a table in the database that you have created.
CREATE TABLE IF NOT EXISTS `subject` ( `SUBJ_ID` int(11) NOT NULL AUTO_INCREMENT, `SUBJ_CODE` varchar(30) NOT NULL, `SUBJ_DESCRIPTION` varchar(255) NOT NULL, `UNIT` int(2) NOT NULL, `YR` varchar(30) NOT NULL, `AY` varchar(30) NOT NULL, PRIMARY KEY (`SUBJ_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=438 ;
- Insert the following data in the table.
INSERT INTO `subject` (`SUBJ_ID`, `SUBJ_CODE`, `SUBJ_DESCRIPTION`, `UNIT`, `YR`, `AY`) VALUES (11, 'Theology 1', 'Faith and Creed and Basic Catholic Doctrine', 3, 'Grade 7', '2013-2014'), (12, 'English 0', 'English Plus ', 3, 'Grade 7', '2013-2014'), (13, 'English 1', 'Developmental Reading', 3, 'Grade 7', '2013-2014'), (14, 'Theology 1', 'Faith and Creed and Basic Catholic Doctrine', 3, 'Gade 8', '2013-2014'), (15, 'History 1', 'Philippine History and Culture', 3, 'Grade 7', '2013-2014'), (16, 'Psychology 1a', 'General Psychology with Moral Regen & Drug Abuse Ed.', 3, '22', '2013-2014'), (17, 'Chem. 1', 'General and Organic Chemistry', 5, '22', '2013-2014'), (18, 'Philosophy 1', 'Introduction to Philosophy', 3, '22', '2013-2014'), (19, 'PE 1', 'Physical Education', 2, '22', '2013-2014'), (20, 'NSTP 1', 'NSTP', 3, 'Grade 7', '2013-2014'), (21, 'Theology 2', 'Bible and Salvation History ', 3, '22', '2013-2014'), (22, 'English 1', 'Study and Thinking Skills ', 3, '22', '2013-2014'), (23, 'English 02', 'Developmental Reading 2', 3, '22', '2013-2014'), (24, 'Math 2', 'Modern College Algebra ', 3, '22', '2013-2014'), (25, 'Nat. Sci. 3', 'Physical Science', 3, '22', '2013-2014'), (26, 'Philo. 3', 'Logic', 3, '22', '2013-2014'), (27, 'Educ. 2', 'Child and Adolescent Development', 2, '22', '2013-2014'), (28, 'PE 2', 'Rhythmic Activities', 3, '22', '2013-2014'), (29, 'NSTP 2', 'NSTP', 3, '22', '2013-2014'), (30, 'Theology 3', 'Liturgy and Sacraments in General', 3, '23', '2013-2014'), (31, 'English 2 ', 'Writing in the Decipline', 3, '23', '2013-2014'), (32, 'English 3', 'Speech Communication', 3, '23', '2013-2014'), (33, 'English 4', 'Interactive English', 3, '23', '2013-2014'), (34, 'Filipino 1', 'Komunikasyon sa Akademikong Filipino', 3, '23', '2013-2014'), (35, 'Math 2', 'Plane and Spherical Trig.', 3, '23', '2013-2014'), (36, 'Philo. 5', 'Philosophy of being', 3, '23', '2013-2014'), (37, 'Philo. 2', 'General Ethics', 3, '23', '2013-2014'), (38, 'PE 3', 'Individual/ Dual Sports/ Games', 2, '23', '2013-2014'), (39, 'Theology 4', 'Commandments and Christian Morality ', 3, '23', '2013-2014'), (40, 'English 15', 'Philippine Literature', 3, '23', '2013-2014'), (41, 'English 7a', 'Effective Writing', 3, '23', '2013-2014'), (42, 'Filipino 2', 'Pagbasa at Pagsulat Tungo sa Pananaliksik', 3, '23', '2013-2014'), (43, 'Nat. Sci. 4', 'Ecology', 3, '23', '2013-2014'), (44, 'Philo. 6', 'Philosophy of Nature', 3, '23', '2013-2014'), (45, 'Philo. 17', 'Special Ethics', 3, '23', '2013-2014'), (46, 'PE 4', 'Team Sports and Games', 2, '22', '2013-2014'), (47, 'Theology 5', 'Church History and Church Today', 3, '24', '2013-2014'), (48, 'Filipino 3', 'Masining na Pagpapahayag', 3, '24', '2013-2014'), (49, 'Nat. Sci. 2 ', 'Biological Science', 3, '24', '2013-2014'), (50, 'Philo. 4', 'Theodicy', 3, '24', '2013-2014'), (51, 'Philo. 13', 'History of Ancient Philosophy', 3, '24', '2013-2014'), (52, 'Philo. 8a', 'Philosophical Pyschology', 3, '24', '2013-2014'), (53, 'Educ. 104', 'Principles of Teaching 1', 3, '24', '2013-2014'), (54, 'Computer 1', 'Basic Computer', 3, '24', '2013-2014'), (55, 'Theology 6', 'Social Teaching of the Church', 3, '24', '2013-2014'), (56, 'English 5', 'Business English and Correspondence', 3, '24', '2013-2014'), (57, 'English 17', 'World Literature', 3, '24', '2013-2014'), (58, 'Philo. 14', 'History of Medieval Philosophy', 3, '24', '2013-2014'), (59, 'Philo. 7', 'Philosophy of Knowledge', 3, '24', '2013-2014'), (60, 'Philo. 19', 'Philosophy of Education', 3, '24', '2013-2014'), (61, 'Computer 2', 'Software Application', 3, '24', '2013-2014'), (62, 'Humanities 2', 'Art Education', 3, '24', '2013-2014'), (63, 'Pol. Sci. 4', 'Politics and Governance with PC', 3, '25', '2013-2014'), (64, 'Philo. 51', 'Philosophy of Religion', 3, '25', '2013-2014'), (65, 'Philo. 16', 'History of Modern Philosophy', 3, '25', '2013-2014'), (66, 'Philo. 31', 'Oriental Philosophy', 3, '25', '2013-2014'), (67, 'Economics 1', 'Principles of Economics with TAR', 3, '25', '2013-2014'), (68, 'Educ. 102', 'Facilitating Learning', 3, '25', '2013-2014'), (69, 'Soc. Sci. 19', 'Society and Culture', 3, '25', '2013-2014'), (70, 'Philo. 18 ', 'History of Contemporary Philosophy ', 3, '25', '2013-2014'), (71, 'Philo. 9a', 'Social Phylosophy', 3, '25', '2013-2014'), (72, 'Philo. 20', 'Elements of Filipino Phylosophy', 3, '25', '2013-2014'), (73, 'Philo. 11', 'Social Phylosophy II: Values Identification & Inculcation (lncl. Institution & Ideologies)', 3, '25', '2013-2014'), (74, 'Rizal', 'Life, Works and Writings of Doctor Jose Rizal', 3, '25', '2013-2014'), (75, 'Theology 1', 'Faith and Creed and Basic Catholic Doctrine', 3, '14', '2013-2014'), (76, 'English 0', 'English Plus', 3, '26', '2013-2014'), (77, 'English 01 ', 'Developmental Reading', 3, '26', '2013-2014'), (78, 'History 1', 'Philipine History and Culture', 3, '26', '2013-2014'), (79, 'Psycho. 1a', 'General Psychology with Moral Regen & Drug Abuse Ed.', 3, '26', '2013-2014'), (80, 'Chem. 1', 'General & Inorganic Chemistry', 3, '26', '2013-2014'), (81, 'Economics 1', 'Principles of Economics with TAR', 3, '26', '2013-2014'), (82, 'PE 1', 'Physical Fitness', 2, '14', '2013-2014'), (83, 'NSTP 1', 'NSTP', 3, '26', '2013-2014'), (84, 'Theology 2', 'Bible & Salvation History', 3, '26', '2013-2014'), (85, 'English 1', 'Study and Thinking Skills', 3, '26', '2013-2014'), (86, 'English 02', 'Developmental Reading 2', 3, '26', '2013-2014'), (87, 'Math 2', 'Modern College Algebra', 3, '26', '2013-2014'), (88, 'Soc. Sci. 19', 'Society and Culture with FP ', 3, '26', '2013-2014'), (89, 'Nat. Sci. 1', 'Physical Science', 3, '26', '2013-2014'), (90, 'Educ. 2', 'Child & Adolescent Development', 3, '26', '2013-2014'), (91, 'PE 2', 'Rhythmic Activities', 2, '26', '2013-2014'), (92, 'NSTP 2', 'NSTP', 3, '26', '2013-2014'), (93, 'Theology 3', 'Liturgy and Sacraments in General', 3, '27', '2013-2014'), (94, 'English 2', 'Writing in the Decipline', 3, '27', '2013-2014'), (95, 'English 3', 'Speech and Communication', 3, '27', '2013-2014'), (96, 'English 33a', 'Introduction to Language Study', 3, '27', '2013-2014'), (97, 'Filipino 1', 'Komunikasyon sa Akademikong Filipino', 3, '27', '2013-2014'), (98, 'Math 2', 'Plane and Spherical Trigonometry', 3, '27', '2013-2014'), (99, 'Nat. Sci. 2', 'Biological Science', 3, '27', '2013-2014'), (100, 'PE 3', 'Individual/ Dual Sports/ Games', 2, '27', '2013-2014'), (101, 'Theology 4', 'Commandments and Christian Morality', 3, '27', '2013-2014'), (102, 'English 15', 'Philippine Literature', 3, '27', '2013-2014'), (103, 'English 38', 'Mythology and Folklore', 3, '27', '2013-2014'), (104, 'English 50', 'Structure of the English Laguage', 3, '27', '2013-2014'), (105, 'English 40a', 'Applied Linguistics', 3, '27', '2013-2014'), (106, 'English 7a', 'Effective Writing', 3, '27', '2013-2014'), (107, 'Filipino 2', 'Pagbasa at Pagsulat tungo sa Pananaliksik', 3, '27', '2013-2014'), (108, 'PE 4', 'Team Sports and Games', 2, '27', '2013-2014'), (109, 'Theology 5', 'Church History and Church Today', 3, '28', '2013-2014'), (110, 'English 51', 'Language and Society', 3, '28', '2013-2014'), (111, 'English 52', 'Cross-Culture Communication', 3, '28', '2013-2014'), (112, 'English 53', 'Literary History of the Philippines', 3, '28', '2013-2014'), (113, 'Filipino 3', 'Masining na Pagpapahalaga', 3, '28', '2013-2014'), (114, 'English ', 'Interactive English', 3, '28', '2013-2014'), (115, 'Educ. 104', 'Principles of Teaching', 3, '28', '2013-2014'), (116, 'Computer 1', 'Basic computer', 3, '28', '2013-2014'), (117, 'Theology 6', 'Social Teaching of the Church', 3, '28', '2013-2014'), (118, 'English 5', 'Business English and Correspondence', 3, '28', '2013-2014'), (119, 'English 17a', 'Afro-Asian Literature', 3, '28', '2013-2014'), (120, 'English 54', 'Structure of the Filipino Language', 3, '28', '2013-2014'), (121, 'English 37', 'Creative Writing', 3, '28', '2013-2014'), (122, 'Nat. Sci. 4', 'Ecology', 3, '28', '2013-2014'), (123, 'Humanities 2', 'Art Education', 3, '28', '2013-2014'), (124, 'Computer 2', 'Software Application', 3, '28', '2013-2014'), (125, 'English 55', 'Language and culture', 3, '29', '2013-2014'), (126, 'English 14a', 'Anglo- American Literature', 3, '29', '2013-2014'), (127, 'English 56', 'European Literature', 3, '29', '2013-2014'), (128, 'Educ. 102 ', 'Facilitating Learning', 3, '29', '2013-2014'), (129, 'Pol. Sci. 4', 'Politics & Governance with PC', 3, '29', '2013-2014'), (130, 'English 57', 'Register in English', 3, '29', '2013-2014'), (131, 'English 9a', 'Argumentation', 3, '29', '2013-2014'), (132, 'English 58', 'Approaches in college English Teaching', 3, '29', '2013-2014'), (133, 'Rizal', 'Life, Works and Writings of Doctor Jose Rizal', 3, '29', '2013-2014'), (134, 'English 17', 'World Literature', 3, '29', '2013-2014'), (135, 'Phylosophy 11', 'Social Phylosophy II: Values Identification & Inculcation (lncl. Institution & Ideologies)', 3, '29', '2013-2014'), (136, 'Theology 1', 'Faith and Creed and Basic Catholic Doctrine', 3, '30', '2013-2014'), (137, 'English 0', 'English Plus', 3, '30', '2013-2014'), (138, 'Filipino 1', 'Komunikasyon sa Akademikong Filipino', 3, '30', '2013-2014'), (139, 'Math 01', 'Fundamentals of Mathematics', 3, '30', '2013-2014'), (140, 'Nat. Sci. 2b', 'Biological Science', 3, '30', '2013-2014'), (141, 'Psycho. 1a', 'General Psychology with Moral Regen & Drug Abuse Ed.', 3, '30', '2013-2014'), (142, 'ICT ', 'Basic computer', 3, '30', '2013-2014'), (143, 'Educ. ', 'Developmental Reading', 3, '30', '2013-2014'), (144, 'PE 1', 'Physical Fitness', 2, '30', '2013-2014'), (145, 'NSTP 1', 'ROTC 1/ CWTS 1', 3, '30', '2013-2014'), (146, 'Theology 2', 'Bible & Salvation History', 3, '30', '2013-2014'), (147, 'English 2', 'Study and Thinking Skills', 3, '30', '2013-2014'), (148, 'Filipino 02', 'Pagbasa at Pagsulat tungo sa Pananaliksik', 3, '30', '2013-2014'), (149, 'Math 02', 'Contemporary Mathematics', 3, '30', '2013-2014'), (150, 'Humanities 1', 'Art Education', 3, '30', '2013-2014'), (151, 'Educ. 101', 'Child & Adolescent Development', 3, '30', '2013-2014'), (152, 'Major', 'Structure of the English Laguage', 3, '30', '2013-2014'), (153, 'Rizal', 'Life, Works and Writings of Doctor Jose Rizal', 3, '30', '2013-2014'), (154, 'PE 2', 'Rhythmic Activities', 2, '30', '2013-2014'), (155, 'NSTP 2', 'ROTC 2/ CWTS 2', 3, '30', '2013-2014'), (156, 'Theology 3', 'Liturgy and Sacraments in General', 3, '31', '2013-2014'), (157, 'English 2', 'Writing in the Decipline', 3, '31', '2013-2014'), (158, 'Filipino 03', 'Masining na Pagpapahalaga', 3, '31', '2013-2014'), (159, 'Educ. 102', 'Facilitating Learning', 3, '31', '2013-2014'), (160, 'Educ. 103', 'Educational Technology 1', 3, '31', '2013-2014'), (161, 'Educ. 104', 'Principles of Teaching 1', 3, '31', '2013-2014'), (162, 'FS', 'Field Study 1 (Learning Dev''t Environment)', 1, '31', '2013-2014'), (163, 'Major', 'Social Dimension of Education', 3, '31', '2013-2014'), (164, 'Major', 'Teaching of Listening & Reading', 3, '31', '2013-2014'), (165, 'PE 3', 'Individual/ Dual Sports/ Games', 2, '31', '2013-2014'), (166, 'Theology 4', 'Commandments and Christian Morality', 3, '31', '2013-2014'), (167, 'English Literature', 'Philippine Literature', 3, '31', '2013-2014'), (168, 'Educ. 105', 'Educational Technology 2', 3, '31', '2013-2014'), (169, 'Educ. 106', 'Principles of Teaching 2', 3, '31', '2013-2014'), (170, 'FS 2', 'Field Study 2 (Experience the Technology Learning Process )', 1, '31', '2013-2014'), (171, 'FS 3', 'Field Study 3 (Tech. in the Learning Environment)', 1, '31', '2013-2014'), (172, 'Major', 'Teaching of Speaking', 3, '31', '2013-2014'), (173, 'Major', 'ESP', 3, '31', '2013-2014'), (174, 'Major', 'Intro to Linguistics', 3, '31', '2013-2014'), (175, 'Major', 'Mythology and Folklore', 3, '31', '2013-2014'), (176, 'PE 4', 'Team Sports and Games', 2, '31', '2013-2014'), (177, 'English 3', 'Speech and Oral Communication', 3, '31', '2013-2014'), (178, 'English Literature', 'World Literature', 3, '31', '2013-2014'), (179, 'Pol. Sci. 4', 'Politics & Governance with PC', 3, '31', '2013-2014'), (180, 'Theology 6', 'Church History and Church Today', 3, '32', '2013-2014'), (181, 'Educ. 108', 'Curriculum Development', 3, '32', '2013-2014'), (182, 'History 1', 'Philipine History: Roots and Development', 3, '32', '2013-2014'), (183, 'Educ. 109', 'Assessment of students Learning 1', 3, '32', '2013-2014'), (184, 'FS 4', 'Field Study 4(Understanding Curriculum Development)', 1, '32', '2013-2014'), (185, 'ST 1', 'Integrated Teaching Strategies', 1, '32', '2013-2014'), (186, 'Major', 'Teaching Literature', 3, '32', '2013-2014'), (187, 'Major', 'Speech and Stage Art', 3, '32', '2013-2014'), (188, 'Major', 'Mass Communication and Campus Journalism', 3, '32', '2013-2014'), (189, 'Major', 'Prep. & Eval. of Instruc. Materials', 3, '32', '2013-2014'), (190, 'Theology 6', 'Social Teaching of the Church', 3, '32', '2013-2014'), (191, 'Economics 1b', 'Principles of Economics with TAR', 3, '32', '2013-2014'), (192, 'Educ. 109', 'Assessment of students Learning 2', 3, '32', '2013-2014'), (193, 'FS 5', 'Field Study 5(Learning Assessment Strategies)', 1, '32', '2013-2014'), (194, 'ST 2', 'Use of Popular Media in teaching', 1, '32', '2013-2014'), (195, 'Major', 'Creative Writing', 3, '32', '2013-2014'), (196, 'Major', 'Remedial Instruction in English', 3, '32', '2013-2014'), (197, 'Major', 'Language Curriculum for Sec. Schools', 3, '32', '2013-2014'), (198, 'Major', 'Afro-Asian Literature', 3, '32', '2013-2014'), (199, 'Major', 'English & American Literature', 3, '32', '2013-2014'), (200, 'Nat. Sci. 2', 'Physical Science', 3, '32', '2013-2014'), (201, 'Philo. 3', 'Logic', 3, '32', '2013-2014'), (202, 'Soc. Sci. 19', 'Social & Culture with AP', 3, '32', '2013-2014'), (203, 'Educ.', 'The Teaching Profession', 3, '33', '2013-2014'), (204, 'FS 6', 'Field Study 6', 1, '33', '2013-2014'), (205, 'ST 3', 'Research', 3, '33', '2013-2014'), (206, 'Major', 'Language and Literature Assessment', 3, '33', '2013-2014'), (207, 'Major', 'Intro to Stylistic', 3, '33', '2013-2014'), (208, 'Major', 'Literary Criticism', 3, '33', '2013-2014'), (209, 'Major', 'Language Research', 3, '33', '2013-2014'), (210, 'Major', 'Translation & Editing of Text', 3, '33', '2013-2014'), (211, 'Students Teaching', 'Practice Teaching', 6, '33', '2013-2014'), (212, 'Theology 1', 'Faith and Creed & Basic Catholic Doctrine', 3, '34', '2013-2014'), (213, 'English 0', 'English Plus', 3, '34', '2013-2014'), (214, 'Filipino 01', 'Komunikasyon sa Akademikong Filipino', 3, '34', '2013-2014'), (215, 'Math 01', 'Fundamentals of Mathematics', 3, '34', '2013-2014'), (216, 'Nat. Sci. 2b', 'Biological Science', 3, '34', '2013-2014'), (217, 'Psychology 1a', 'General Psy. with Moral Regen & Drug Abuse Ed.', 3, '34', '2013-2014'), (218, 'ICT', 'Basic Computer', 3, '34', '2013-2014'), (219, 'Educ. ', 'Developmental Reading', 3, '34', '2013-2014'), (220, 'PE 1', 'Physical Fitness', 2, '34', '2013-2014'), (221, 'NSTP 1', 'ROTC 1/ CWTS 1', 3, '34', '2013-2014'), (222, 'Theology 2', 'Bible and Salvation History', 3, '34', '2013-2014'), (223, 'English 2', 'Study and Thinking Skills ', 3, '34', '2013-2014'), (224, 'Filipino 02', 'Pagbasa at Pagsulat Tungo sa Pananaliksik', 3, '34', '2013-2014'), (225, 'Math 02', 'Contemporary Mathematics', 3, '34', '2013-2014'), (226, 'Humanities 1', 'Art Education', 3, '34', '2013-2014'), (227, 'Educ. 101', 'Child and Adolescent Development', 3, '34', '2013-2014'), (228, 'Rizal ', 'Life, Works & Writings of Dr. Jose Rizal', 3, '34', '2013-2014'), (229, 'Major', 'Advance Algebra', 3, '34', '2013-2014'), (230, 'PE 2', 'Rhythmic Activities', 2, '34', '2013-2014'), (231, 'NSTP 2', 'ROTC 2/ CWTS 2', 3, '34', '2013-2014'), (232, 'Theology 3', 'Liturgy and Sacraments in General', 3, '35', '2013-2014'), (233, 'Filipino 03', 'Masining na Pagpapahalaga', 3, '35', '2013-2014'), (234, 'English 2', 'Writing & Discipline', 3, '35', '2013-2014'), (235, 'Educ. 102', 'Facilitating and Learning', 3, '35', '2013-2014'), (236, 'Educ. 103', 'Educational Technology', 3, '35', '2013-2014'), (237, 'Educ. 104', 'Principles of Teaching 1', 3, '35', '2013-2014'), (238, 'FS 1', 'Field Study 1 (Learning Dev''t Environment)', 1, '35', '2013-2014'), (239, 'Educ. ', 'Social Dimension of Education', 3, '35', '2013-2014'), (240, 'Major', 'Plane Geometry', 3, '35', '2013-2014'), (241, 'PE 3', 'Individual/ Dual Sports/ Games', 2, '35', '2013-2014'), (242, 'Theology 4', 'Commandments and Christian Morality', 3, '35', '2013-2014'), (243, 'English Literature', 'Philippine Literature', 3, '35', '2013-2014'), (244, 'Educ. 105', 'Educational Technology 2', 3, '35', '2013-2014'), (245, 'Educ. 106', 'Principles of Teaching 2', 3, '35', '2013-2014'), (246, 'FS 2', 'Field Study 2 (Experiencing the Tech. Learning Process)', 1, '35', '2013-2014'), (247, 'FS 3', 'Field Study 3 (Tech. in the Learning Environment)', 1, '35', '2013-2014'), (248, 'Major', 'Trigonometry', 3, '35', '2013-2014'), (249, 'Major', 'Solid Geometry', 3, '35', '2013-2014'), (250, 'Major', 'Analytic Geometry', 3, '35', '2013-2014'), (251, 'Major', 'Abstract Algebra', 3, '35', '2013-2014'), (252, 'PE 4', 'Team Sports and Games', 3, '35', '2013-2014'), (253, 'English 3', 'Speech and Oral Communication', 3, '35', '2013-2014'), (254, 'English Literature', 'World Literature', 3, '35', '2013-2014'), (255, 'Pol. Sci. 4', 'Politics and Governance with PC', 3, '35', '2013-2014'), (256, 'Theology 5', 'Church History and Church Today', 3, '36', '2013-2014'), (257, 'Educ. 108', 'Curriculum Development', 3, '36', '2013-2014'), (258, 'Educ. 109', 'Assessment of Student Learning 1', 3, '36', '2013-2014'), (259, 'FS 4', 'Field Study 4 (Understanding Curriculum Development)', 1, '36', '2013-2014'), (260, 'ST 1', 'Integrated Teaching Strategies', 1, '36', '2013-2014'), (261, 'History 1', 'Philippine History', 3, '35', '2013-2014'), (262, 'Major', 'Calculus', 3, '36', '2013-2014'), (263, 'Major', 'Elementary Statistics', 3, '36', '2013-2014'), (264, 'Major', 'Probability', 3, '36', '2013-2014'), (265, 'Major', 'Linear Algebra', 3, '36', '2013-2014'), (266, 'Theology 6', 'Social Teaching of the Church', 3, '36', '2013-2014'), (267, 'Economics 1b', 'Principles of Economics with TAR', 3, '36', '2013-2014'), (268, 'Educ. 110', 'Assessment of Student Learning 2', 3, '36', '2013-2014'), (269, 'Major', 'Calculus 2', 3, '36', '2013-2014'), (270, 'Major', 'Advance Statistics', 3, '36', '2013-2014'), (271, 'Major', 'Modern Geometry', 3, '36', '2013-2014'), (272, 'Major', 'Number Theory', 3, '36', '2013-2014'), (273, 'Major', 'Math Investigation and Modeling', 3, '36', '2013-2014'), (274, 'Nat. Sci. 3', 'Physical Science', 3, '36', '2013-2014'), (275, 'Philo. 3', 'Logic', 3, '36', '2013-2014'), (276, 'S. Sc. 19', 'Society and Culture with FP', 3, '36', '2013-2014'), (277, 'Ed. ', 'The Teaching Profession', 3, '37', '2013-2014'), (278, 'FS 6', 'Field Study', 1, '37', '2013-2014'), (279, 'ST 3', 'Research', 1, '37', '2013-2014'), (280, 'FS 5', 'Field Study 5 (Learning Assest Strategies)', 1, '36', '2013-2014'), (281, 'ST 2', 'Use of Popular Media in Teaching', 1, '37', '2013-2014');
- Create a landing page and name it “index.php“.
- Create a configuration between MySQL database and PHP script.
<?php
$server = 'localhost';
$dbuser = 'root';
$dbpass = '';
$dbname = 'quicksearchdb';
$con = mysql_connect($server, $dbuser, $dbpass);
if (isset($con)) {
# code...
$dbSelect = mysql_select_db($dbname);
if (!$dbSelect) {
echo "Problem in selecting database! Please contact administraator";
die(mysql_error());
}
} else {
echo "Problem in database connection! Please contact administraator";
die(mysql_error());
}
?>- Do these following codes for creating an in input box, table and retrieve all data in the database to the HTML element<table>.
<!DOCTYPE html>
<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-type">
<title>quickSearch jQuery plug-in</title>
<link href="css/bootstrap.min.css" media="all" rel="stylesheet" title=""
type="text/css">
</head>
<body class="container">
<h1>jQuery Quick Search</h1>
<form action="#">
<fieldset>
<input autofocus="" id="id_search" name="search" placeholder="Search" type="text" value="">
</fieldset><br>
</form>
<table class="table table-bordered" id="table_search" style=
"font-size:11px;">
<thead style="background-color:red;color:white">
<tr>
<th width="30%">Subject Code</th>
<th width="10%">Description</th>
<th width="10%">Unit</th>
<th width="10%">Year</th>
<th width="10%">Academic Year</th>
</tr>
</thead>
<tbody>
<?php
$sqlQuery = "SELECT * FROM `subject`";
$result = mysql_query($sqlQuery) or die(mysql_error());
while ($row = mysql_fetch_array($result)) {
echo '<tr>';
echo '<td>' .$row['SUBJ_CODE'].'</a></td>';
echo '<td>'. $row['SUBJ_DESCRIPTION'].'</td>';
echo '<td>'. $row['UNIT'].'</td>';
echo '<td>'. $row['YR'].'</td>';
echo '<td>'. $row['AY'].'</td>';
echo '</tr>';
}
?>
</tbody>
</table>
</body>
</html>- Finally, set the following jQuery plugins and create a script for searching all data in the table.
<script>
(function (w, doc,co) {
doc.write('<script src="jquery/jquery-2.2.4.min.js">' + "<" + '/' + 'script>');
})(window, document, console);
</script>
<script src="jquery/quickSearch.jquery.js"></script>
<script>
$(function () {
$('input#id_search').quicksearch('table#table_search tbody tr');
});
</script>For all students who need a programmer for their thesis system, or anyone who needs source code in any programming language, you can contact us.
Frequently Asked Questions
How does this PHP project work?
Built with vanilla PHP (no framework) and MySQL backend. Standard structure: form HTML, PHP script handlers, MySQL via PDO or mysqli, sessions for auth, Bootstrap for responsive layout. Ready to extend for BSIT capstone scope.
What PHP and MySQL versions does this project require?
Most projects in this batch run on PHP 7.4 to PHP 8.2 with MySQL 5.7+ or MariaDB 10+. A few older projects need PHP 5.6 (deprecated, use XAMPP 7.x). To run: install XAMPP / WAMP / Laragon, extract project to htdocs, import the included .sql file via phpMyAdmin, edit the connection file (usually config.php or db_connect.php) with your DB credentials, browse to the project URL in your browser.
How do I set up the database for this PHP project?
Open phpMyAdmin (http://localhost/phpmyadmin/ on XAMPP), create a new empty database with the name specified in the project’s config.php. Click the Import tab, choose the included .sql file, click Go. Then edit config.php (or includes/connection.php) with: ‘localhost’, your MySQL username (usually ‘root’), your MySQL password (usually blank for XAMPP), and the database name.
Can I use this PHP project for a BSIT capstone or thesis?
Yes, but extend it. A bare CRUD app is too narrow for full capstone scope. Add: user roles via session checks, reports/dashboards (Chart.js + AJAX), PDF exports (TCPDF library), email notifications (PHPMailer), real domain extension (analytics, audit log, multi-branch support). Pair with Chapter 1-5 documentation matching your panel’s rubric.
Why am I getting ‘connection error’ or ‘undefined function mysqli_connect’?
Three common PHP issues: (1) Connection error: Apache + MySQL services not running in XAMPP control panel, OR database name in config.php does not match what you created in phpMyAdmin. (2) ‘undefined function mysqli_connect’: MySQL extension not enabled, in php.ini uncomment extension=mysqli (then restart Apache). (3) ‘No such file or directory’: MySQL socket path wrong, use 127.0.0.1 instead of localhost in the connection string.
Where can I find more PHP projects with source code?
Browse the PHP Projects hub for the full library (300+ vanilla PHP systems). For modern PHP MVC alternatives see Laravel Projects (74 systems) or CodeIgniter Projects (32 systems). For BSIT-focused capstone idea lists see 150 Best Capstone Project Ideas.