Board index   FAQ   Search  
Register  Login
Board index PHP PHP Scripts

Looking for Knowledge base / FAQ script (but need help)

Links for php scripts

Moderators: macek, egami, gesf

Postby gesf » Mon May 09, 2005 6:00 pm

I really don't know any working script like that!

Well, first you need to create the proper MySQL tables, so you can store and work around the FAQS data.
What you'll need ? Well... i think a table with 3 fields whould be enough.
An Id, to easily work with your data. A question and an answer fields... yeh... that's it!

So you can make:
Code: Select all
CREATE TABLE faq (
  id tinyint(3) unsigned NOT NULL auto_increment,
  question varchar(255) NOT NULL default '',
  answer text,
  PRIMARY KEY  (id)
) TYPE=MyISAM


For the glossary:
Code: Select all
CREATE TABLE glossary (
  id mediumint(8 ) NOT NULL auto_increment,
  letter char(1) NOT NULL default '',
  title varchar(30) NOT NULL default '',
  description tinytext NOT NULL,
  content text NOT NULL,
  formatch enum('Yes','No') NOT NULL default 'No',
  PRIMARY KEY  (id),
  UNIQUE KEY id (id)
) TYPE=MyISAM


In this case, formatch will be a field to determine whether that Term will appear in some content with a link to the glossary page (complete term). letter, the letter group.
Now you have to make the proper REGEX, so you can match a term inside a content.

50% job done!
Now you just need to make all the forms/code to handle this!
User avatar
gesf
Moderator
Moderator
 
Posts: 1718
Joined: Sun Dec 29, 2002 5:03 am
Location: Portugal / Sweden

Return to PHP Scripts

Who is online

Users browsing this forum: Google [Bot] and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.

cron