Просмотр архива Databasr MySQL Administration Interface


<?php

class Index extends MY_Controller
{
    function __construct()
    {
        parent::__construct();
    }

    public function index()
    {
        $this->displayAlert();

        $tables = $this->db->query("SHOW TABLE STATUS")->result_array();
        $this->template->assign('tables', $tables);
        
        // total size
        $totalSize = 0;
        foreach($tables as $table) {
            $totalSize += $table['Data_length'];
        }
        
        $totalSize = $this->formatBytes($totalSize);
        $this->template->assign('totalDatabaseSize', $totalSize);
        
        // server information
        $mysqlServerVersion = $this->db->call_function('get_client_info');
        $this->template->assign('mysqlServerVersion', $mysqlServerVersion);
        
        $this->template->view('index/index');
    }
}