ajaxCRUD™ is an open-source PHP class which allows you to connect to a mySQL database table and easily perform the necessary CRUD operations (create, read, update, & delete rows). Use this tool to view data in your table, add rows. edit content, and delete rows at the click of a button (and no page reloading due to ajax).
Ever needed to provide easy “admin” access to a database table, but don’t have the time/budget to code all the necessary actions you need (inserts, updates, deletes, etc...)? This PHP class allows you (and/or your clients) to get direct access to your data with a few lines of code. Short story: save time!
Try Adding, Editing (clicking on the field), or Deleting a record
# include this file at the very top of your script
require_once('preheader.php');
# 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("fldPhone", "Phone");
$tblCustomer->displayAs("fldZip", "Zip");
# 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");
# add validation to certain fields (via jquery in validation.js)
$tblCustomer->modifyFieldWithClass("fldPhone", "phone");
$tblCustomer->modifyFieldWithClass("fldZip", "zip");
# actually show to the table
$tblCustomer->showTable();
CREATE TABLE tblCustomer(
pkCustomerID INT PRIMARY KEY AUTO_INCREMENT,
fldFName VARCHAR(40),
fldLName VARCHAR(40),
fldPaysBy VARCHAR(20),
fldPhone VARCHAR(15),
fldZip VARCHAR(5),
);
4 files! Installs in seconds. The CSS, field validation, and table display is completely customizable.