DZone
Web Dev Zone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
  • Refcardz
  • Trend Reports
  • Webinars
  • Zones
  • |
    • Agile
    • AI
    • Big Data
    • Cloud
    • Database
    • DevOps
    • Integration
    • IoT
    • Java
    • Microservices
    • Open Source
    • Performance
    • Security
    • Web Dev
DZone > Web Dev Zone > Painless CRUD in PHP via AjaxCrud

Painless CRUD in PHP via AjaxCrud

Kelvin Tan user avatar by
Kelvin Tan
·
Oct. 23, 11 · Web Dev Zone · Interview
Like (0)
Save
Tweet
11.38K Views

Join the DZone community and get the full member experience.

Join For Free

I recently discovered an Ajax CRUD library which makes CRUD operations positively painless: AjaxCRUD

Its features include:

- displaying list in an inline-editable table
- generates a create form
- all operations (add,edit,delete) handled via ajax
- supports 1:many relations
- only 1 class to include!!

I highly recommend you try it out!

Here is the example code:

 

# the code for the class
include ('ajaxCRUD.class.php');

# this one line of code is how you implement the class

$tblCustomer = new ajaxCRUD("Customer",
"tblCustomer", "pkCustomerID");

# don't show the primary key in the table

$tblCustomer->omitPrimaryKey();

# my db fields all have prefixes;
# display headers as reasonable titles

$tblCustomer->displayAs("fldFName", "First");

$tblCustomer->displayAs("fldLName", "Last");

$tblCustomer->displayAs("fldPaysBy", "Pays By");

$tblCustomer->displayAs("fldDescription", "Customer Info");

# set the height for my textarea

$tblCustomer->setTextareaHeight('fldDescription', 100);

# define allowable fields for my dropdown fields


# (this can also be done for a pk/fk relationship)

$values = array("Cash", "Credit Card", "Paypal");

$tblCustomer->defineAllowableValues("fldPaysBy", $values);

# add the filter box (above the table)

$tblCustomer->addAjaxFilterBox("fldFName");

# actually show to the table

$tblCustomer->showTable();
 
 

 

Source: http://www.supermind.org/blog/998/painless-crud-in-php-via-ajaxcrud
PHP

Opinions expressed by DZone contributors are their own.

Popular on DZone

  • Everything I Needed to Know About Observability, I Learned from ‘Bewitched’
  • How to Handle Early Startup Technical Debt (Or Just Avoid it Entirely)
  • Use Lambda Function URL To Write a Serverless App Backed by DynamoDB
  • A Simple Guide to Heaps, Stacks, References, and Values in JavaScript

Comments

Web Dev Partner Resources

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • MVB Program
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com
  • +1 (919) 678-0300

Let's be friends:

DZone.com is powered by 

AnswerHub logo