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,282 All time: 483 This week: 228Up
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: 55621 in Italy Italy
Week rank: 530 Up19 in Italy Italy Up

 

Details
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
Emails:
	neerajth@gmail.com
	neeraj_th@yahoo.com



-------------------------------------------------------------------------------------


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

changelog:

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

E-mail: info@help32.com
  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  
 0%
Total:5,282
This week:0
All time:483
This week:228Up
User Ratings User Comments (1)
 All time
Utility:80%StarStarStarStarStar
Consistency:75%StarStarStarStar
Documentation:72%StarStarStarStar
Examples:70%StarStarStarStar
Tests:-
Videos:-
Overall:61%StarStarStarStar
Rank:1182
 
Thank you! This is a great teaching tool
8 years ago (Bridget Cox)
77%StarStarStarStar
 

For more information send a message to info at phpclasses dot org.