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

   by loud canvas media

Quick Links:

Quick Examples:


QuestionComo es el?
AnswerYes, ai as aklsd lasid las jaslfk ...
Sort Order1
Answer as...
Sort Order2
QuestionY como es el?
AnswerBuena persona...
Sort Order3

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

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


#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

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


"ajaxCRUD is wonderful."
~Peter Barone

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.