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 programmer for your thesis system or anyone who needs a sourcecode in any programming languages. You can contact me @ :
Email – [email protected]
Mobile No. – 09305235027 – tnt