Consider the following table:
CREATE TABLE IF NOT EXISTS `tblNBA` ( `id` int(11) NOT NULL auto_increment, `playoffs` varchar(20) default NULL, `logo` text, `name` varchar(60) default NULL, `founded` int(11) default NULL, `description` text, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;View Insert SQL Statements
| Playoffs | Logo | Name | Founded | Description |
|---|---|---|---|---|
| No |  | Boston Celtics | 1947 | The Boston Celtics is a professional basketball team based in Boston, Massachusetts, playing in the Atlantic Division of the Eastern Conference in the National Basketball Association (NBA). The team is owned by Wycliffe Grousbeck and coached by Doc Rivers, with Danny Ainge as the President of Basketball Operations. Founded in 1946, their 17 NBA Championships are the most for any NBA franchise |
| No |  | Cleveland Cavaliers | 1970 | |
| No |  | Chicago Bulls | 1966 | The Chicago Bulls are an American professional basketball team based in Chicago, Illinois, playing in the Central Division of the Eastern Conference in the National Basketball Association (NBA). The team was founded in 1966. They play their home games at the United Center. The team is well known for having one of the greatest dynasties in NBA history during the 1990s, winning six championships in 8 years with two three-peats. All six of those championship teams were led by Michael Jordan, Scottie Pippen and coach Phil Jackson. |
| No |  | Milwaukee Bucks | 1968 | The Milwaukee Bucks are a professional basketball team based in Milwaukee, Wisconsin. They play in the National Basketball Association (NBA). The current franchise owner is U.S. Senator Herb Kohl. |
#required file and class
require_once ('preheader.php');
include_once ('ajaxCRUD.class.php')
#this one line of code is how you implement the class
$tblDemo = new ajaxCRUD("NBA Team", "tblNBA", "id");
$tblDemo->omitPrimaryKey();
$tblDemo->displayAs("playoffs", "Playoffs");
$tblDemo->displayAs("logo", "Logo");
$tblDemo->displayAs("name", "Name");
$tblDemo->displayAs("founded", "Founded");
$tblDemo->displayAs("description", "Description");
#define that a field if a checkbox
$tblDemo->defineCheckbox('playoffs','Yes','No');
#add an ajax filter box
$tblDemo->addAjaxFilterBox('name');
#formatFieldWithFunction is a powerful method
$tblDemo->formatFieldWithFunction('logo', 'makeImg');
$tblDemo->formatFieldWithFunction('name', 'makeUnderline');
#don't allow table editing
$tblDemo->turnOffAjaxEditing();
#don't allow table adding
$tblDemo->turnOffAjaxADD();
#don't allow deleting of rows
$tblDemo->disallowDelete();
#actually show the table
$tblDemo->showTable();
function makeUnderline($val){
return "<u>$val</u>";
}
function makeImg($val){
return "<img src=\"$val\" width=\"100\" />";
}
Click here to view example outside of the template.
