PHP mysql_multi::DATABASE_LIST_SIMPLE Exemples

Exemple #1

Fichier : exec.mysql.build.php Projet : BillTheBest/1.6.x

function multi_databases_list_fill($instance_id)
{
    $prefix = "INSERT IGNORE INTO mysqldbsmulti (instance_id,databasename,TableCount,dbsize) VALUES ";
    $q = new mysql_multi($instance_id);
    $q2 = new mysql();
    $databases = $q->DATABASE_LIST_SIMPLE();
    if ($GLOBALS["VERBOSE"]) {
        echo "Found " . count($databases) . " databases\n";
    }
    while (list($database, $ligne) = each($databases)) {
        $rr = multi_databases_list_tables($instance_id, $database);
        $TableCount = $rr[0];
        $Size = $rr[1];
        if ($GLOBALS["VERBOSE"]) {
            echo "Found database `{$database}` {$TableCount} tables ({$Size})\n";
        }
        $f[] = "({$instance_id},'{$database}','{$TableCount}','{$Size}')";
    }
    if (count($f) > 0) {
        $q2->QUERY_SQL("DELETE FROM mysqldbsmulti WHERE instance_id='{$instance_id}'", "artica_backup");
        $q2->QUERY_SQL($prefix . @implode(",", $f), "artica_backup");
    }
}