<?php
/**
* Created by IntelliJ IDEA.
* User: Javad
* Date: 2019-10-06
* Time: 7:28 PM
* To change this template use File | Settings | Editor | File and Code Templates.
*/
header('Content-Type: text/html; charset=utf-8');
require_once('config.php');
require_once('db.php');
global $config;
$db = Db::getInstance();
$table_records = $db->query("SHOW TABLE STATUS", array());
$index = 0;
foreach ($table_records as $table) {
$column_records = $db->query("SHOW COLUMNS FROM " . $config['db']['name'] . '.' . $table['Name'], array()); //EXPLAIN $table['Name'] //DESCRIBE $table['Name']
$table_records[$index]['column_count'] = sizeof($column_records);
$table_records[$index]['column'] = $column_records;
++$index;
}
$data['table_count'] = sizeof($table_records);
$data['table'] = $table_records;
echo json_encode($data);
