PHP Classes

PHP Datagrid with Navigation: Show a datagrid of products retrieved from MySQL

Recommend this page to a friend!
  Info   View files Example   View files View files (42)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 72%Total: 543 This week: 1All time: 5,562 This week: 560Up
Version License PHP version Categories
datagrid-navigation 3.4Freeware5HTML, PHP 5, Databases, PHP 7
Description 

Author

This class can show a datagrid of products retrieved from MySQL.

It connects to a MySQL database and executes a query to retrieve a listing a of product details.

The class displays the product information in a datagrid table.

The listing of products is paginated with links to browse other pages. The number of page links can be limited.

The number of columns and the colors of the rows are configurable parameters.

This package versions of the class for either PHP 7 and PHP 5.

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: 411 Up3 in Portugal Portugal Up

Example

<?php
declare(strict_types=1);
?>
<!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 3.0 Author: S&eacute;rgio Soares 2016 Update for PHP 7.0.4:::.
</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 3.0</b></h1></p>
                            <p><h3>Update for PHP 7.0.4</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="LZ9V7TBL4STZ6">
            <table>
            <tr><td><input type="hidden" name="on0" value="Quantity">Quantity</td></tr><tr><td><select name="os0">
                <option value="Option 1">Option 1 €2,50 EUR</option>
                <option value="Option 2">Option 2 €3,50 EUR</option>
                <option value="Option 3">Option 3 €5,00 EUR</option>
            </select> </td></tr>
            </table>
            <input type="hidden" name="currency_code" value="EUR">
            <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 Sergio Soares 2016
 *
 * email serguiomicaelo@gmail.com
 *
 * "PHP datagrid with navigator 3.0"
 *
 * The class datagrid.class.php was written using PHP 7.0.4
 * 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_datagrid_nav_30_folder/index.php?page=1&bindex=1&i=1" in the URL of
 * your Browser!!!
 *
 *
 *
 */

require("datagrid.class.php");



//parameter variables:
$page = $_GET['page'] ?? 1; //PHP 7 ONLY!
//$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;


$rows = 4;
$cols = 2;
$multipleColors = TRUE;
$num_visible_frames = 5;

//instanciate datagrid class.
$newTable=new datagrid((int)$page,$rows,$cols,$multipleColors,$num_visible_frames);
//renders the datagrid.
$newTable->drawTable();
//renders the navigator.
$newTable->navigator();

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



Details

Sergio-Soares

PHP DataGrid with Navigator 3.0 is a PHP 5 and PHP 7.0.4 datagrid with navigator to browse datagrid pages. It performes querys in MySQL format.

PHP DataGrid with Navigator 3.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 3.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 imagedatagrid-with-navig-30-php5 (6 files, 2 directories)
Files folder imagedatagrid-with-navig-30-php7 (6 files, 2 directories)
Image file datagrid_nav30_screenshot.png Screen php_datagrid_with_navigator_30_screenshot.png
Plain text file README.md Data Auxiliary data

  Files folder image Files  /  datagrid-with-navig-30-php5  
File Role Description
Files folder imageimages (12 files)
Files folder imageinc (2 files)
  Plain text file datagrid.class.php Class Class source
  Plain text file datagrid.sql Data Auxiliary data
  HTML file donate.html Doc. Documentation
  Plain text file index.php Example Example script
  HTML file readme.doc.html Doc. Documentation
  Plain text file style.css Data Auxiliary data

  Files folder image Files  /  datagrid-with-navig-30-php5  /  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

  Files folder image Files  /  datagrid-with-navig-30-php5  /  inc  
File Role Description
  Plain text file basicmysql.class.php Class Class source
  Plain text file global.inc.php Example Example script

  Files folder image Files  /  datagrid-with-navig-30-php7  
File Role Description
Files folder imageimages (12 files)
Files folder imageinc (2 files)
  Plain text file datagrid.class.php Class Class source
  Plain text file datagrid.sql Data Auxiliary data
  HTML file donate.html Doc. Documentation
  HTML file readme.doc.html Doc. Documentation
  Plain text file style.css Data Auxiliary data
  Plain text file index.php Example Example script

  Files folder image Files  /  datagrid-with-navig-30-php7  /  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

  Files folder image Files  /  datagrid-with-navig-30-php7  /  inc  
File Role Description
  Plain text file basicmysql.class.php Class Class source
  Plain text file global.inc.php Example Example script

 Version Control Unique User Downloads Download Rankings  
 97%
Total:543
This week:1
All time:5,562
This week:560Up
 User Ratings  
 
 All time
Utility:91%StarStarStarStarStar
Consistency:91%StarStarStarStarStar
Documentation:83%StarStarStarStarStar
Examples:91%StarStarStarStarStar
Tests:-
Videos:-
Overall:72%StarStarStarStar
Rank:184