require "menu.php"; require "class/class_firebird.php"; require "class/mysql-class.php"; $fac = new class_ibase(); $test = new class_mysql_base(); if ($_POST['zdacha']) { $test->update_excel("UPDATE excel SET type_atemp = '" . $_POST['year'] . "',date = '" . $_POST['date'] . "',lang = '" . $_POST['lang'] . "'\n ,chastuna = '" . $_POST['chastuna'] . "',potik = '" . $_POST['potik'] . "',type_sesion = '" . $_POST['zdacha'] . "' WHERE id = '" . $_GET['id'] . "'"); } //$department_kil = $test->select_excel_faculty(); /*$department = $fac->select_faculty(); $special = $fac->select_speciality();*/ echo "<br> \n <h3><center>Редагування бази Excel </h3>"; if ($_GET['id_excel']) { $log = $test->select_log("SELECT * FROM log_excel WHERE id_export_table='" . $_GET['id_excel'] . "'"); unlink($log[0]['file_path']); $test->delete_log_excel($_GET['id_excel']); } include "navigate/navigate.php"; if ($_GET['faculty'] != '' && $_GET['year'] != '') { if ($_GET['special']) { $parameter = " AND speciality_id=" . $_GET['special'] . ""; } if ($_GET['lang']) { $parameter = $parameter . " AND lang='" . $_GET['lang'] . "'"; } if ($_GET['course']) { $parameter = $parameter . " AND semester='" . $_GET['course'] . "'"; } if ($_GET['year']) { $parameter = $parameter . " AND type_atemp='" . $_GET['year'] . "'"; }