} else { $err = 2; } } if ($t) { downloadaFile(); } else { header("Location: ./dwn1.php?err={$err}"); } break; case 'getitemcount': getItemCount(); echo "\n----------------------------------------------------------------------------------------------------\n"; break; case 'getitemlist': getItemsList(); echo "\n----------------------------------------------------------------------------------------------------\n"; break; case 'getiteminfo': getItemInfo(); echo "\n----------------------------------------------------------------------------------------------------\n"; break; case 'changeexpiration': changeExpiration(); echo "\n----------------------------------------------------------------------------------------------------\n"; break; case 'deleteitem': deleteItem(); echo "\n----------------------------------------------------------------------------------------------------\n"; break; }
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); } }
$item = $_GET['item']; 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); }