<?php
namespace MySQLMigrationBridge;
require_once __DIR__ . "/../../bootstrap.php";
require "common.php";
require "vendor/phpQuery/phpQuery-onefile.php";
$hbase_panel = \phpQuery::newDocumentHTML(file_get_contents("http://" . DB_HOST . ":60010/master-status"));
//print_r($hbase_panel);
$hbase_attr_table = null;
$hbase_panel["table"]->filter(":first")->addClass("table table-striped table-hover")->toReference($hbase_attr_table);
$hbase_tables = fetch_all_assoc(mysql_query("SHOW TABLES"));
$uri_param_table = isset($_GET["table"]) ? $_GET["table"] : null;
$uri_param_func = isset($_GET["func"]) ? $_GET["func"] : null;
$uri_param_query_post = isset($_GET["query_post"]) ? $_GET["query_post"] : null;
$colnames_post = isset($_POST["colname"]) ? $_POST["colname"] : null;
$tablenames_post = isset($_POST["tablename"]) ? $_POST["tablename"] : null;
$act = isset($_GET["act"]) ? $_GET["act"] : null;
if (!empty($act) && $act == "submit") {
echo ";;;;;;;;;;;;;;;;;;;";
print_r($colnames_post);
print_r($tablenames_post);
// put 'tbl1', 'row1', 'cf1:column1', 'v1'
$cmd = "create '{$tablenames_post}', 'mysql'\n";
foreach ($colnames_post as $col) {
$cmd .= "put '{$tablenames_post}', 'row1', 'mysql:{$col}', ''";
}
//file_put_contents("tmp/create-table.txt", $cmd);
//exec("hbase shell < tmp/create-table.txt");
MMB::createTable($tablenames_post, "mysql");
$cols = implode(",", $colnames_post);
<?php
date_default_timezone_set("America/Chicago");
$mysqli = new mysqli("localhost", "root", "", "yt_viewer");
$timestamp = mktime(0, 0, 0, date("m"), date("d") - 7, date("Y"));
$today = new DateTime(date("m/d/Y"));
$seven_date = new DateTime(date("m/d/Y", $timestamp));
$result = fetch_all_assoc($mysqli, "SELECT * FROM analytics");
foreach ($result as $key => $value) {
list($year, $month, $day) = explode("-", $value['date']);
$date = new DateTime(date("m/d/Y", mktime(0, 0, 0, $month, $day, $year)));
if ($date < $seven_date || $date > $today || $date == new DateTime(date("m/d/Y", mktime(0, 0, 0, 12, 31, 9999)))) {
unset($result[$key]);
}
}
echo json_encode(array_reverse($result));
$mysqli->close();
function fetch_all_assoc($mysqli, $query)
{
$result = $mysqli->query($query);
$assoc = array();
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
$assoc[] = $row;
}
$result->close();
return $assoc;
}
