What is ajaxCRUDTM?

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

Why use ajaxCRUD?

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 it!

Try Creating, Updating (clicking on the field), or Deleting a record.


FirstLastPays ByPhoneZipAction
dTjdNQKijiEjoix0')) OR 666=(SELECT 666 F dTjdNQKi Credit Card 555-666-0606 94102
dTjdNQKi38Pt5ThI')) OR 945=(SELECT 945 F dTjdNQKi Paypal 555-666-0606 94102
dTjdNQKi dTjdNQKi Cash 555-666-0606 94102
dTjdNQKi'" dTjdNQKi Cash 555-666-0606 94102
dTjdNQKi????%2527%2522'" dTjdNQKi Cash 555-666-0606 94102
@@MGkYu dTjdNQKi Cash 555-666-0606 94102
(select 198766*667891) dTjdNQKi Cash 555-666-0606 94102
(select 198766*667891 from DUAL) dTjdNQKi Cash 555-666-0606 94102
dTjdNQKi'||DBMS_PIPE.RECEIVE_MESSAGE(CHR dTjdNQKi Credit Card 555-666-0606 94102
dTjdNQKi dTjdNQKi Credit Card 555-666-0606 94102
dTjdNQKi'" dTjdNQKi Credit Card 555-666-0606 94102
dTjdNQKi????%2527%2522'" dTjdNQKi Credit Card 555-666-0606 94102
@@0AnqJ dTjdNQKi Credit Card 555-666-0606 94102
(select 198766*667891) dTjdNQKi Credit Card 555-666-0606 94102
(select 198766*667891 from DUAL) dTjdNQKi Credit Card 555-666-0606 94102
dTjdNQKi'||DBMS_PIPE.RECEIVE_MESSAGE(CHR dTjdNQKi Paypal 555-666-0606 94102
dTjdNQKi dTjdNQKi Paypal 555-666-0606 94102
dTjdNQKi'" dTjdNQKi Paypal 555-666-0606 94102
dTjdNQKi????%2527%2522'" dTjdNQKi Paypal 555-666-0606 94102
@@nKr6D dTjdNQKi Paypal 555-666-0606 94102
(select 198766*667891) dTjdNQKi Paypal 555-666-0606 94102
(select 198766*667891 from DUAL) dTjdNQKi Paypal 555-666-0606 94102
dTjdNQKi dTjdNQKi Credit Card 555-666-0606 94102
dTjdNQKi dTjdNQKi Credit Card 555-666-0606 94102
dTjdNQKi dTjdNQKi Paypal 555-666-0606 94102
dTjdNQKi dTjdNQKi Cash 555-666-0606 94102
dTjdNQKi dTjdNQKi Paypal 555-666-0606 94102
dTjdNQKi if(now()=sysdate(),sleep(15),0) Cash 555-666-0606 94102
dTjdNQKi if(now()=sysdate(),sleep(15),0) Credit Card 555-666-0606 94102
dTjdNQKi if(now()=sysdate(),sleep(15),0) Paypal 555-666-0606 94102
dTjdNQKi dTjdNQKi0'XOR(if(now()=sysdate(),sleep(1 Cash 555-666-0606 94102
dTjdNQKi dTjdNQKi0'XOR(if(now()=sysdate(),sleep(1 Credit Card 555-666-0606 94102
dTjdNQKi dTjdNQKi0'XOR(if(now()=sysdate(),sleep(1 Paypal 555-666-0606 94102
dTjdNQKi dTjdNQKi0"XOR(if(now()=sysdate(),sleep(1 Cash 555-666-0606 94102
dTjdNQKi dTjdNQKi0"XOR(if(now()=sysdate(),sleep(1 Credit Card 555-666-0606 94102
dTjdNQKi dTjdNQKi0"XOR(if(now()=sysdate(),sleep(1 Paypal 555-666-0606 94102
dTjdNQKi (select(0)from(select(sleep(15)))v)/*'+( Cash 555-666-0606 94102
dTjdNQKi (select(0)from(select(sleep(15)))v)/*'+( Credit Card 555-666-0606 94102
dTjdNQKi (select(0)from(select(sleep(15)))v)/*'+( Paypal 555-666-0606 94102
dTjdNQKi dTjdNQKi-1 waitfor delay '0:0:15' -- Cash 555-666-0606 94102
dTjdNQKi dTjdNQKi-1 waitfor delay '0:0:15' -- Credit Card 555-666-0606 94102
dTjdNQKi (select(0)from(select(sleep(15)))v)/*'+( Paypal 555-666-0606 94102
dTjdNQKi dTjdNQKivY95PAH8'; waitfor delay '0:0:15 Cash 555-666-0606 94102
dTjdNQKi dTjdNQKiVx7ydLzA'; waitfor delay '0:0:15 Credit Card 555-666-0606 94102
dTjdNQKi dTjdNQKi-1 waitfor delay '0:0:15' -- Paypal 555-666-0606 94102
dTjdNQKi dTjdNQKihsTjQt2h' OR 493=(SELECT 493 FRO Cash 555-666-0606 94102
dTjdNQKi dTjdNQKiPgcFl8JY' OR 822=(SELECT 822 FRO Credit Card 555-666-0606 94102
dTjdNQKi dTjdNQKiHaQiojaj'; waitfor delay '0:0:15 Paypal 555-666-0606 94102
dTjdNQKi dTjdNQKiGEi6NBqo') OR 666=(SELECT 666 FR Cash 555-666-0606 94102
dTjdNQKi dTjdNQKiQU1odYkI') OR 406=(SELECT 406 FR Credit Card 555-666-0606 94102

1 2 3 4 5      >> >>|




Please do not post web-links (urls) of any kind or you will be banned.


Okay, how did you do that!?

Just a few lines of code: 
# 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 validation to certain fields (via jquery in validation.js)
$tblCustomer->modifyFieldWithClass("fldPhone", "phone");
$tblCustomer->modifyFieldWithClass("fldZip", "zip");

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

DB Table for Demo Above

Here is the table used: : 
    CREATE TABLE tblCustomer(
    pkCustomerID INT PRIMARY KEY AUTO_INCREMENT,
    fldFName VARCHAR(40),
    fldLName VARCHAR(40),
    fldPaysBy VARCHAR(20),
    fldPhone VARCHAR(15),
    fldZip VARCHAR(5),
    );

Is it light? Flexible?

4 files! Installs in seconds. The CSS, field validation, and table display is completely customizable.

Ok, I’m sold. Let me try it out!

Download the code now View the Reference Material View Framework on Github View Demo outside template