<?

include $_SERVER['DOCUMENT_ROOT'] . "/WebBuilder/WebApp.class.php";
$db = new DBMain();
$results = $db->query("SELECT COLUMN_NAME  FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = '{$_GET['table_name']}' and table_schema = '{$_SESSION['db_name']}'");
$log = "";
while ($row = $results->fetch_assoc()) {
    $column_name = $row['COLUMN_NAME'];
    if ($column_name == 'record_id') {
        continue;
    } else {
        $name_arr[] = $column_name;
        $var_arr[] = $_GET["$column_name"];
        $log = $log . " " . $column_name . " -> " . $_GET["$column_name"] . " , ";
    }
}


$index = 0;
while ($index <= count($name_arr)) {
    if (strlen($name_arr[$index]) < 2) {
    } else {
        $string_1[] = "`" . $name_arr[$index] . "`";
        if ($name_arr[$index] == 'password') {

            $var_arr[$index] = hash('sha256', $var_arr[$index]);
        }

        $string_2[] = "'" . $var_arr[$index] . "'";
    }

    $index++;
}


$insert_event = $db->insert("INSERT INTO `{$_GET['table_name']}` (" . implode(",", $string_1) . ") VALUES (" . implode(",", $string_2) . ")");

if ($insert_event) {
    $db->add_log("INSERTED RECORD WITH $log", $_GET['table_name'], $insert_event);
    echo 1;
} else {
    echo "INSERT INTO `{$_GET['table_name']}` (" . implode(",", $string_1) . ") VALUES (" . implode(",", $string_2) . ")";
    $db->add_log("FAILED INSERT AT {$_GET['table_name']} WITH $log");
}