<?php
/*******************************************************
Class to display mysql data in cross-tabular format.
Made By member - http://www.naukri.com tech team.
On April 20, 2002
Please go through the Readme.txt file provided with this pack.
*******************************************************/
// Please enter your hostname, username and password
// for mysql connection.
$db=mysql_connect("<hostname>","<username>","<password>");
// Enter the database name in place of "<dbname>" below
mysql_select_db("test",$db);
// Class definition
class crosstab {
var $rowfield;
var $columnfield;
var $reffield;
var $crosstable;
// Constructor if u have username and password
function crosstab($row_field,$column_field,$ref_field,$cross_table){
$this->rowfield=$row_field;
$this->columnfield=$column_field;
$this->reffield=$ref_field;
$this->crosstable=$cross_table;
}
function show()
{
$sqlrow="SELECT distinct $this->rowfield as ROW from $this->crosstable";
$sqlcolumn="SELECT distinct $this->columnfield as COLUMN1 from $this->crosstable";
$sqlelement="SELECT count($this->reffield) as CROSSVALUE,$this->rowfield,$this->columnfield from $this->crosstable group by $this->rowfield,$this->columnfield";
$resrow=mysql_query($sqlrow) or die("could not select1 row");
$rescolumn=mysql_query($sqlcolumn) or die("could not select2 column");
$reselement=mysql_query($sqlelement) or die("could not select3 element");
@mysql_close($db);
$i=0;
while($wrow=mysql_fetch_array($resrow)){
$row[$i]=$wrow[ROW];
$i++;
}
$i=0;
while($wcolumn=mysql_fetch_array($rescolumn)){
$column[$i]=$wcolumn[COLUMN1];
$i++;
}
while($welement=mysql_fetch_array($reselement)) {
$element[$welement[$this->rowfield]][$welement[$this->columnfield]]=$welement[CROSSVALUE];
}
echo "<font face=arial><table border=1><tr><td>Field</td>";
for ($n=0;$n<=(count($column)-1);$n++){
echo "<td>".$column[$n]."</td>";
}
echo "</tr>";
for ($m=0;$m<=(count($row)-1);$m++){
echo "<tr>";
for ($n=0;$n<=(count($column)-1);$n++){
echo "<td>".$column[$n]."<td>";
if($n==0)
echo "<td>".$row[$m]."</td>";
if($element[$row[$m]][$column[$n]]){
echo "<td>".$element[$row[$m]][$column[$n]]."</td>";
$total[$n]=$total[$n] + $element[$row[$m]][$column[$n]];
$ttotal=$ttotal+$element[$row[$m]][$column[$n]];
}
else
echo "<td>0</td>";
}
echo "</tr>\n";
}
echo "<td>Total</td>";
for ($n=0;$n<=(count($column)-1);$n++){
echo "<td><b><font size=-1>".$total[$n]."</font></b></td>";
}
echo "</tr>";
echo "</table>";
echo " Total Records $ttotal";
// End of method
}
// End of Class
}
?>
|
Download
