ajaxCRUD.com

» a PHP class to Create, Read, Update, & Delete from a mysql database table using AJAX

   by loud canvas media

Quick Links:

Quick Examples:


FAQs

Questiontes
Answertest...
Sort Order1
Action
QuestionComent ?
AnswerCa va !...
Sort Order2
Action



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) . "...";
}


 

"just what i [was] look[ing] for..."
~Sergey

What is a business/commercial website?

A commercial website is one created for a business, for which purpose is generating revenue or cash flow of any type (and that isn't under a non-profit organization). So if you're selling a product, selling advertisement, selling a service, or just marketing a commercial business, your site is commercial. A company website is also commercial even if it doesn't sell anything, as it's purpose is to front a commercial company.
Close