How to build searchable/dynamic FAQ database in PHP?

A

Anonymous

Guest
I need to build an FAQ type of database for my website using php & mysql.

I want it to be dynamic so I don't have create individual pages and make changes and additions easier.

There of course will be a title and a body of text. I think it should store basic html code for display purposes.

Can anyone point me in the right direction for this? A general howto to get me started would be great.

Thanks
 
This sounds like a big project, and it sounds like you're pretty much a beginner to PHP. What I recommend is that you go to your local bookstore and buy a book about PHP and learn the language, and then go on to learn MySQL. You should be on your way within a couple of weeks.
 
I'm not a total beginner. I do currently have a web app that does searches on a database and allows user inserting of data.

So I guess I can use the same concept.

Any other tips or information?

Thanks
 
If you anticipate a lot of searching, then you're going to want to read up on FULLTEXT searches, and also you're going to want a bit of time making sure your keys are optimal. The former is covered in the documentation, the latter just takes a bit of know-how. Unfortunately, I don't have a lot of resources for you at hand (taking an actual course in database design is the best way to learn this, but probably isn't what you're interested in), but Google might be of help.
 
Would I be better off just loading one of the free php Forums to use instead?

Thanks for any info
 
For an FAQ/KB sort of application? Well, in the long run, no, you probably wouldn't be better off. But you would save a lot of effort right now. It's a trade-off, I guess.
 
i think mysql db with a fulltext is the best option.

just look for a simple mysql tutorial. and that would be it.

its very easy :-D
 
You must log in or register to reply here.
Back
Top