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


fldField1fldField2fldCertainFieldsfldLongFieldAction
1 2 00 42343

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.

Non-Commercial Use

If you use ajaxCRUD™ on a website for non-profit/charity use OR for educational purposes, then you do NOT need our permission.

Download and play away! :-)


FREE

Download

For-Profit Organization

Plan to use ajaxCRUD™ on a business/commercial website? You must purchase a license.

What is a single website?

A single website is defined as a single domain name which hosts a collection of web pages which serve a single entity or business. For example www.loudcanvas.com is a single website; ajaxcrud.com is a single website.

Subdomains are allowable under the single commercial website license. Therefore, if you use the subdomain development.xyz.com then you also own/maintain www.xyz.com; we consider the primary domain a single website and the ajaxCRUD software may be installed on any number of its subdomains.

AJAXCRUD - SINGLE DOMAIN COMMERCIAL LICENSE

You are allowed to use this product or part(s) of it on a single web site only, belonging to either you or your client. You have to purchase the same product again if you want to use the same product in connection with another or other projects.


Any analysis of the program, embedded data or license files by any means and by any entity whether human or otherwise and including but without limitation to discover details of internal operation, to reverse engineer, to de-compile object code, or to modify for the purposes of modifying behavior is forbidden.


Any analysis of encoded files by any means and by any entity whether human or otherwise and including but without limitation to discover details of file format or modification for the purposes of modifying behavior or scope of their usage is forbidden.


All imagery and fonts used in this product are an integral part of the product. You can use images and fonts only as a part of the web site you build using this product. You can use imagery and fonts to develop one project only. Any kind of separate usage or distribution is strictly prohibited.


You are authorized to make necessary modifications to this product to fit your purposes in accordance with this license.


The product is property of Tania Alekova. You shall not offer this product or part(s) of it, modified or unmodified, for redistribution or resale of any kind. You shall not sub-license, assign, or transfer this product or part(s) of it to any entity.


THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDER AND CONTRIBUTOR "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTOR BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

What is a commercial use?

If you are NOT an official Charity/Non-Profit organization (or a student or educational facility) then you likely are a commercial/for-profit orgnization.

If your organization makes a profit, you are a for-profit company. A commercial site 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 commercial even if it doesn't sell anything on the site, as it's purpose is to market/promote a commercial company.

$9.95/mo

Buy Now

Enterprise/Unlimited

The Unlimited License permits you or your company to use ajaxCRUD™ on any/all commercial websites you develop now or in the future.

For any questions please contact us..

$499 (one-time)

Buy Now

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 8th, 2010 at 11:45am

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

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

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

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

"As Kimmy from Kath & Kim says: noice!" - Posted by lola_fatty_cunty on Sunday Jun 26th, 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 9th, 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 25th, 2012 at 7:22am

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

"Hi,
How could I add pkid manually on add my item?" - Posted by Mollo on Saturday Nov 30th, 2013 at 6:58pm

Leave a Comment

Your Name      
Your Email   
Comment