PHP Classes

Advanced Grid: Display data from MySQL database in table

Recommend this page to a friend!
  Info   Screenshots   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 58%Total: 5,592 All time: 432 This week: 61Up
Version License PHP version Categories
advanced_grid 1.0GNU General Publi...3HTML, Databases
Description 

Author

This class can be used to display data from MySQL database query results in an HTML table. It can:

- Retrieve data to display executing simple or joined SQL queries
- Can display column values as links
- Can replace field values of any column
- Can have options for searching text values
- Supports column sorting and results pagination
- Can have a link column to a page for editing records
- Can delete database table rows
- Can export results in the CSV format

Picture of Camilo Alzate
Name: Camilo Alzate <contact>
Classes: 1 package by
Country: Colombia Colombia
Age: 52
All time rank: 5355 in Colombia Colombia
Week rank: 164 Up2 in Colombia Colombia Up

Details

Hi, any updates or changes, please let me know to camialza@hotmail.com. Contains explanations: Directory BD: ut_para.php : You must change the parameters there to connect to your database. bd.sql: Contains a example DB. Directory class: list.inc.php: The class lists.js: Javascript functions that are use by the class. Directory css: Style sheets Directory images: Contain all the images use by the class. Root: client_edit.php: Simple edit page example for the example_simple_query.php file. example_join_query.php: An example that show how do you can use the class with a JOIN QUERY. example_simple_query.php: An example that show how do you can use the class with a SiMPLE QUERY example_simple_query_invoice.php: Another example that is linked to example_join_query.php Excel.php: A file that is use by the class to export to excel (csv file).

Screenshots (1)  
  • advanced_grid_join
  Files folder image Files (21)  
File Role Description
Files folder imageclass (2 files)
Files folder imagedb (3 files)
Files folder imagecss (2 files)
Files folder imageimages (7 files)
Plain text file excel.php Aux. Add to the class
Plain text file readme_first.txt Doc. Readme
Plain text file example_simple_query_invoice.php Example Example simple query
Plain text file example_simple_query.php Example Example simple query
Plain text file example_join_query.php Example Join query example
Plain text file client_edit.php Example Edit client simple example

  Files folder image Files (21)  /  class  
File Role Description
  Plain text file lists.js Data Javascript functions used by the class
  Plain text file lists.inc.php Class The class

  Files folder image Files (21)  /  db  
File Role Description
  Plain text file db.sql Data Example database
  Plain text file ut_con.php Class Connect to database
  Plain text file ut_para.php Conf. Connect to database

  Files folder image Files (21)  /  css  
File Role Description
  Plain text file links.css Data Style sheet
  Plain text file styles.css Data Style sheet

  Files folder image Files (21)  /  images  
File Role Description
  Image file b_drop.png Icon Image
  Image file b_edit.png Icon Image
  Image file impresora.gif Icon Image
  Image file s_asc.png Icon Image
  Image file s_desc.png Icon Image
  Image file tbl_error.png Icon Image
  Image file tbl_th.png Icon Image

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:5,592
This week:0
All time:432
This week:61Up
User Ratings User Comments (2)
 All time
Utility:75%StarStarStarStar
Consistency:61%StarStarStarStar
Documentation:72%StarStarStarStar
Examples:75%StarStarStarStar
Tests:-
Videos:-
Overall:58%StarStarStar
Rank:1527
 
Actually the package need to be updated before any usage in t...
7 years ago (zinsou A.A.E.Moïse)
42%StarStarStar
BUEN TRABAJO POR PARTE DEL AUTOR
11 years ago (gabriel rendon)
57%StarStarStar