function dbConnect()
{
// $hostname='108.2.206.24:3306';
// $dbname='lvarcftp_test';
// $user = '******';
// $pwd = 'RW22qhHO62HO';
$hostname = '198.71.227.91:3306';
$dbname = 'w3oiworkinprog';
$user = '******';
$pwd = 'bV34ne3&';
// Connection code
$conn = _mysql_connect($hostname, $user, $pwd);
if (!$conn) {
header("Location: /unavailable.html");
exit;
}
_mysql_select_db($conn, $dbname);
return $conn;
}
function dbConnect()
{
// Production info
$hostname = 'localhost:3306';
$dbname = 'lvarcftp_w3oi';
$user = '******';
$pwd = 'kzWwv_lMPLo@';
// Development info
// $hostname = '198.71.227.91:3306';
// $dbname = 'W3OI';
// $user = '******';
// $pwd = '146.94';
// Connection code
$conn = _mysql_connect($hostname, $user, $pwd);
if (!$conn) {
header("Location: /unavailable.html");
exit;
}
_mysql_select_db($conn, $dbname);
return $conn;
}
function showTableStatus($db)
{
$size = 0;
$out = "";
start_table();
row1($db, 15);
row_array(array("Name", "Engine", "Version", "Row Format", "Rows", "Avg Row Length (KB)", "Data Length (MB)", "Max Data Length (MB)", "Index Length (MB)", "Data free (MB)", "Create Time", "Update Time", "Check Time", "Create Options", "Comment"));
_mysql_select_db($db);
$result = _mysql_query("show table status");
while ($row = _mysql_fetch_array($result)) {
$size += $row["Data_length"] + $row["Index_length"];
$engine = $row["Engine"];
if (!$engine) {
$engine = $row["Type"];
}
row_array(array($row["Name"], $engine, $row["Version"], $row["Row_format"], $row["Rows"], round($row["Avg_row_length"] / 1024, 2), round($row["Data_length"] / (1024 * 1024), 2), round($row["Max_data_length"] / (1024 * 1024), 2), round($row["Index_length"] / (1024 * 1024), 2), round($row["Data_free"] / (1024 * 1024), 2), $row["Create_time"], $row["Update_time"], $row["Check_time"], $row["Create_options"], $row["Comment"]));
}
$size = round($size / 1024 / 1024, 1);
row2("Total Table Sizes (MB)", $size);
end_table();
echo "<BR><BR>";
}
