Php > Database Related

Table Drawer (Powerful table dumper)

Table Drawer (Powerful table dumper)

<?php 
     
/* 
To use, set the following variables as shown: 
$perpage = 5; 
$showPageChoice=1; 
$columns = array("thread"=>"thread link", "member"=>"member name"); 
$spacerColumn; //will add a space between rows that do not have the same value in spacerColumn, used mainly for the forums 
$columnsPre; //array that is similar in structure to columnsDisplay, but this one is eval'd BEFORE the display one, the dislpay one is echo'd 
$columnsDisplay = array("member"=>"<a href=$SITE_ROOT/viewuser.html?id=".$row["member"].">".$row["member"]."</a>"); 
$defaultSort; 
$baseSQL = "select * from $tables->forumMessages"; 

//NOTE! the columns array goes like this: REAL column name => description 
//Hides your column names for more protection against SQL attacks 
//hides your table names too 
*/ 


if ( empty($page) ) {$page = 1;} 

$finalSQL = $baseSQL; 

if ( isset($spacerColumnSort) ) 
{ 
    $finalSQL .= " order by " . $spacerColumnSort; 
    $orderSyntaxStarted=true; 
} 

if ( !empty($sort) ) 
{ 
if ( !in_array($sort, $columns) ) 
    finalizeAndDie("Invalid sort key specified; Hack attempt of type SQL-injection has been logged"); 
     
    $temp =array_keys($columns, $sort); 
     
    if ( $orderSyntaxStarted ) 
    $finalSQL .= ",". $temp[0]; 
    else 
    $finalSQL .= " order by " . $temp[0]; 
     
    $sortFlags = $sortflags; 
    if ( $sortFlags == "reverse" ) 
    $finalSQL .= " desc"; 
     
} 
else if ( isset($defaultSort) ) 
    if ( $orderSyntaxStarted ) 
    $finalSQL .= "," . $defaultSort; 
    else 
    $finalSQL .= " order by " . $defaultSort; 

$finalSQL .= " limit " . $perpage * ($page-1) . "," . $perpage; 
$saveFinalSQL = $finalSQL; 
//echo $finalSQL . '<hr>'; 
$finalSQL = mysql_query($finalSQL); 

$total = mysql_query($baseSQL); 
$sqlcount = mysql_num_rows($total); 
$pagemin = ceil($sqlcount / $perpage); 

$choosepage = "Pages: "; 
for ( $n=1; $n <= $pagemin; $n++ ) 
{ 
    if ( $n > 1 ) 
    $choosepage .= " "; 

    if ( $n == $page ) 
    $choosepage .= "<b>$n</b>"; 
    else 
    $choosepage .= "<a href='$_SERVER[PHP_SELF]?page=$n&sort=".addslashes($sort)."&sortFlags=$sortFlags'>$n</a>"; 
} 





if ( $showPageChoice == 1) 
echo $choosepage; 

//echo "</p>"; 

$keep=""; 
if ( isset($keepStatic) ) 
{     
    foreach ( $keepStatic as $t ) 
    $keep .= "$t={$$t}";     
     
    $keep .= "&"; 
} 

echo "<table border=0 cellpadding= cellspacing=5>"; 
$i=0; 
foreach ( $columns as $t ) 
{ 
    if ( $t == $sort && $sortFlags != "reverse" ) 
        $temp = "&sortflags=reverse title='Click to sort in descending order by ".addslashes($t)."'"; 
    else 
        $temp = " title='Click to sort in ascending order by ".addslashes($t)."'"; 
    echo "<th> <a href=$_SERVER[PHP_SELF]?{$keep}sort=".urlencode($t).$temp.">$t</a> </th>"; 
} 

$i=0; 
while ( $row = mysql_fetch_array($finalSQL) ) 
{ 
    if ( isset($spacerColumn) ) 
    { 
        if ( $row[$spacerColumn] != $spacerTracker || !isset($spacerTracker) ) 
        { 
            $i=0; 
            echo "<tr><td colspan=".sizeof($columns).">"; 
            //echo $spacerLabel; 
             
            $spacerEval = 'echo "' . $spacerLabel . '";'; 
            eval ($spacerEval); 
             
            echo "   </td></tr>"; 
        } 
         
        $spacerTracker=$row[$spacerColumn]; 
    } 
     
if ( $i++ % 2 == 0 ) 
echo "<tr bgcolor=B0C4DE>"; 
  else 
echo "<tr bgcolor=FOF8FF>"; 

foreach ( array_keys($columns) as $t ) 
{ 
    echo "<td>"; 
     
    if ( isset($columnsPre[$t]) ) 
    { 
        //echo $columnsPre[$t]; 
        eval($columnsPre[$t]); 
    } 
     

    if ( isset($columnsDisplay[$t]) ) 
    { 
        eval("echo ".$columnsDisplay[$t].";"); 
    } 
    else 
        echo $row[$t]; 
    echo "</td>"; 
} 
     
echo "</tr>"; 
} 
echo "</table>"; 

if ( $showPageChoice == 1) 
echo "</p>" . $choosepage; 
     

//Unitialize vars, cuz some are optional and if someone calls this page twice on a page, some variables may remain from the first call (and optional ones on teh second one will be set to the first one's settings) 
if ( isset($spacerColumn) ) unset ($spacerColumn); 
      ?>