<?php
$path = $_SERVER['DOCUMENT_ROOT'];
header('Content-Type: application/json');
require $path . '/php/dbConnect.php';
if (isset($_GET['translationid'])) {
$id = $_GET['translationid'];
$sql = "SELECT * FROM translations WHERE translationid ='{$id}'";
$result = mysqli_query($link, $sql) or die(mysql_error());
$rows = array();
while ($row = mysqli_fetch_assoc($result)) {
$rows['item'] = $row;
}
echo json_encode($rows);
}
if (isset($_GET['getfields'])) {
if ($_GET['getfields'] == 'true') {
getRidOfColumns($link);
}
}
function getRidOfColumns($link)
{
$sql = "SHOW COLUMNS FROM translations";
$result = mysqli_query($link, $sql) or die(mysql_error());
$list = array();
while ($row = mysqli_fetch_array($result)) {
$list[] = array('Type' => $row['Type'], 'Field' => $row['Field']);
}
echo json_encode($list);
}
if (isset($_GET['item'])) {
$item = $_GET['item'];
if ($item == 'combo') {
$file = $_GET['file'];
$page = getUsingTable(substr($file, 0, -4), $link);
function getItemsList($page, $link)
{
$i = 0;
$sql = "SELECT * FROM {$page}";
$result = mysqli_query($link, $sql) or die(mysql_error());
while ($row = mysqli_fetch_array($result)) {
$list[] = $row;
}
echo json_encode($list, JSON_PRETTY_PRINT);
}
getItemsList($page, $link);
} else {
function getRidOfColumns($table, $link)
{
$sql = "SHOW COLUMNS FROM {$table}";
$result = mysqli_query($link, $sql) or die(mysql_error());
$list = array();
while ($row = mysqli_fetch_array($result)) {
$list[] = array('Type' => $row['Type'], 'Field' => $row['Field']);
}
echo json_encode($list, JSON_PRETTY_PRINT);
}
$page = getUsingTable(substr($item, 0, -4), $link);
getRidOfColumns($page, $link);
}
}
if ($item == 'combo') {
$file = $_GET['file'];
$page = getUsingTable(substr($file, 0, -4), $link);
function getItemsList($page, $link, $translationsTable)
{
$list = array();
$sql = "SELECT DISTINCT * FROM {$page}, {$translationsTable} where description = translationid ";
$result = mysqli_query($link, $sql) or die(mysql_error($link));
$i = 0;
while ($row = mysqli_fetch_array($result)) {
$list[] = $row;
}
return $list;
}
echo json_encode(getItemsList($page, $link, $translationsTable));
} else {
function getRidOfColumns($table, $link, $translationsTable, $databaseScheme)
{
// $sql = "SHOW COLUMNS FROM $table, translations";
$sql = "SELECT COLUMN_NAME, COLUMN_TYPE FROM `information_schema`.`columns` WHERE `table_schema` = '{$databaseScheme}' and `table_name` in ('{$table}', '{$translationsTable}')";
$result = mysqli_query($link, $sql) or die(mysql_error());
$list = array();
while ($row = mysqli_fetch_array($result)) {
$list[] = array('Type' => $row['COLUMN_TYPE'], 'Field' => $row['COLUMN_NAME']);
}
echo json_encode($list);
}
$page = getUsingTable(substr($item, 0, -4), $link);
getRidOfColumns($page, $link, $translationsTable, $databaseScheme);
}
}
