PHP Classes

SQL to HTML Table: Generate HTML tables from SQL query results

Recommend this page to a friend!
     
  Info   Example   Screenshots   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 200 All time: 8,482 This week: 74Up
Version License PHP version Categories
sqltotable 1.0.0MIT/X Consortium ...5HTML, PHP 5, Databases
Description 

Author

Wisnu Satriyadi

This class can generate HTML tables from SQL query results.

It can execute a given SQL query to retrieve results from MySQL table.

The class renders a HTML table using the query results column names as table headers and the the query result rows as table rows.

Picture of Wisnu Satriyadi
  Performance   Level  
Name: Wisnu Satriyadi <contact>
Classes: 1 package by
Country: Indonesia Indonesia
Age: 33
All time rank: 414672 in Indonesia Indonesia
Week rank: 195 Up3 in Indonesia Indonesia Up

Level 1 Star

Example

<?php
include "db.php";

$db = new showtable;
$db->host = "localhost";
$db->username = "root";
$db->password = "";
$db->db = "aaaa";

$db->sql = "select * from tb_campur";
//$db->thead = array("ID","NAME", "GENDER","ADDRESS", "RT", "RW", "DATE", "NEW ADDRESS", "TYPE");
$db->showtabel();
?>

Screenshots (1)  
  • scr
  Files folder image Files (3)  
File Role Description
Plain text file db.php Class Main Class
Accessible without login Plain text file example.php Example example file

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
Downloadsqltotable-2017-05-24.zip 11KB
Downloadsqltotable-2017-05-24.tar.gz
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:200
This week:0
All time:8,482
This week:74Up

  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.