I have a database called studentregistration where I want to display a page for a student to search on a column called ourseSemester in a table named tblCourses. Then i want the search to return all hits.

I have get the page to display but it will not search properly.

Below is my PHP code to date for the search page - Note, I do know my config files works for opening and selecting the database since I am using it in other pages of my project.

prepare("select * tblCourses where courseSemester like '%$search%'"); $stmt->execute(); $course_details = $stmt->fetchAll(PDO::FETCH_ASSOC); //print_r($course_details); } else { $searchErr = "Please enter the information"; } } ?>

University ABC - Online Course Finder

Search Course by Semester::

*

Search Result

No data found'; } else{ foreach($course_details as $key=>$value) { ?>

Course Code	Course Name	Semester	Number of Available Seats

Course Selection

I have also attached a screen shot of the screen.

Search Course by Semester:: Course Selection Search Result No data found Course Code Course Name Semester Number of Available Seats