Example #1
0
                         $runVar['counts']['now']['collections_table'] += getTableRowCount($psTableRowCount, $tbl);
                         $added = $pdo->queryOneRow(sprintf('SELECT %s AS dateadded FROM %s', $stamp, $tbl));
                         if (isset($added['dateadded']) && is_numeric($added['dateadded']) && $added['dateadded'] < $age) {
                             $age = $added['dateadded'];
                         }
                         break;
                     case strpos($tbl, 'binaries_') !== false:
                         $runVar['counts']['now']['binaries_table'] += getTableRowCount($psTableRowCount, $tbl);
                         break;
                         // This case must come before the 'parts_' one.
                     // This case must come before the 'parts_' one.
                     case strpos($tbl, 'missed_parts_') !== false:
                         $runVar['counts']['now']['missed_parts_table'] += getTableRowCount($psTableRowCount, $tbl);
                         break;
                     case strpos($tbl, 'parts_') !== false:
                         $runVar['counts']['now']['parts_table'] += getTableRowCount($psTableRowCount, $tbl);
                         break;
                     default:
                 }
             }
             $runVar['timers']['newOld']['oldestcollection'] = $age;
             //free up memory used by now stale data
             unset($age, $added, $tables);
             $runVar['timers']['query']['tpg_time'] = time() - $timer07;
             $runVar['timers']['query']['tpg1_time'] = time() - $timer01;
         }
     }
 }
 $runVar['timers']['timer2'] = time();
 //assign postprocess values from $proc
 if (is_array($proc1res)) {
Example #2
0
    return $row_cnt;
}
// List all tables under current database
echo "<h2> Database Tables Display</h2>";
$dbname = $_SESSION['dbname'];
$sql = "SHOW TABLES FROM {$dbname};";
$result = mysqli_query($conn, $sql);
if (!$result) {
    echo "DB Error, could not list tables\n";
    echo 'MySQL Error: ' . mysql_error();
    exit;
}
$_tRowCount = 1;
//...Print out all the tables
while ($row = mysqli_fetch_array($result)) {
    $_qRowCount = getTableRowCount($row[0], $conn);
    echo "<tr><td>{$_tRowCount}</td><td> {$row[0]} </td><td> {$_qRowCount} </td> </tr>\n";
    $_tRowCount = $_tRowCount + 1;
}
mysqli_free_result($result);
?>
                    </table>
                    <div id= "DBControlPannel" >
                        <h1> Database Control Panel </h1>
                        <h3> Current Database: </h3>
                        <h3> Delete Database </h3>
                        <h3> Create Database </h3>
                    </div>    
                </form>
			</div>
		</div>