PHP Classes

PHP Datagrid with Navigator: Show MySQL query results in HTML data grid

Recommend this page to a friend!
     
  Info   Example   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 51%Total: 1,428 All time: 2,733 This week: 46Up
Version License PHP version Categories
data-grid 2.62Freeware4HTML, Databases
Description 

Author

This class can display MySQL query results in a HTML table.

It can execute a MySQL query and generate a HTML table that displays the table record column values.

The class can also display links to browse the listing split in multiple pages.

Picture of Sergio Soares
  Performance   Level  

 

Example

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
<meta http-equiv="Content-Style-Type" content="text/css" />

<title>
.:::DataGrid_Nav 2.0 Author: S&eacute;rgio Soares 2016 for PHP 3:::.
</title>

<link rel="stylesheet" href="style.css" type="text/css" media="screen" />

</head>

<body>
<table>
    <tr>
        <td align="center"><font color="#8585ad"><p><h1><b>PHP DataGrid with Navigator 2.0</b></h1></p>
                            <p><h3>Update for PHP 3</h3></p>
                            <h4><p>Author: S&eacute;rgio Soares 2016</p></h4>
                            <p>It's freeware, if you like it, you can use it in own your projects!</p>
                            <p><b>Please consider Donating through</b></p>
                            <p><h2>PAYPAL</h2></p>
                            <p> In order to continue developping this class!</p></h4></font>
                            <p>&nbsp;</p>
            <form action="https://www.paypal.com/cgi-bin/webscr" method="post" target="_top">
            <input type="hidden" name="cmd" value="_s-xclick">
            <input type="hidden" name="hosted_button_id" value="T3W7XYMQ7K842">
            <input type="image" src="https://www.paypalobjects.com/en_GB/i/btn/btn_paynowCC_LG.gif" border="0" name="submit" alt="PayPal – The safer, easier way to pay online.">
            <img alt="" border="0" src="https://www.paypalobjects.com/pt_PT/i/scr/pixel.gif" width="1" height="1">
            </form>
            <p>&nbsp;</p>
        </td>
    </tr>
    <tr>
        <td>
       
       
<?php
/**
 * @author Sérgio Soares 2016
 *
 * email serguiomicaelo@gmail.com
 *
 * "PHP 3 datagrid with navigator 2.0"
 *
 * The class datagrid.class.php was written using PHP 3
 * You can use it at your will, it's free to use!
 *
 *ATTENTION, before you start this index.php you should start it as
 * "http://localhost/your_PHP_3_datagrid_with_navigator_20_folder/index.php?page=1&bindex=1&i=1" in the URL of
 * your Browser!!!
 *
 *
 *
 */

require("datagrid.class.php");

$page = $_GET['page'];


//parameter variables:
$rows = 4;
$cols = 2;
$paint_rows = TRUE;
$num_visible_frames = 5;

$newTable=new datagrid();

$newTable->doTable($cols, $rows, $page, $paint_rows);

$newTable->navigation($page, $num_visible_frames);

?>
</td></tr>
</table>
</body>
</html>



Details

PHP-DataGrid-with-Navigator-2.0

PHP DataGrid with Navigator 2.0 is a PHP 3 datagrid with navigator to browse datagrid pages. It performes querys in MySQL format.

Datagrid Nav 2.0 displays your querys in a configurable datagrid table.

You can configure number of rows as collums displayed, you can use 2 diferent row colors at the same grid if you want.

It has an navigator to browse the diferent grid pages. You can Customize how many page numbers are displayed in the navigator.

PHP DataGrid with Navigator 2.0 is freeware if you want to donate, the "donate.html" file has the link to donate through PayPal.

Sérgio Soares.


  Files folder image Files (20)  
File Role Description
Files folder imageimages (12 files)
Image file datagrid_nav20_screenshot.png Screen screenshot of datagrid_nav 2.0
Plain text file README.md Data Auxiliary data
Plain text file datagrid.class.php Class reviewed bug with nav and inprovment for categories
Plain text file datagrid.sql Data The sql for this example
HTML file donate.html Data Donate instructions
Plain text file index.php Example The index file
HTML file readme.doc.html Doc. Documentation
Plain text file style.css Data style

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  
 95%
Total:1,428
This week:0
All time:2,733
This week:46Up
User Ratings User Comments (1)
 All time
Utility:75%StarStarStarStar
Consistency:66%StarStarStarStar
Documentation:-
Examples:75%StarStarStarStar
Tests:-
Videos:-
Overall:51%StarStarStar
Rank:2540
 
i like that dude.
13 years ago (Asif Rizvi)
67%StarStarStarStar