PHP Classes

Advanced Grid: Display data from MySQL database in table

Recommend this page to a friend!

  Author Author  
Picture of Camilo Alzate
Name: Camilo Alzate <contact>
Classes: 1 package by
Country: Colombia Colombia
Age: 50
All time rank: 5345 in Colombia Colombia
Week rank: 496 Up6 in Colombia Colombia Down


  Detailed description   Download Download .zip .tar.gz   Install with Composer Install with Composer  
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

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

  Classes of Camilo Alzate  >  Advanced Grid  >  Download Download .zip .tar.gz  >  Support forum Support forum (7)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: Advanced Grid
Base name: advanced_grid
Description: Display data from MySQL database in table
Version: 1.0
PHP version: 3
License: GNU General Public License (GPL)
All time users: 5585 users
All time rank: 432
Week users: 0 users
Week rank: 80 Equal
 
  Groups   Screenshots Screenshots   Rate classes User ratings   Applications   Files Files  

  Groups  
Group folder image HTML HTML generation and processing View top rated classes
Group folder image Databases Database management, accessing and searching View top rated classes

  Files folder image Screenshots  
advanced_grid_join
File Role Description
Accessible without login Image file advanced_grid_join Screen Join query and links inside and outside the grid


  User ratings  
RatingsUtility Consistency Documentation Examples Tests Videos Overall Rank
All time: Sufficient (78%) Sufficient (62%) Sufficient (75%) Sufficient (78%) - - Sufficient (60%) 1300
Month: Not yet rated by the users

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.

  Files folder image Files  
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  /  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  /  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  /  css  
File Role Description
  Plain text file links.css Data Style sheet
  Plain text file styles.css Data Style sheet

  Files folder image Files  /  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

Install with Composer Install with Composer - Download Download all files: advanced_grid.tar.gz advanced_grid.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.
  Files folder image Files  
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  /  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  /  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  /  css  
File Role Description
  Plain text file links.css Data Style sheet
  Plain text file styles.css Data Style sheet

  Files folder image Files  /  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

Install with Composer Install with Composer - Download Download all files: advanced_grid.tar.gz advanced_grid.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.