PHP Classes

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

Recommend this page to a friend!
  Info   View files Example   View files View files (20)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 51%Total: 1,427 This week: 1All time: 2,733 This week: 560Up
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  
Name: Sergio Soares <contact>
Classes: 3 packages by
Country: Portugal Portugal
Age: 46
All time rank: 150920 in Portugal Portugal
Week rank: 416 Up4 in Portugal Portugal Up

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

  Files folder image Files  /  images  
File Role Description
  Image file 1.jpg Icon Icon image
  Image file 10.jpg Icon Icon image
  Image file 11.jpg Icon Icon image
  Image file 12.jpg Icon Icon image
  Image file 2.jpg Icon Icon image
  Image file 3.jpg Icon Icon image
  Image file 4.jpg Icon Icon image
  Image file 5.jpg Icon Icon image
  Image file 6.jpg Icon Icon image
  Image file 7.jpg Icon Icon image
  Image file 8.jpg Icon Icon image
  Image file 9.jpg Icon Icon image

 Version Control Unique User Downloads Download Rankings  
 95%
Total:1,427
This week:1
All time:2,733
This week:560Up
User Ratings User Comments (1)
 All time
Utility:75%StarStarStarStar
Consistency:66%StarStarStarStar
Documentation:-
Examples:75%StarStarStarStar
Tests:-
Videos:-
Overall:51%StarStarStar
Rank:2473
 
i like that dude.
12 years ago (Asif Rizvi)
67%StarStarStarStar