Exemple #1
0
}
#Create an instance of the class
$tblEventAttendee = new ajaxCRUD("Person", "tblEventAttendee", "pkAttendeeID", "../ajaxcrud/");
$tblEventAttendee->doActionOnShowTable = false;
//this ensures showTable() does not call doAction; i do not want to do this because my onAdd callback function creates a cookie
$tblEventAttendee->omitPrimaryKey();
#Create custom display fields
//$tblEventAttendee->displayAs("pkAttendeeID","User ID");
$tblEventAttendee->displayAs("fldFirstName", "First Name");
$tblEventAttendee->displayAs("fldLastName", "Last Name");
$tblEventAttendee->displayAs("fldPhone", "Phone #");
$tblEventAttendee->displayAs("fldWillBeLate", "Will You Be Late?");
$tblEventAttendee->displayAs("fldTimeArriving", "Arrival Time");
$tblEventAttendee->displayAs("fldComments", "Comments/Other");
$tblEventAttendee->displayAs("fldIPAddress", "IPAddress");
$tblEventAttendee->omitFieldCompletely("fldIPAddress");
$tblEventAttendee->omitFieldCompletely("fkEventID");
$tblEventAttendee->omitFieldCompletely("fldPhone");
$tblEventAttendee->omitFieldCompletely("fldAttending");
$tblEventAttendee->validateDeleteWithFunction("canRowBeModifiedOrDeleted");
$tblEventAttendee->validateUpdateWithFunction("canRowBeModifiedOrDeleted");
$tblEventAttendee->defineCheckbox("fldWillBeLate");
$tblEventAttendee->addOrderBy("ORDER BY fldFirstName ASC");
#Add WHERE clause so we only display information specific to the event that was selected
$tblEventAttendee->addWhereClause("WHERE fkEventID = {$eventID}");
#I could add filter boxes to the top, but have chosen not to do so; commenting these out
//$tblEventAttendee->addAjaxFilterBox("fldFirstName");
//$tblEventAttendee->addAjaxFilterBox("fldLastName");
//$tblEventAttendee->addAjaxFilterBox("fldAttending");
//using addValueOnInsert so when someone signs up it will automatically add them to this event
$tblEventAttendee->addValueOnInsert("fkEventID", $eventID);