ajaxCRUD.com

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

Quick Links:

Quick Examples:

Format Field With Function

Consider the following table:

    CREATE TABLE tblDemo(
    pkID INT PRIMARY KEY AUTO_INCREMENT,
    fldField1 VARCHAR(40),
    fldField2 VARCHAR(40),
    fldField3 VARCHAR(40),
    fldCertainFields VARCHAR(40),
    fldLongField TEXT
    );

fldField1	fldField2	fldCertainFields	fldLongField
99 Saving...	9000 Saving...	My Awesome Value Saving...	kk000 Saving...
12 Saving...	hdgdgdf Saving...	This is another Value Saving...	t Saving...
15 Saving...	-- Saving...	My Awesome Value Saving...	-- Saving...
Eedaeza Saving...	dsaqdeade Saving...	NEW Value Saving...	dsaezd Saving...

Class Implementation:



#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("New Item", "tblDemo", "pkID");

$tblDemo->omitPrimaryKey();

$tblDemo->formatFieldWithFunction('fldField1', 'makeBlue');
$tblDemo->formatFieldWithFunction('fldField2', 'makeBold');

#actually show to the table
$tblDemo->showTable();

function makeBold($val){
	return "<b>$val</b>";
}

function makeBlue($val){
	return "<span style='color: blue;'>$val</span>";
}

View Example by Itself

Click here to view example outside of the template.

Recent Feedback

"Very interesting class. Thanks a lot. A little suggestion: when I edit a cell, but leaving the original value, an Error message says:"Error updating content.". It would be easier if `Cancel` button nor Error message appear.

" - Posted by gustavo on Friday Jan 8^th, 2010 at 11:45am

"haha. wow. i never knew this existed!" - Posted by Jason on Saturday Apr 17^th, 2010 at 9:47pm

"Great!! Thanks guys" - Posted by Rolly on Wednesday Nov 3^rd, 2010 at 9:46pm

"All you are a fucking bitches" - Posted by The Silly Boy on Wednesday Nov 24^th, 2010 at 8:03am

"Is there a possibility to make a "update"-Action instead of "delete"-Action?" - Posted by Max on Saturday Dec 11^th, 2010 at 11:42pm

"As Kimmy from Kath & Kim says: noice!" - Posted by lola_fatty_cunty on Sunday Jun 26^th, 2011 at 7:59am

"Hi, GREAT library that make my projects much easier!!! Thanks.

One hint: if you define a relationship (defineRelationship) you cannot use formatFieldWithFunction to e.g. format the field with the changed display of the content "blue". I tried it with the field-name of the table and the related field name of the foreign table...

Best wishes, Martin " - Posted by Martin on Tuesday Aug 9^th, 2011 at 4:48pm

"Just so you know, your post is not showing up right in my feed draeer (google draeer). This is the text that I gotDump The Land Line .adHeadline {font: bold 10pt Arial; text-decoration: underline; color: #65dd00;} .adText {font: normal 10pt Arial; text-decoration: none; color: #E6E6E6;}try{var AdBrite_Iframe=window.top!=window.self?2:1;var AdBrite_Referrer=document.referrer==``?document.location:document.referrer;AdBrite_Referrer=encodeURIComponent(" - Posted by Yudie on Sunday Mar 25^th, 2012 at 7:22am

"yes, this comment system looks quite inteligent." - Posted by ilham on Wednesday Aug 8^th, 2012 at 2:51pm

"Brilliant. Saved insane amounts of time. `nuff said."
~Soule