ajaxCRUD.com

FAQs

Code to Create The Table Above:

#required file and class
require_once ('preheader.php');
include_once ('ajaxCRUD.class.php')

$tblFAQ = new ajaxCRUD("FAQ", "tblFAQ", "pkFAQID");

#displays
$tblFAQ->displayAs("fldQuestion", "Question");
$tblFAQ->displayAs("fldAnswer", "Answer");
$tblFAQ->displayAs("fldSort", "Sort Order");

$tblFAQ->omitPrimaryKey();

#order by fldSort
$tblFAQ->addOrderBy("ORDER BY fldSort");

#set some textbox heights
$tblFAQ->setTextareaHeight('fldQuestion', 50);
$tblFAQ->setTextareaHeight('fldAnswer', 125);

#abbreviate the text for the display (no impact on edit)
$tblFAQ->formatFieldWithFunction("fldAnswer", "abbrivText");

#actually show to the table
$tblFAQ->showTable();

#the callback function to abbreviate the answer text
function abbrivText($text){
	return substr($text, 0, 200) . "...";
}