Database - Creating Sorted Reports For MySQL Databases With HTML/PHP

SignalQ Sites:
NetAdminTools - Coprolite - NoNIC - SpotBridge - NAW
RoboCoop - AreWeDown - SolarPower - SysAdminTools
Xfig - Gold Loaf - GeekPapa - FixGMC - MCJ - FixRambler

Categories:
·GNU/Linux
·Homebrew designs
·Perl
·Administration
·Backup/Recovery
·Bugs/Fixes
·Certification
·Database
·Email
·File/Print
·Hardware
·Information Grab Bag
·Interoperability
·GNU/Linux ABCs
·Monitoring
·Name Resolution
·Network Services
·Networking
·Remote Control
·Security
·Desktop
·Web
·BSD
·Solaris
·GIAGD
·REALbasic
·All Categories

Creating Sorted Reports For MySQL Databases With HTML/PHP
Topic: Database Posted:2004-01-04
Printer Friendly:

Do you have a fondness for greenbar? Well, here is a report that alternates colors in a similar fashion. Woohoo!! Greenbar!!! See this article for details on the database we are running the report against, and our other articles on HTML/PHP. A book we like that really helped us is Web Database Applications with PHP & MySQL. OK. Code first:

<html>
<head>
<title>SystemsDoc</title>
</head>
<body bgcolor="white">
<?php
require_once("config.php");
$db1=mysql_connect($dbhost, $dbuname, $dbpass);
mysql_select_db("sysops");
$query="SELECT UID, deploy_date,machname,phone,assetnum,manu,model,sysversion 
FROM systemsdoc ORDER BY manu";
$result = mysql_query($query);
echo "<a href=\"index.html\">Click here</a> to return to SysOps";
echo "<table border=\"0\">";
$j=true;
while ($row = mysql_fetch_row($result))
{
if($j)
$j=false;
else 
$j=true;        
echo "<tr>";
for ($i=0;$i<mysql_num_fields($result);$i++){
if ($j){
echo "<td bgcolor=\"#CCFF99\">";
}
if (!$j){
echo "<td bgcolor=\"#FFFFCC\">";
}
echo $row[$i];
echo "</td>";
}
}
echo "</table>";
mysql_close($db1);
?>
</body>
</html>

Here is what this looks like:

Mmmmmmm... greenbar goodness. I think I might die from pleasure.

Please read our Terms of Use
Microsoft, Windows, Windows XP, Windows 2003, Windows 2000, and NT are either trademarks or registered trademarks of Microsoft Corporation. NetAdminTools.com is not affiliated with Microsoft Corporation. Linux is a registered trademark of Linus Torvalds, and refers to the Linux kernel. The operating system of most distributions that contain the Linux kernel is GNU/Linux. All logos and trademarks in this site are property of their respective owner. Copyright 1997-2008 NetAdminTools.com

Created by:

MCJ CMS