Exemple #1
0
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;
}
Exemple #2
0
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>";
}