PHP Classes

New AJAX Sortable: Display and edit MySQL data in a table using AJAX

Recommend this page to a friend!
  Info   View files View files (8)   DownloadInstall with Composer Download .zip   Reputation   Support forum (4)   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 61%Total: 5,289 All time: 486 This week: 113Up
Version License PHP version Categories
newajaxsortable 1.0.0GNU General Publi...5HTML, PHP 5, AJAX
Description Author

This class can be used to display and edit data from MySQL table records in HTML table using AJAX to avoid page reloading.

It generates an HTML table with data from a MySQL database .

The class also generates the necessary Javascript to edit the table cells and interact with the server via AJAX to be able to update the table records with the values of the changed HTML table cells.

Picture of red_owl
Name: red_owl <contact>
Classes: 1 package by
Country: Italy Italy
Age: ???
All time rank: 56321 in Italy Italy
Week rank: 606 Down25 in Italy Italy Down

Class : clsAJAX

Manage data in grid class is demonstration of Rich Internet Applications that can manage a grid data without reloading the entire page. It manages the record like a sheet. You can look and feel using css.css as per your choice. It fetches the data from database and displays it on a html page using AJAX and PHP.

For Installaton ..
	1. Run db.sql file on your local or remote database..
	2. Change the configuration settings for host, database name, username and password  inside the default constructor of clsAJAX class in getagents.php file.
	3. Run index.htm file using php compatible web server.

About myself:

I am a PHP programmer working as Sr. Developer.

Please rate this class If you find it useful. Please feel free to contact me for queries related to this class. I would feel gratefull if i can sort out your issues related to PHP.

Thanks in advance.

Neeraj Thakur
Sr.. Developer


RED OWL version:
use array to configure ajax javasrcript and table


add display record in page (not count total record in table FAST)
add array configuration witwhout limit of field
add select edit
add where in display table index.php and set field in class

read and edit confarray.php

WARNING this code is NOT secure (adapt to your program)

total line to execute script < 500

I use simple code :
very fast
__simple__ to edit and mantein
low bug

  Files folder image Files  
File Role Description
Plain text file ajax.php Class class
Plain text file confarray.php Aux. config
Plain text file css.css Data style
Plain text file getagents.php Class class
Plain text file guru.sql Data database sample
Accessible without login Plain text file index.php Example start page
Image file new_output.png Screen display
Plain text file Readme.txt Doc. info

 Version Control Unique User Downloads Download Rankings  
This week:0
All time:486
This week:113Up
User Ratings User Comments (1)
 All time
Thank you! This is a great teaching tool
9 years ago (Bridget Cox)
For more information send a message to info at phpclasses dot org.