Hello Friends,
I am working in a website where one search box is available, this website is for online training provider, so it has different pages for different courses. If anyone want to search by giving any course name the related course list or that particular course page should open. If anyone have any idea regarding this please help me and what are the different ways to achieve this means I have to maintain database or I can use xml also for this.
Regards,
Premashish
I would just use a database. Quick, easy to pull the needed info. Not too hard to program.
First, you need to layout your info and sort it somehow into some order that can be queried by SQL.
So, normally, a course-type database would have items like these for fields:
CourseName, CourseDate, CourseCost, CourseLocation, CourseInstructor, CourseDetails…
Most likely even more fields…
Then, in a sample course, let say like this:
Ernie Teaches PHP, now, $0, Here, Ernie, This course will cover ONLY basic course-type PHP coding…
As you see, this simple sample does not mention SQL or databases or how to display a course from the DB.
Etc… So, you might want another field with “tags” or “search keywords”. In that field you would put various
single words that might help in the searching for this course. Such as “Ernie course-type php coding database sql $0” or other words that might pertain to this course. Of course, (pun intended!) you could just make sure that the details or description of the course contains everything covered in the course in detail. (I would do it that way!) Then, you would not need the extra search keyword field.
Once you have the course in place in the database, you can query them using the “LIKE” clause.
You select * from course where details like “some search typed in”… Should work quickly and easy.
Hope that gets you started. Remember, programming is exactly like carpentry! Measure twice, cut once!
Layout twice, program once! (Heee, then debug, debug, debug… LOL)
But, that should start you off. Good luck…