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

   by loud canvas media

Quick Links:

Quick Examples:


Questionno links please (you will be banned!)
Answerno links please (you will be banned!)...
Sort Order0
QuestionМебель -> mebel-catalog.blogspot.ru
AnswerМебель -> mebel-catalog.blogspot.ru...
Sort Order0
Sort Order12

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


"GREEEAT functions! Easily understandable code, I`m loooovving it. Great work! :D "
~Svend Koustrup

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.