<?php
/* ===================================================================== *\
# #
# +-----------------------------------------------------------+ #
# | Author: Juan Manuel Sueiro | #
# | Contact: <jmsueiro[at]gmail.com> | #
# | httpLink: <http://tziweblog.com.ar> | #
# | Desc: reveal data of mysql db | #
# +-----------------------------------------------------------+ #
# #
\* ===================================================================== */
require_once("SimpleConstructorClass.php");
/* ===================================================================== */
/* Put here the user data to access your database
/* ===================================================================== */
$cfg['dbUser'] = 'root';
$cfg['dbPass'] = '';
$cfg['dbHost'] = 'localhost';
$cfg['dbName'] = '';
/* ===================================================================== */
/* Table formating
/* ===================================================================== */
$cfg['CSSClass'] = 'tahoma11'; //CSS font class
$cfg['borderColorLight'] = '#336699';
$cfg['borderColorDark'] = '#000000';
$cfg['borderColor'] = '#336699';
$cfg['bgColor'] = '#336699';
$cfg['imgBackground'] = ''; //img filename and path
$cfg['align'] = 'center';
$cfg['width'] = 400;
$cfg['border'] = 1;
$cfg['cellspacing'] = 2;
$cfg['cellpadding'] = 4;
#----------------------------------------------------------------#
# [cfg]
#----------------------------------------------------------------#
$simpleSql = &New simpleConstructor;
$simpleSql->dbhost = $cfg['dbHost'];
$simpleSql->dbuser = $cfg['dbUser'];
$simpleSql->dbpass = $cfg['dbPass'];
$simpleSql->database = $cfg['dbName'];
$simpleSql->db_connect();
$arLink = array();
#----------------------------------------------------------------#
# [init]=> Begin Actions [prototype]
#----------------------------------------------------------------#
$result = mysql_list_tables($cfg['dbName']);
if($r = mysql_fetch_array($result)){
do{
$simpleSql->vclass = $cfg['CSSClass'];
$simpleSql->bordercolorlight = $cfg['borderColorLight'];
$simpleSql->bordercolordark = $cfg['borderColorDark'];
$simpleSql->bordercolor = $cfg['borderColor'];
$simpleSql->bgcolor = $cfg['bgColor'];
$simpleSql->background = $cfg['imgBackground'];
$simpleSql->align = $cfg['align'];
$simpleSql->width = $cfg['width'];
$simpleSql->border = $cfg['border'];
$simpleSql->cellspacing = $cfg['cellspacing'];
$simpleSql->cellpadding = $cfg['cellpadding'];
$simpleSql->sql = 'SELECT * from '.$r[0].' order by id desc';
array_push($arLink, '<a href="#'.$r[0].'">'.$r[0].'</a>');
$vTmp .= '<a name="'.$r[0].'"></a><span class="'.$cfg['CSSClass'].'">Data for table: '.$r[0].' | <a href="#init">top</a></span><br>';
$construct = $simpleSql->sqlExec();
if(!empty($construct)){ $vTmp .= $construct; }else{ $vTmp .= "Constructor Return : ".mysql_error().'<br>'; };
$vTmp .= '<br><br>';
} while ($r = @mysql_fetch_array($result));
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>sqlRevealer</title>
<style type="text/css">
<!--
.tahoma11 { font-family: tahoma; font-size: 11px; color: #003366; text-decoration:none; }
a:hover { font-family: tahoma; font-size: 11px; color: #336699; text-decoration:none; }
a:link { font-family: tahoma; font-size: 11px; color: #003366; text-decoration:none; }
a:visited { font-family: tahoma; font-size: 11px; color: #003366; text-decoration:none; }
-->
</style>
</head>
<body><a name="init"></a>
<span class="tahoma11">Table information for db <?php echo $cfg['dbName']?>:
<?php foreach($arLink as $lv){ echo $lv.' | '; };?>
</span><br>
<?php echo $vTmp; ?>
</body>
</html>
|
Download
